Consider the following two sets: X = [a, b] Y = {1,3,5} Then the Cartesian product of A and B (i.e. XxY) will be equal to:

• A) {(a,1), (a,5), (a,3), (b,5), (b,1), (b,5)}
• B) {(a, a), (a,3), (a,1), (b,5), (b,5), (b,3)}
• C) {(a,1), (a,3), (a,5), (b,1), (b,3), (b,5)}
• D) {(a,1), (b,1), (a,5), (b,3), (a,5), (b,5)}

In relational database, each cell of a table cannot have __________ .

• A) Multiple values
• B) Unique values
• C) String values
• D) Numeric values

In a university, each student can avail a single scholarship. The relationship between student and scholarship is:

• A) Recursive relationship
• B) One to one
• C) Many to many
• D) One to many

In intersection operation, which of the following is selected?

• A) Tuples common in both relations
• B) Tuples of second relation
• C) Tuples of first relation
• D) Tuples of single relation only

Table is a ______________ representation of a relation.

• A) Three Dimensional
• B) Two Dimensional
• C) Six Dimensional
• D) Four Dimensional

Column of the table in the relational database are identified by ___________.

• A) Serial number
• B) Value
• C) Name
• D) Key

An attribute which is a combination of two or more attributes is known as:

• A) Special attribute
• B) Recursive attribute
• C) Homonym attribute
• D) Composite attribute

A relation named FACULTY contains the attributes FactId, FactName, FactDept and FactRank. Which of the query will be used to PROJECT the FactId and FactDept?

• A) ϕ FactId, FactDept (Faculty)
• B) σ FactId, FactDept (Faculty)
• C) ∏ FactId, FactDept (Faculty)
• D) Ω FactId, FactDept (Faculty)

In functional dependency, if one attribute is determinant of all other attributes of the relation then the relation has at least __________.

• A) Random key
• B) Super key
• C) Relational key
• D) Secondary key

A table is in the 2nd Normal Form if there is no___________.

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

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

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

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

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

A relation is in second normal form if and only if ______________ and all the non key attributes are fully functionally dependent on the key.

• A) It has inconsistent data
• B) It is in first normal form
• C) It has multivalued attributes
• D) It is not in first normal form

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