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. A benefit of using a stored procedure is that it can be distributed to client computers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Nonclustered indexes are faster than clustered indexes for retrieval.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A null value is assigned when no other value applies.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. With an asynchronous system, the requesting system waits for a response in real time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Business Intelligence (BI) systems do not obtain their data by which of the following means?

    • Options
    • A. Read and process data from an operational database
    • B. Process transactions
    • C. Process extracts from operational databases
    • D. Process data purchased from data vendors
      • Discuss
    • 9. An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The Windows operating system and Windows applications are event driven.

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