A table is also known as a (a)   in a relational database.

In SQL, the command used to retrieve data from a table is (a)   .

A (a)   uniquely identifies each record in a table.

DDL stands for ______.

The (a)   constraint ensures that a column cannot have NULL values.

SQL stands for ______.

The command to remove a table completely from the database is (a)   .

The smallest unit of data in a table is called a (a)   .

The property of a transaction that ensures changes are saved permanently is (a)   .

What is the primary function of a DBMS?

Define entity in the context of ER model.

What is a tuple in relational databases?

Name any two DML commands.

What does the term "relation" mean in RDBMS?

What is the use of the SELECT statement in SQL?

Define schema in DBMS.

List any two aggregate functions in SQL.

What is a foreign key?

What is the role of the WHERE clause in SQL?

(a)   is the process of organizing data to reduce redundancy.

The (a)   key is a field (or combination) that uniquely identifies a record.

(a)   join returns rows when there is a match in both tables.

In ER diagram, attributes are represented by (a)   .

(a)   constraints ensure values in a column match values in another table.

The clause used to sort the result in SQL is (a)   .

(a)   operator is used for pattern matching in SQL.

2NF removes (a)   dependency.

A (a)   is a named SQL query stored in the database.

In ER diagram, relationship is represented by a (a)   .

What is normalization in DBMS?

Explain the purpose of the GROUP BY clause in SQL.

What is a candidate key?

Define referential integrity.

Mention one difference between DELETE and TRUNCATE.

What are composite attributes?

Define the term "view" in SQL.

List two advantages of using DBMS over file systems.

What is the purpose of indexing in a database?

Explain the concept of a trigger in SQL.

(a)   is a system-generated key used to uniquely identify records.

The isolation level ______ allows transactions to read uncommitted changes.

BCNF stands for ______.

(a)   operations like UNION, INTERSECT combine result sets.

The ACID property that ensures intermediate results are hidden from other transactions is (a)   .

What is a deadlock in transaction processing?

Define phantom read in DBMS.

What is a materialized view?

Explain serializability in transactions.

Name and describe any one advanced indexing technique.