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. An ERD that has had the entities clustered will display more entities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A differential backup makes a copy of the entire database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which is not true about surrogate keys?

    • Options
    • A. They are short.
    • B. They are fixed.
    • C. They have meaning to the user.
    • D. They are numeric.
      • Discuss
    • 4. OLAP uses measures, dimensions and associations.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. We use the SQL construct COUNT(*) to count the number of rows in a table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. To obtain the structure of an Oracle table, the command to use is:

    • Options
    • A. STRUCTURE [TableName].
    • B. DESCRIBE [TableName].
    • C. DESCRIBE STRUCTURE [TableName].
    • D. DESC TABLE [TableName].
      • Discuss
    • 7. The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Stand-alone databases exhibit many of the same advantages common to file processing systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.