logo

CuriousTab

CuriousTab

Advanced SQL problems


  • 1. Which of the following is true concerning triggers?

  • Options
  • A. You do not create them with SQL.
  • B. They execute against only some applications that access a database.
  • C. They have an event, condition, and action.
  • D. They cannot cascade (cause another trigger to fire).
  • Discuss
  • 2. What type of join is needed when you wish to include rows that do not have matching values?

  • Options
  • A. Equi-join
  • B. Natural join
  • C. Outer join
  • D. All of the above.
  • Discuss
  • 3. What type of join is needed when you wish to return rows that do have matching values?

  • Options
  • A. Equi-join
  • B. Natural join
  • C. Outer join
  • D. All of the above.
  • Discuss
  • 4. Embedded SQL is which of the following?

  • Options
  • A. Hard-coded SQL statements in a program language such as Java.
  • B. The process of making an application capable of generating specific SQL code on the fly.
  • C. Hard-coded SQL statements in a procedure.
  • D. Hard-coded SQL statements in a trigger.
  • Discuss
  • 5. Which of the following statements is true concerning subqueries?

  • Options
  • A. Involves the use of an inner and outer query.
  • B. Cannot return the same result as a query that is not a subquery.
  • C. Does not start with the word SELECT.
  • D. All of the above.
  • Discuss
  • 6. 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

  • Options
  • A. Equi-join
  • B. Natural join
  • C. Outer join
  • D. Cartesian join
  • Discuss
  • 7. A UNION query is which of the following?

  • Options
  • A. Combines the output from no more than two queries and must include the same number of columns.
  • B. Combines the output from no more than two queries and does not include the same number of columns.
  • C. Combines the output from multiple queries and must include the same number of columns.
  • D. Combines the output from multiple queries and does not include the same number of columns.
  • Discuss
  • 8. Which of the following is one of the basic approaches for joining tables?

  • Options
  • A. Subqueries
  • B. Union Join
  • C. Natural join
  • D. All of the above
  • Discuss
  • 9. Which of the following is true concerning a procedure?

  • Options
  • A. You do not create them with SQL.
  • B. They do not need to have a unique name.
  • C. They include procedural and SQL statements.
  • D. They are the same thing as a function.
  • Discuss
  • 10. Which of the following is true concerning systems information in an RDBMS?

  • Options
  • A. RDBMS store database definition information in system-created tables.
  • B. This information can be accessed using SQL.
  • C. This information often cannot be updated by a user.
  • D. All of the above.
  • Discuss

First 2 3