DBMS Quiz 3

Choose the CORRECT symbol of SELECT in the Relational Algebra

• x

• $\pi$

• $\cap$

• $\sigma$

Identify the CORRECT output for table (Student Difference Lecturer) or (Student - Lecturer) in table above

• 
• 
• 
• 

Write the CORRECT relational algebra expression base on the figure above

• $\pi$ managerID, managerName ( $\sigma$ workExprience = 5) (MANAGER)

• $\sigma$ managerID, managerName ( $\pi$ workExprience = 5) (MANAGER)

• $\sigma$ managerID, managerName ( $\pi$ workExprience > 5) (MANAGER)

• $\pi$ managerID, managerName ( $\sigma$ workExprience > 5) (MANAGER)

Write the relational algebra to list student's number and student'a name whose age is 20 years old or state in Terengganu.

• $\pi$ StudentID, Name ( $\sigma$ Age=20 AND State = "Terengganu" (STUDENT)

• $\pi$ StudentID, Name ( $\sigma$ Age=20 OR State = "Terengganu" (STUDENT)

• $\sigma$ StudentID, Name ( $\pi$ Age=20 AND State = "Terengganu" (STUDENT)

• $\sigma$ StudentID, Name ( $\pi$ Age=20 OR State = "Terengganu" (STUDENT)

Base on the table given, identify output that will be produced when, σ _{Salary > 3000 ˅ City = ‘Batu Pahat’} (WORKER).

• 
• 
• 
• 

Is equivalent to

• 
• 
• 
• 

Which of the following are relational algebra operators?

• 
• 
• 
• 
• 

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

• Relational

• Structural

• Procedural

• Fundamental

A set of possible data values is called

• Attribute

• Degree

• Tuple

• Domain

When we want to display records with attributes from many relations then we use:

• SELECT operation

• PROJECT operation

• JOIN operation

• PERFORM operation