If the relation is not in 2nd Normal Form, then we need to remove___________.

• A) Transitive dependency
• B) Full functional dependency
• C) Partial dependency
• D) Reflexive dependency

Suppose A → B, then which of the following is valid Functional dependency for augmentation?

• A) AD → B
• B) AB → C
• C) AC → BC
• D) A → C

If a relation CLASS (crId, stId, stName, fId, room, grade) has following Functional Dependencies: crId, stId → stName, fId, room, grade which of the following functional dependency is in above functional dependency?

• A) Squencial dependency
• B) Reflexive dependency
• C) Transitive dependency
• D) Partial dependency

The only time we are concerned about 2nd Normal Form is when ___________.

• A) Primary key contains redundant values
• B) Primary key contains non-unique values
• C) Primary key consists of single attribute
• D) Primary key is composite

______________ is a step by step process to reduce data redundancy and improve data integrity to build a more efficient and accurate database design.

• A) Classification
• B) Integration
• C) Normalization
• D) Modeling

INSERT INTO statement is used to enter values into__________.

• A) Key value columns only
• B) Only particular column
• C) All columns
• D) Not null columns only

From the following options, Choose the correct statement for the third normal form.

• A) There is redundant data in the relation
• B) Non key attribute is dependent on another non key attribute
• C) There is partial dependency in the relation
• D) No non key attribute is dependent on another non key attribute

Which of the following action is performed on a relation to remove the transitive dependency?

• A) Aggregation
• B) Decomposition
• C) Augmentation
• D) Composition

If a relation is not in third normal form, then anomalies are due to ________.

• A) Full functional dependency
• B) Reflexive dependency
• C) Partial dependency
• D) Transitive dependency

The anomalies caused by transitive dependency in a relation are removed by __________.

• A) Changing primary key
• B) Reducing number of columns
• C) Breaking down the relation
• D) Reducing number of rows

A transitive dependency occurs when __________.

• A) Non-key attribute is dependent on another non-key attribute
• B) Non-key attribute is not dependent on another non-key attribute
• C) Part of the key is dependent on key attribute
• D) Primary key attribute is dependent on non-key attribute

A relation is in third normal form if ________.

• A) It is already in second normal form
• B) It has multivalued attributes
• C) It has a partial dependency
• D) It has a transitive dependency

A table is in third normal form if it is in second normal form and there is no __________.

• A) Partial dependency
• B) Consistency
• C) Full functional dependency
• D) Transitive dependency

Consider the following relation: STD(stId, stName, stAdr, prName, prCrdts) stId → stName, stAdr, prName, prCrdts prName → prCrdts Which of the following dependency exist in above relation?

• A) Reflexive dependency
• B) Transitive dependency
• C) Terminal dependency
• D) Composite dependency

Consider the following functional dependency: A → B In above functional dependency, attribute B is_______ on A.

• A) Dependent
• B) Projected
• C) Terminated
• D) Reflected

___________ SQL statement is used to enter values into columns.

• A) INSERT TO
• B) PUT INTO
• C) INSERT INTO
• D) ENTER INTO

Which of the following is NOT a type of integer data type in SQL?

• A) Int
• B) Smallint
• C) Smallerint
• D) Smallint

Which of the following command is used to insert data into tables?

• A) DDL
• B) DML
• C) DQL
• D) DDL

2nd Normal Form is based on which of the following dependency?

• A) Transitive dependency
• B) Partial dependency
• C) Reflexive dependency
• D) Full functional dependency

Which of the following commands is used to create a database table and its structure?

• A) DCL
• B) DQL
• C) DML
• D) DDL