logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to SQL Comments
  • Question

  • The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • Introduction to SQL problems

    Search Results

    • 1. SQL is a programming language.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Indexes may be created or dropped at any time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A dynamic view is one whose contents materialize when referenced.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. In all cases, normalization into BCNF is desirable.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Denormalized tables are in BCNF.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Normalization requires programmers to write more complex SQL.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.

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