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

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

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

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

A relation is in third normal form if ________.

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

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

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

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

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

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

A transitive dependency occurs when __________.

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

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

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

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

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

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

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

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

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

INSERT INTO statement is used to enter values into__________.

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

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 employee (col1, col2, col3), (val1, val2, val3)
• C) INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
• D) INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)

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

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

___________ SQL statement is used to enter values into columns.

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

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

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

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

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

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

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

In projection operation, any duplicate values are_________.

• A) Grouped
• B) Copied
• C) Eliminated
• D) Selected

What is the basic component/structure of Relational Data Model?

• A) Relation
• B) Schema
• C) Tuple
• D) Model