logo

CuriousTab

CuriousTab

Discussion

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

  • The result of every SQL query is a table.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. When mapping a many-to-many unary relationship into a relation which of the following is true?

    • Options
    • A. One relation is created.
    • B. Two relations are created.
    • C. Three relations are created.
    • D. Four relations are created.
      • Discuss
    • 2. We have normalized a table into BCNF if all candidate keys are determinants.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Microsoft Access is an enterprise-class database product.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Which of the following is not a component of a data warehouse?

    • Options
    • A. Data extraction/cleaning/preparation programs
    • B. Data warehouse data
    • C. Data metadata
    • D. None of the above are data warehouse components.
      • Discuss
    • 5. A database has a built-in capability to create, process and administer itself.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. OLE DB has two types of data providers: tabular data providers and service providers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A method defines the form or protocol of the operation, but not its implementation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A snowflake schema is which of the following types of tables?

    • Options
    • A. Fact
    • B. Dimension
    • C. Helper
    • D. All of the above
      • Discuss
    • 9. When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

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

    Comments

    Avatar
    Abdelrahman
    What about, UPDATE, DELETE, INSERT, ALTER queries?! They do not return a table
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.