CLASS TEST 1 DBMS

Select the primary key characteristics/s?

• Unique Constraint

• None

• Unique and Not Null Constraint

• Not Null Constraint

WHICH OF THE FOLLOWING IS TRUE?

• PRIMARY KEY IS THE SUPERSET OF CANDIDATE KEY

• CANDIDATE KEY IS THE SUPERSET OF SUPER KEY

• SUPERKEY IS THE SUBSET OF CANDIDATE KEY

• PRIMARY KEY IS THE SUBSET OF CANDIDATE KEY

More than one answer are correct

• a is a super key

• a is a composite key

• a is a partial key

• a is the candidate key

A network model schema:

• permits many to many relationship

• restricts one to many relationship

• stores data in a table

• restricts many to one relationship

select the correct option?

• 1000

• 3000

• 4000

• 5000

which of the following is not false?

• selection is a complete set

• natural join can be implemented with the help of cartesian product and projection operation

• minimum cardinality in case of selection operator is 0

• projection is binary operator

if in redundant file common fields are not matching then it results in _______

• data integrity problem

• data inconsistancy

• data isolation

• data redundancy

enter numeric value only

select the correct answer?

• a option only

• b option only

Select one or more:

• 17

• 19

• all the options

• 20