Constraint 5 Jul,2023 boomtecho2@gmail.comLeave a comment Please enter your email: 1. Which of the following is not a class of constraint in SQL Server? Check Not Null Unique NULL 2. How Many type of Constraint? 6 5 7 4 3. Point out the correct statement. CHECK constraints enforce domain integrity UNIQUE constraints enforce the uniqueness of the values in a set of columns In a UNIQUE constraint, no two rows in the table can have the same value for the columns All of the Mention 4. Why we use the Constraint in DBMS? Accuracy Consistency Integrity All of the Above 5. Which of the following constraint does not enforce uniqueness? Unique Primary kEY Foreign key None of the above 6. Constraints can be applied on ___________ Column field Table All of the Above 7. Point out the wrong statement. Table constraints must be used when more than one column must be included in a constraint A column constraint is specified as part of a column definition and applies only to that column A table constraint is declared independently from a column definition and can apply to more than one column in a table Primary keys allow for NULL as one of the unique values 8. Purpose of foreign key constraint in SQL Server is __________ FOREIGN KEY constraints identify and enforce the relationships between tables A foreign key in one table points to a candidate key in another table You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value None of the mentioned 9. Which of the following is not a foreign key constraint? NO ACTION CASCADE SET NULL all OF THE Above 10. Which of the following foreign key constraint specifies that the deletion fails with an error? CASCADE No Action SET NULL All of the above 11. Which of the constraint can be enforced one per table? Primary Key Constraint Not Null Constraint Foreign Key Constraint Check Constraint 12. When we specified a Constraint on a Table? create table statement Alter table Both A and B None of the Above 13. Not Null Constraint? Ensure the any column can not have Null Value Ensure the enter a unique value in column Prevents actions that would destroy links between tables None of the Above 14. What is foreign key constraint in SQL? Prevents actions that would destroy links between tables Ensures that the values in a column satisfies a specific condition Both a AND b None of the above 15. By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions. ROW COLUMN TABLE DATABASE 16. Which of the following is/are type of SQL Constraint? Column Level Table Level Both A and B None of the Above 17. SQL Constraints can be categorized in _ 2 3 4 5 18. 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. 19. 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 20. 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. 21. To include integrity constraint in a existing relation use : Create Table Modify table Alter table None of the ABOVE 22. Domain constraints, functional dependency and referential integrity are special forms of _________. Assertion Primary key Referential constraint Foreign key 23. Data integrity constraints are used to_ Control who is allowed access to the data Ensure that duplicate records are not entered into the table Improve the quality of data entered for a specific property Prevent users from changing the values stored in the table 24. Which one of the following uniquely identifies the elements in the relation? Primary Key foreign key secondary key composite key Loading …
