In a table, column represents __________.

• A) Data
• B) Instances
• C) Records
• D) Attributes

In many to many relationship, a third table is created for the relationship. It is known as _______.

• A) Associative entity type
• B) Regular entity type
• C) Strong entity type
• D) Naming entity type

If a teacher teaches multiple courses in a university then the relationship between teacher and course is:

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

In relational data model, composite attributes need to be represented as:

• A) Entity type
• B) Recursive relationship
• C) Separate relation
• D) Objects

Rows of the table in the relational database are identified by __________.

• A) Serial number
• B) Row name
• C) Header
• D) Key values

Suppose a relation named EMPLOYEE contains attributes Emp_name, Emp_designation, Emp_address and Emp_salary. Which of the following query will be used to SELECT all those employees whose designation is Admin officer?

• A) ռ designation = ‘Admin officer’ (EMPLOYEE)
• B) α designation = ‘Admin officer’ (EMPLOYEE)
• C) σ designation = ‘Admin officer’ (EMPLOYEE)
• D) ϕ designation = ‘Admin officer’(EMPLOYEE)

Which of the following are unary operators?

• A) SELECT and CARTESIAN
• B) PROJECT and CARTESIAN
• C) UNION and PROJECT
• D) SELECT and PROJECT

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