DBMS Quiz-4

DBMS Quiz-4

1.What is Constraint? Constraint is a rule or set of rules that apply to a column or combination of columns It does not achieve data integrity It allows data corruption None of the above 2.Check constraint is also known as _________ Referential integrity Domain integrity Entity integrity None of the above 3.To maintain relationship between two related tables Domain integrity Referential integrity Entity integrity None of the above 4.Foreign key constraint is also known as Domain integrity Entity integrity Referential integrity None of above 5.___________ allows null values to be stored primary key unique key composite key None of above 6.By default a table allows null records True False 7.Which of the following statement is true about tables A table can have only one primary key constraint but can have several UNIQUE constraints A table can have multiple primary keys Null value can be stored in the primary key None 8.What is Control data concurrency? A properly set-up database minimizes data redundancy. It will avoid data repetition in the databases Databases allow you to set up rules that ensure that data remains consistent when add or modify data Databases allows multiple users to access the same database simultaneously None 9.For a DBMS to be relational Codd’s rules have to be followed False True 10.A set of related tables forms a database and all data is represented as tables, the data can be viewed in no other way”, is the _________ codd’s rule Codd’s 1 rule Codd’s 2 rule Codd’s 3 rule None of the above