Advanced SQL - Practice Questions

Question 1

Which of the following is one of the basic approaches for joining tables?

Accepted Answer

Question 2

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 ;

Accepted Answer

Question 3

Embedded SQL is which of the following?

Accepted Answer

Question 4

Which of the following is a correlated subquery?

Accepted Answer

Question 5

Which of the following statements is true concerning routines and triggers?

Accepted Answer

Question 6

Which of the following is true concerning triggers?

Accepted Answer

Question 7

Which of the following is true concerning systems information in an RDBMS?

Accepted Answer

Question 8

How many tables may be included with a join?

Accepted Answer

Question 9

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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

Accepted Answer

Question 10

Which of the following statements is true concerning subqueries?

Accepted Answer