logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
  • Question

  • 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

  • Correct Answer
  • Equi-join 

    • More questions

    • 1. When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

    • Options
    • A. are case insensitive.
    • B. are case sensitive.
    • C. must always be in lower case.
    • D. must always be in upper case.
      • Discuss
    • 2. ODBC requires the specific driver.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which of the following is true concerning Web services standards?

    • Options
    • A. Led by only one group.
    • B. Helped by cooperation between companies.
    • C. Not necessary at this time.
    • D. Important so that the web can flourish.
      • Discuss
    • 4. Where is metadata stored in MySQL?

    • Options
    • A. In the MySQL database metadata
    • B. In the MySQL database metasql
    • C. In the MySQL database mysql
    • D. None of the above is correct.
      • Discuss
    • 5. Which of the following locks the item from change but not from read?

    • Options
    • A. Implicit lock
    • B. Explicit lock
    • C. Exclusive lock
    • D. Shared lock
      • Discuss
    • 6. The primary key in a relation does not need to be underlined.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A workgroup typically comprises between 25 and 100 persons.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. In a relation, the rows are sometimes called "fields."

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A view that contains a computed column can be easily updated.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. A secondary key is which of the following?

    • Options
    • A. Nonunique key
    • B. Primary key
    • C. Useful for denormalization decisions
    • D. Determines the tablespace required
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.