header1.html

Monday, 8 April 2013

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