logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL for Database Construction Comments
  • Question

  • The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • SQL for Database Construction problems

    Search Results

    • 1. A stored procedure is a program that performs some common action on database data and is stored in the database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. SQL Server does not support the BEFORE trigger.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A trigger is a stored program that is attached to a database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. There are three SQL data modification operations: insert, modify and delete.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Three types of triggers are: BEFORE, AFTER and EXCEPTION.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A updatable view has its own data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The SQL statement used to create a view is CREATE VIEW.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

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