Loading...

SQL Server

Which of the following is not a class of constraint in SQL Server
  1. NOT NULL
  2. CHECK
  3. NULL
  4. UNIQUE
Point out the correct statement
  1. CHECK constraints enforce domain integrity
  2. UNIQUE constraints enforce the uniqueness of the values in a set of columns
  3. In a UNIQUE constraint, no two rows in the table can have the same value for the columns
  4. All of the mentioned
Which of the following constraint does not enforce uniqueness
  1. UNIQUE
  2. Primary key
  3. Foreign key
  4. None of the mentioned
Constraints can be applied on
  1. Column
  2. Table
  3. Field
  4. All of the mentioned
Point out the wrong statement
  1. Table constraints must be used when more than one column must be included in a constraint
  2. A column constraint is specified as part of a column definition and applies only to that column
  3. A table constraint is declared independently from a column definition and can apply to more than one column in a table
  4. Primary keys allow for NULL as one of the unique values
Purpose of foreign key constraint in SQL Server is
  1. FOREIGN KEY constraints identify and enforce the relationships between tables
  2. A foreign key in one table points to a candidate key in another table
  3. You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value
  4. None of the mentioned
Which of the following foreign key constraint specifies that the deletion fails with an error
  1. NO ACTION
  2. CASCADE
  3. SET NULL
  4. All of the mentioned
How many types of constraints are present in SQL Server
  1. 4
  2. 5
  3. 6
  4. 7
Which of the constraint can be enforced one per table
  1. Primary key constraint
  2. Not Null constraint
  3. Foreign Key constraint
  4. Check constraint
Which of the reasons will force you to use XML data model in SQL Server
  1. Your data is sparse or you do not know the structure of the data
  2. Your data represents containment hierarchy
  3. Order is inherent in your data
  4. All of the Mentioned