B CompE Bachelor of Computer Engineering Database Management Systems

Question 1

Which normal form eliminates partial dependencies on a composite primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 2

What SQL clause is used to filter results after aggregation?

Accepted Answer

HAVING

Answer

WHERE

Answer

GROUP BY

Answer

ORDER BY

Question 3

Which type of JOIN returns all rows from both tables, with NULLs where there is no match?

Accepted Answer

FULL OUTER JOIN

Answer

INNER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Question 4

What is a foreign key in a relational database?

Accepted Answer

A primary key of another table referenced by the current table

Answer

A key that encrypts table data

Answer

The first column of every table

Answer

An index used for faster lookups

Question 5

Which SQL command removes all rows from a table without deleting the table structure?

Accepted Answer

TRUNCATE

Answer

DELETE

Answer

DROP

Answer

REMOVE

Question 6

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Availability, Consistency, Integrity, Durability

Answer

Atomicity, Concurrency, Integrity, Distribution

Answer

Availability, Concurrency, Isolation, Distribution