Databases - Upwork

Question: Which of the following is not a single value function?
A
Round

B
Floor

C
Avg

D
Sqrt

E
Tan

Note: Not available
1. Report
Question: Which component of a DBMS verifies the syntax of the users query?
A
Parser

B
The database manager

C
Query optimization

D
Database administrator

Note: Not available
1. Report
Question: Every Boyce-Codd Normal Form(BCNF) is in:
A
First Normal Form

B
Second Normal Form

C
Third Normal Form

D
None of these above

Note: Not available
1. Report
Question: Which of the following values is not defined to indicate the level of the raise event?
A
DEBUG

B
ERROR

C
NOTICE

D
EXCEPTION

Note: Not available
1. Report
Question: Which character function should be used to return a specified portion of a character string?
A
CONCAT

B
LENGTH

C
SUBSTR

D
INITCAP

Note: Not available
1. Report
Question: Which authentication methods are supported by PostgreSQL?
A
Trust

B
PAM

C
LDAP

D
Radius

E
Password

Note: Not available
1. Report
Question: Which index types are supported by PostgreSQL?
A
A-tree

B
B-tree

C
GiST

D
Hash

E
GIN

F
None of these above

Note: Not available
1. Report
Question: Out of the following backup approaches, which ones are applicable to PostgreSQL?
A
SQL dump

B
File system level backup

C
Real cluste

D
Continuous archiving

E
None of these above

Note: Not available
1. Report
Question: In the following operation, which ones can trigger a trigger?
A
alte

B
insert

C
drop

D
update

E
delete

Note: Not available
1. Report
Question: Which index types support multicolumn indexes?
A
B-tree

B
GiST

C
GIN

D
Hash

E
None of these above

Note: Not available
1. Report

First Prev 43 44 45 46 47 Next Last

Question: Which of the following is not a single value function?

Question: Which component of a DBMS verifies the syntax of the users query?

Question: Every Boyce-Codd Normal Form(BCNF) is in:

Question: Which of the following values is not defined to indicate the level of the raise event?

Question: Which character function should be used to return a specified portion of a character string?

Question: Which authentication methods are supported by PostgreSQL?

Question: Which index types are supported by PostgreSQL?

Question: Out of the following backup approaches, which ones are applicable to PostgreSQL?

Question: In the following operation, which ones can trigger a trigger?

Question: Which index types support multicolumn indexes?