MCQ | SQL – Constraints Clause

by karimhani25
72
12

Sql programming

questions

Title
By constraining a SQL statement, we limit the ____________ according to certain conditions or restrictions By constraining a SQL statement, we limit the ____________ according to certain conditions or restrictions. Row Column Table Database discuss The answer is: D. Database
Which of the following is/are type of SQL Constraint? Which of the following is/are type of SQL Constraint? Column Level Table Level Both A and B None of the above discuss The answer is: C. Both A and B
What is the difference between Column Level and Table Level Constraints? What is the difference between Column Level and Table Level Constraints? Constraints are applied to a single row using Column Level Constraints whereas Multiple rows can be constrained using a Table Level Constraint. Constraints are applied to multiple rows using Column Level Constraints whereas a single row can be constrained using a Table Level Constraint. Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint. Constraints are applied to multiple columns using Column Level Constraints whereas only a single column can be constrained using a Table Level Constraint. discuss The answer is: C. Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint.
Which of the following constraints are TRUE to be put in Password system? Which of the following constraints are TRUE to be put in Password system? One uppercase character must be included in the password. An eight-character minimum password is required. At least one symbol must appear in the password. All of the above discuss The answer is: D. All of the above
Select the correct constraint in SQL? Select the correct constraint in SQL? NOT NULL CHECK DEFAULT All of the above discuss The answer is: D. All of the above
What is TRUE about NOT NULL Constraint? What is TRUE about NOT NULL Constraint? In columns that are subject to the NOT NULL constraint, duplicate values are not allowed. When a table's column is declared as NOT NULL, no record in the table can have an empty value for that column. By applying the NOT NULL constraint, we will always ensure that the column contains a unique value and won't allow nulls. The value will first be checked for certain conditions before inserting it into the column when a NOT NULL constraint applies to a column in the table. discuss The answer is: B. When a table's column is declared as NOT NULL, no record in the table can have an empty value for that column.
NULL means – NULL means – 0 -1 1 Empty discuss The answer is: D. Empty
Which of the following is TRUE about UNIQUE constraint? Which of the following is TRUE about UNIQUE constraint? In columns that are subject to the UNIQUE constraint, duplicate values are not allowed. Unique values will always be present in the column containing the unique constraint. A single table can have more than one unique constraint, since it can be applied to more than one column. All of the above discuss The answer is: D. All of the above
You can also _______ the existing tables by using the UNIQUE constraint You can also _______ the existing tables by using the UNIQUE constraint. Change Delete Modify Drop discuss The answer is: C. Modify
___________ and __________constraints form the core of the PRIMARY KEY constraint ___________ and __________constraints form the core of the PRIMARY KEY constraint. NOT NULL , CHECK NOT NULL , DEFAULT NOT NULL , FOREIGN KEY NOT NULL , UNIQUE discuss The answer is: D. NOT NULL , UNIQUE
___________ integrity is achieved by using a foreign key ___________ integrity is achieved by using a foreign key. Referential Integrity Domain Integrity User-defined Integrity Entity Integrity discuss The answer is: A. Referential Integrity
What is TRUE about DEFAULT constraint? What is TRUE about DEFAULT constraint? The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table. In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column. An index can be created on the table using the DEFAULT constraint. None of the above discuss The answer is: B. In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.

total MCQs: 12

MCQs

12

Views

72

Best Answers

299

Points

5