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

Which of the following is the correct syntax for creating a database table?

• A) CREATE MYSQL TABLE name;
• B) TABLE name CREATE;
• C) CREATE TABLE name;
• D) CREATE TABLE;

Which of the following is a correct syntax for creating a Database named employee?

• A) CREATE MYSQL Database employee
• B) CREATE DATABASE employee;
• C) CREATE TABLE employee;
• D) CREATE SQL DATABASE employee;

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

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

Which of the following is NOT related to CREATE TABLE command?

• A) Records
• B) Attributes
• C) Data types
• D) Constraints

Which of the following is the correct syntax for inserting some values into the employee table?

• A) INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)
• B) INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
• C) INSERT into employee (col1, col2, col3), (val1, val2, val3)
• D) INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)

­­­­­­­­­­­­­­­­­___________ in SQL table is used to uniquely identify individual rows of a given table.

• A) Foreign key column
• B) NOT NULL constraints
• C) Secondary key column
• D) Primary key column

If there are two relations X and Y then the difference of these two relations (i.e. X-Y) will be set of tuples that ________________.

• A) Appear in X but do not appear in Y
• B) Appear in Y but not in X
• C) Do not appear in both X and Y
• D) Appear in both X and Y