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

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

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

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

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

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

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

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

Creating the relationships between new tables and their predecessors through the use of foreign keys is general requirements of__________.

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

The process of normalization

• A) is finding the key of a relation
• B) is manual and requires semantic information
• C) requires one to understand dependency between attributes
• D) is automatic using a computer program

Which of the following is used to keep the input values for a specific attribute in specific limits in comparison to any other attribute of the same or any other relation?

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

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

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

Functional dependencies under reflexivity inference rule are called __________ dependencies.

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

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

• A) 10 Gigabytes
• B) 8 Gigabytes
• C) 4 Gigabytes
• D) 12 Gigabytes

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

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

For third normal form we concentrate on relations with one _________key, and we eliminate transitive dependencies

• A) Candidate
• B) Composite
• C) Primary key
• D) Super key

____________are the structure defined for placing data in the attributes while designing physical design of database.

• A) Objects
• B) Variables
• C) Data types
• D) Attributes

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

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

Given the following relation it is not 3 NF because
Student (roll no, name, course no, course max. marks, year of study,
address), where roll no is PK

• A) non-key attributes course no and course max. marks are functionally dependent
• B) it has more than 3 non-key attributes
• C) it is not in 2 NF
• D) it does not have composite key

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

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

Which of the following is an empty value but distinct from zero and spaces?

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

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

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

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

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

Data type “BLOB” in database management system stands for ________________.

• A) Bipolar large object
• B) Binary long objective
• C) Binary large objective
• D) Binary large Object