Quiz 3

What is the primary purpose of normalization in databases?

• Improve execution speed

• Increase redundancy

• Eliminate update anomalies

• Avoid using foreign keys

Which normal form removes partial dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

In functional dependency A → B, which of the following is true?

• A determines nothing

• A determines B

• B determines A

• A is always a foreign key

Which operation in relational algebra selects specific rows based on a condition?

• SELECT (σ)

• PROJECT (π)

• JOIN (⋈)

• UNION (∪)

Which of the following is a valid PROJECT operation?

• σDNO=4(EMPLOYEE)

• πLNAME, SALARY(EMPLOYEE)

• EMPLOYEE × DEPARTMENT

• 5. EMPLOYEE − WORKS_ON

Which type of JOIN includes only matching tuples based on a condition?

• Left outer join

• Equijoin

• Natural join

• Cartesian product

What SQL command is used to give privileges to users?

• AUTHORIZE

• PERMIT

• GRANT

• ALLOCATE

Which operation combines all tuples from two relations without duplication?

• INTERSECT

• UNION

• DIFFERENCE

• DIVISION

Which clause filters the result of grouped data in SQL?

• WHERE

• HAVING

• ORDER BY

• FROM

Which of the following is NOT one of the 3 main objectives of database security?

• Integrity

• Availability

• Consistency

• Secrecy