DBMS Quiz

The purpose of a DBMS is to:

• Store data permanently

• Manage and manipulate data

• Handle queries only

• Provide graphical reports

Which of the following is a type of relationship in the ER model?

• One-to-One

• One-to-Many

• Many-to-Many

• All of the above

A primary key in a relational database must be:

• Unique and non-null

• Unique but nullable

• Nullable

• None of the above

Which SQL command is used to remove all records from a table but not the table itself?

• REMOVE

• DELETE

• TRUNCATE

• DROP

In SQL, which of the following commands is used to modify an existing record in a table?

• UPDATE

• MODIFY

• ALTER

• CHANGE

Which of the following is NOT a normal form in database normalization?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

Which of the following is true about a "view" in SQL?

• It is stored physically in the database

• It can be updated like a table

• It is a virtual table derived from one or more tables

• It is used to create indexes

In a relational database, a "foreign key" is used to:

• Identify the primary key of the table

• Enforce referential integrity

• Ensure that there are no duplicate values

• Sort the table by a specific column

Which of the following is used to join two tables based on matching values in certain columns?

• SELECT

• JOIN

• GROUP BY

• UNION

Which of the following is NOT a type of SQL join?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• MERGE JOIN