logo

CuriousTab

CuriousTab

Discussion


Home Database Advanced SQL Comments

  • Question
  • How many tables may be included with a join?


  • Options
  • A. One
  • B. Two
  • C. Three
  • D. All of the above.

  • Correct Answer
  • All of the above. 


  • Advanced SQL problems


    Search Results


    • 1. 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 ;

    • Options
    • A. Equi-join
    • B. Natural join
    • C. Outer join
    • D. Cartesian join
    • Discuss
    • 2. Which of the following statements is true concerning routines and triggers?

    • Options
    • A. Both consist of procedural code.
    • B. Both have to be called to operate.
    • C. Both run automatically.
    • D. Both are stored in the database.
    • Discuss
    • 3. A CASE SQL statement is which of the following?

    • Options
    • A. A way to establish an IF-THEN-ELSE in SQL.
    • B. A way to establish a loop in SQL.
    • C. A way to establish a data definition in SQL.
    • D. All of the above.
    • Discuss
    • 4. 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
    • 5. 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
    • 6. Which of the following is a correlated subquery?

    • Options
    • 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.
    • Discuss
    • 7. Features of XML include which of the following?

    • Options
    • A. The tags are used to describe the appearance of the content.
    • B. Addresses the structuring and manipulation of the data involved.
    • C. Governs the display of information in a Web browser.
    • D. All of the above.
    • Discuss
    • 8. Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?

    • Options
    • A. Both TCP and IP are needed.
    • B. TCP is needed but IP is not needed.
    • C. TCP is not needed but IP is needed.
    • D. Neither TCP and IP are needed.
    • Discuss
    • 9. An intranet provides which of the following?

    • Options
    • A. Connectivity to all customers
    • B. Connectivity to selected customers
    • C. Connectivity to no customers
    • D. Connectivity to all of the above
    • Discuss
    • 10. A server-side extension is needed to do what?

    • Options
    • A. Allow a request from a client to access the database.
    • B. Allow a request from a client to access a HTML-formatted page.
    • C. Allow a request from a client to access Web pages.
    • D. All of the above.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment