DBMS

A primary key in a database can have duplicate values.

• True

• False

A foreign key can reference multiple primary keys in different tables.

• True

• False

The ACID properties in a database stand for Atomicity, Consistency, Isolation, and Durability.

• True

• False

The SQL SELECT statement is used to delete records from a table.

• True

• False

Normalization helps remove redundancy in a database.

• True

• False

Which of the following is NOT a type of database?

• Hierarchical Database

• Relational Database

• Modular Database

• Object-Oriented Database

What is the function of a foreign key in a relational database?

• Uniquely identifies each record
  

• Establishes a relationship between two tables

• Allows NULL values only

• Speeds up query execution

Which SQL command is used to create a new table?

• CREATE

• INSERT

• UPDATE

• ALTER

In which normal form are transitive dependencies removed?

• 1st Normal Form

• 2nd Normal Form

• 3rd Normal Form

• 4th Normal Form

Which of the following is NOT a SQL constraint?

• UNIQUE

• CHECK

• EXISTS

• DEFAULT