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.
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. |