CSE :: Database System 2 - CS
- Which of the following statements is true concerning subqueries?
- Which of the following is a correlated subquery?
- 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 ;
- Which of the following is true concerning triggers?
- The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
- There should be one condition within the WHERE clause for each pair of tables being joined.
- The code to create triggers and routines is stored in only one location and is administered centrally.
Whatsapp
Facebook
|
A.
Uses the result of an inner query to determine the processing of an outer query. |
|
B.
Uses the result of an outer query to determine the processing of an inner query. |
|
C.
Uses the result of an inner query to determine the processing of an inner query. |
|
D.
Uses the result of an outer query to determine the processing of an outer query. |