logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign See What Others Are Saying!
  • Question

  • A regular subquery can be processed:


  • Options
  • A. from the top down.
  • B. from the bottom up.
  • C. by nesting.
  • D. None of the above is correct.

  • Correct Answer
  • from the bottom up. 

    • More questions

    • 1. Apache Web server does not support servlets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

    • Options
    • A. primary key.
    • B. foreign key.
    • C. composite key.
    • D. surrogate key.
      • Discuss
    • 3. If attribute A determines both attributes B and C, then it is also true that:

    • Options
    • A. A ? B.
    • B. B ? A.
    • C. C ? A.
    • D. (B,C) ? A.
      • Discuss
    • 4. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

    • Options
    • A. all columns of the table are to be returned.
    • B. all records meeting the full criteria are to be returned.
    • C. all records with even partial criteria met are to be returned.
    • D. None of the above is correct.
      • Discuss
    • 6. An attribute's value is either a literal or an object identifier.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SUM, AVG, MIN, and MAX can only be used with numeric columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. In a 1:N relationship, the foreign key is placed in:

    • Options
    • A. either table without specifying parent and child tables.
    • B. the parent table.
    • C. the child table.
    • D. either the parent table or the child table.
      • Discuss
    • 10. SQL is a programming language.

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