Home/Database/Advanced SQL

Advanced SQL MCQs

31 questionsDatabasePage 2 of 4

Practice free Advanced SQL multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 31 questions — no login required.

Question 10medium

A UNION query is which of the following?

⚑ Report ✎ Feedback

Question 11easy

Which of the following statements is true concerning subqueries?

⚑ Report ✎ Feedback

Question 12hard

Which of the following is a correlated subquery?

⚑ Report ✎ Feedback

Question 13easy

How many tables may be included with a join?

⚑ Report ✎ Feedback

Question 14hard

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

⚑ Report ✎ Feedback

Question 15easy

Which of the following is true concerning triggers?

⚑ Report ✎ Feedback

Question 16hard

Triggers are stored blocks of code that have to be called in order to operate.

⚑ Report ✎ Feedback

Question 17hard

The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

⚑ Report ✎ Feedback

Question 18hard

There should be one condition within the WHERE clause for each pair of tables being joined.

⚑ Report ✎ Feedback