PostgreSQL, Databases

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 of the following is not a single value function?