A database state where deletion of the information about the student record deletes the course information as well is called _______________.

• A) Insertion anomaly
• B) Updation anomaly
• C) Redundancy
• D) Deletion anomaly

________________ is state of database where a “course” cannot be inserted in the table, because this course has not been registered to any “student”.

• A) Deletion anomaly
• B) Redundancy
• C) Updation anomaly
• D) Insertion anomaly

A 3 NF relation is converted to BCNF by

• A) removing multivalued dependencies
• B) dependent non-key attributes are put in a separate table
• C) dependent attributes of overlapping composite keys are put in a separate relation
• D) removing composite keys

A function that has no partial functional dependencies is in _______ .

• A) 2NF
• B) BCNF
• C) 3NF
• D) 1NF

With the help of _____________ technique data values with the smaller sized codes can further reduce the space needed by the data for storage in the database.

• A) Extension
• B) Expansions
• C) Negation
• D) Compression

Normalization is a process of restructuring a relation to

• A) allow addition of data
• B) make it of uniform size
• C) minimize duplication of data in a database
• D) maximize duplication of data to ensure reliability

The following is an example of __________ inference rule.
If stId → prName and prName → credits then stId → credits

• A) Projectivity
• B) Augmentation
• C) Additive
• D) Transitivity

Which of the following normal form deals with multivalued dependency?

• A) 4NF
• B) 2NF
• C) 3NF
• D) 1NF

While converting to 2NF all the columns are deleted from the original table except for the determinant which will serve as a ____________key.

• A) Super key
• B) Primary key
• C) Foreign key
• D) Composite Key

In which normal form, we convert composite attributes into individual attributes?

• A) 4NF
• B) 1NF
• C) 3NF
• D) 2NF

A functional dependency is a type of relationship between ___________.

• A) Attributes
• B) Tables
• C) Objects
• D) Entities

The maximum PL/SQL size of data type “VARCHAR2” in DBMS is _____________ bytes.

• A) 52767
• B) 42767
• C) 32767
• D) 28767

Normalization of database is used to __________.

• A) Improve design
• B) Improve security
• C) Minimize errors
• D) Eliminate redundancy

If A→ B and CB → D, then AC → D. 1. The above rule follows _____________ inference rule.

• A) Additivity
• B) Augmentation
• C) Decomposition
• D) Pseudo transitivity

Which of the following normal form deals with possible loss less decompositions?

• A) 4NF
• B) 2NF
• C) 5NF
• D) 3NF

An attribute y may be functionally dependent on
(i) a composite attribute x,y
(ii) a single attribute x
(iii) no attribute

• A) iii
• B) i and iii
• C) i and ii
• D) ii and iii

If A -> B and A -> C, then A -> BC
The Inference Rule applies is;

• A) Reflexivity
• B) Decomposition
• C) Augmentation
• D) Union

Functional dependencies under reflexivity inference rule are called __________ dependencies.

• A) Transitivity
• B) Projectivity
• C) Trivial
• D) Augmentation

-------------------------- provides rapid, non-sequential, direct access to records.

• A) Collision handling
• B) Non Hashing
• C) Hashing
• D) sequential

WORM: Stands for--------------------------------------.

• A) write-once, read-many
• B) Read only memory
• C) write only memory
• D) Write on, Read memory