Advanced SQL Questions

• Which of the following is true concerning triggers?
• What type of join is needed when you wish to include rows that do not have matching values?
• What type of join is needed when you wish to return rows that do have matching values?
• Embedded SQL is which of the following?
• Which of the following statements is true concerning subqueries?
• 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
• A UNION query is which of the following?
• Which of the following is one of the basic approaches for joining tables?
• Which of the following is true concerning a procedure?
• Which of the following is true concerning systems information in an RDBMS?
• A CASE SQL statement is which of the following?
• Which of the following statements is true concerning routines and triggers?
• 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 ;
• How many tables may be included with a join?
• Which of the following is a correlated subquery?
• 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.
• A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
• A correlated subquery is where the outer query depends on data from the inner query.
• The code to create triggers and routines is stored in only one location and is administered centrally.