When a functional dependency exits, the attributes or set of attributes on the left side of the arrow are known as ______.

• A) Dependant
• B) Anomalies
• C) Determinant
• D) Schema

After moving the determined columns from the original table to the new table while converting to 2NF, the determinate becomes the _____________of the new table

• A) Composite key
• B) Foreign key
• C) Primary key
• D) Secondary key

_____________ are used by database administrator in situations where we have large number of records and wastage of small amount of space in each record can lead to loss of huge amount of data storage space.

• A) Codes
• B) Variables
• C) Symbols
• D) Special characters

A relation is said to be in BCNF when

• A) it has overlapping composite keys
• B) it has no overlapping composite keys which have related attributes
• C) it has no multivalued dependencies
• D) it has no composite keys

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

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

A functional dependency is a type of relationship between ___________.

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

Normalization is a process of restructuring a relation to

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

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

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

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

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

Atomicity is a feature of ______.

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

Normalization of database is used to __________.

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

Which of the following normal form deals with multivalued dependency?

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

Which of the following is associated with a specific attribute and can help us to reduce the chances of inserting incorrect values in the attribute space?

• A) Null Value Control
• B) Range Control
• C) Referential Integrity
• D) Default Value

In ____________ the domains of attributes of a relation are atomic, that is they consist of single units that cannot be broken down further.

• A) Augmentation
• B) Third normal form
• C) Second normal form
• D) First normal form

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) Compression
• B) Negation
• C) Expansions
• D) Extension

A relational table is in third normal form (3NF) if it is already in 2NF and every non-key column is non-transitively dependent upon its ______.

• A) Candidate Key
• B) Primary Key
• C) Super Key
• D) Foreign Key

A 3 NF relation is converted to BCNF by

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

The database design prevents some data from being stored due to _______.

• A) Update anomalies
• B) Insertion anomalies
• C) Deletion anomalies
• D) Redundancy

If A→ BC then A → B and A→ C
The above rule follows _____________ inference rule.

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

When a functional dependency exits, the attributes or set of attributes on the left side of the arrow are known as ______.

• A) Dependant
• B) Determinant
• C) Schema
• D) Anomalies