AMCAT Computer Science: DBMS Concepts 2

Question 1

Which normal form eliminates transitive dependencies?

Accepted Answer

3NF

Answer

1NF

Answer

2NF

Answer

BCNF

Question 2

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Consistency, Integrity, Durability

Answer

Atomicity, Concurrency, Isolation, Durability

Answer

Atomicity, Consistency, Integrity, Distribution

Question 3

Which SQL clause is used to filter groups after a GROUP BY?

Accepted Answer

HAVING

Answer

WHERE

Answer

FILTER

Answer

GROUP FILTER

Question 4

Which 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 5

What is the purpose of a foreign key?

Accepted Answer

To enforce referential integrity between tables

Answer

To uniquely identify rows

Answer

To speed up queries

Answer

To encrypt data

Question 6

Which of the following is NOT a type of database index?

Accepted Answer

Loop index

Answer

B-Tree index

Answer

Hash index

Answer

Clustered index