logo

CuriousTab

CuriousTab

Discussion

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

  • 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

  • Correct Answer
  • False 

    • More questions

    • 1. Which of the following is an SQL trigger supported by Oracle?

    • Options
    • A. BEFORE
    • B. INSTEAD OF
    • C. AFTER
    • D. All of the above.
      • Discuss
    • 2. The primary mechanism for providing context for data is metadata.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Data scrubbing is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
      • Discuss
    • 4. The entity integrity rule states that:

    • Options
    • A. no primary key attribute may be null.
    • B. no primary key can be composite.
    • C. no primary key may be unique.
    • D. no primary key may be equal to a value in a foreign key.
      • Discuss
    • 5. Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

    • Options
    • A. LIKE only.
    • B. IN only.
    • C. NOT IN only.
    • D. Both IN and NOT IN.
      • Discuss
    • 7. Static extract is used for ongoing warehouse maintenance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Which of the following is true concerning an ODBMS?

    • Options
    • A. They have the ability to store complex data types on the Web.
    • B. They are overtaking RDBMS for all applications.
    • C. They are most useful for traditional, two-dimensional database table applications.
    • D. All of the above.
      • Discuss
    • 9. Which of the following statements is true concerning routines and triggers?

    • Options
    • A. Both consist of procedural code.
    • B. Both have to be called to operate.
    • C. Both run automatically.
    • D. Both are stored in the database.
      • Discuss
    • 10. With SQL Server, parameters and variables in T-SQL start with the "%" sign.

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