CS403P Quiz 8

Q1. 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?

1. σcgpa>3.0 (STUDENT)
2. Ωcgpa>3.0 (STUDENT)
3. €cgpa>3.0 (STUDENT)
4. σcgpa>3.0 (STUDENT)

Correct answer: σcgpa>3.0 (STUDENT)

Q2. 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?

1. σ FactId, FactDept (Faculty)
2. ϕ FactId, FactDept (Faculty)
3. Ω FactId, FactDept (Faculty)
4. ∏ FactId, FactDept (Faculty)

Correct answer: ∏ FactId, FactDept (Faculty)

Q3. In projection operation, any duplicate values are_________.

1. Grouped
2. Copied
3. Eliminated
4. Selected

Correct answer: Eliminated

Q4. 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 ________________.

1. Appear in both X and Y
2. Appear in X but do not appear in Y
3. Do not appear in both X and Y
4. Appear in Y but not in X

Correct answer: Appear in X but do not appear in Y

Q5. Which of the following are unary operators?

1. SELECT and PROJECT
2. SELECT and CARTESIAN
3. PROJECT and CARTESIAN
4. UNION and PROJECT

Correct answer: SELECT and PROJECT

Q6. 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?

1. σ designation = ‘Admin officer’ (EMPLOYEE)
2. α designation = ‘Admin officer’ (EMPLOYEE)
3. ռ designation = ‘Admin officer’ (EMPLOYEE)
4. ϕ designation = ‘Admin officer’(EMPLOYEE)

Correct answer: σ designation = ‘Admin officer’ (EMPLOYEE)

Q7. In intersection operation, which of the following is selected?

1. Tuples common in both relations
2. Tuples of second relation
3. Tuples of first relation
4. Tuples of single relation only

Correct answer: Tuples common in both relations

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

1. AC → BC
2. AB → C
3. A → C
4. AD → B

Correct answer: AC → BC

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

1. Reflexive dependency
2. Transitive dependency
3. Partial dependency
4. Full functional dependency

Correct answer: Partial dependency

Q10. 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?

1. Reflexive dependency
2. Transitive dependency
3. Squencial dependency
4. Partial dependency

Correct answer: Squencial dependency

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

1. Classification
2. Integration
3. Modeling
4. Normalization

Correct answer: Normalization

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

1. Super key
2. Relational key
3. Random key
4. Secondary key

Correct answer: Super key

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

1. Dependent
2. Projected
3. Reflected
4. Terminated

Correct answer: Dependent

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

1. It has multivalued attributes
2. It is not in first normal form
3. It is in first normal form
4. It has inconsistent data

Correct answer: It is in first normal form