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 projection operation, any duplicate values are_________.

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

Which of the following option is true for union commutative?

• A) B∩A=BUA
• B) AUB=A∩B
• C) AUB=BUA
• D) A∩B=AUB

Which of the following are unary operators?

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

In intersection operation, which of the following is selected?

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

If relation M has C tuples and relation N has D tuples, then their Cartesian product will have _________ tuples.

• A) C^D
• B) C*D
• C) CUD
• D) C∩D

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 both X and Y
• B) Do not appear in both X and Y
• C) Appear in X but do not appear in Y
• D) Appear in Y but not in X

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 operator is used to select the certain columns from a table?

• A) Conjugate operator
• B) Project operator
• C) Select operator
• D) Cartesian operator

Suppose a relation named STUDENT contains attributes St_name, St_cgpa, cur_semester and st_roll. Which of the following query will be used to SELECT all those student records having cgpa greater than 3.0?

• A) Ωcgpa>3.0 (STUDENT)
• B) σcgpa>3.0 (STUDENT)
• C) €cgpa>3.0 (STUDENT)
• D) σcgpa>3.0 (STUDENT)

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

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

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) Partial dependency
• C) Transitive dependency
• D) Reflexive dependency

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

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

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

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

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) Relational key
• C) Super key
• D) Secondary key

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

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

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

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

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

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

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 is not in first normal form
• B) It has inconsistent data
• C) It is in first normal form
• D) It has multivalued attributes

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

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