QUESTION NO: 1
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
Correct Answer: D
Vote an answer
QUESTION NO: 2
Which command revokes a user's privilege to update a table?
Which command revokes a user's privilege to update a table?
Correct Answer: C
Vote an answer
QUESTION NO: 3
What is the difference between UNION and UNION ALL?
What is the difference between UNION and UNION ALL?
Correct Answer: D
Vote an answer
QUESTION NO: 4
Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?
Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?
Correct Answer: C
Vote an answer
QUESTION NO: 5
What is the primary purpose of an index in SQL?
What is the primary purpose of an index in SQL?
Correct Answer: D
Vote an answer
QUESTION NO: 6
What does a Cartesian product in SQL result from?
What does a Cartesian product in SQL result from?
Correct Answer: A
Vote an answer
QUESTION NO: 7
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
Correct Answer: C
Vote an answer