logo

CuriousTab

CuriousTab

Discussion


Home Database Database Redesign See What Others Are Saying!
  • Question
  • What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?


  • Options
  • A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
  • B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  • C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
  • D. None of the above is correct.

  • Correct Answer
  • ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); 


  • More questions

    • 1. OnLine Analytical Processing (OLAP) is a BI reporting system.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. A transaction in which either all of the database actions occur or none of them do is called:

    • Options
    • A. atomic.
    • B. consistent.
    • C. isolated.
    • D. durable.
    • Discuss
    • 3. How many JDBC driver types does Sun define?

    • Options
    • A. One
    • B. Two
    • C. Three
    • D. Four
    • Discuss
    • 4. The SQL statement used to create a view is CREATE VIEW.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. For every relationship, there are six possible sets of minimum cardinalities.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. Using ODL, you can define which of the following?

    • Options
    • A. Attribute
    • B. Structure
    • C. Operation
    • D. All of the above.
    • Discuss
    • 7. The most important reason for data architecture is reliability.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. A file data source is one that is local to a single computer.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. The relational model consists of:

    • Options
    • A. data in the form of tables.
    • B. data redundancy.
    • C. operations using non-SQL languages.
    • D. unorganized data.
    • Discuss
    • 10. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

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


    Comments

    There are no comments.

Enter a new Comment