CS403P Lab Attendance Quiz 7  Fall 2024

1. Question: 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 ________________.

   • Answer: Appear in X but do not appear in Y.

2. Question: 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?

   • Answer: σcgpa>3.0 (STUDENT)

3. Question: In intersection operation, which of the following is selected?

   • Answer: Tuples common in both relations

4. Question: 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?

   • Answer: σ designation = ‘Admin officer’ (EMPLOYEE)

5. Question: Which of the following operator is used to select the certain columns from a table?

   • Answer: Project operator