DSE Database Management System Quiz

What is the primary purpose of a Database Management System (DBMS)?

• To perform calculations

• To create user interfaces

• To store and retrieve data efficiently

• To manage hardware resources

Which of the following is a characteristic of databases?

• Data redundancy

• Data independence

• Data isolation

• Data fragmentation

Which of the following is NOT a type of normalization form?

• Second Normal Form

• First Normal Form

• Zero Normal Form

• Fifth Normal Form

• Fourth Normal Form

Which of the following is a command used to manipulate data in SQL?

• CREATE

• SELECT

• ALTER

• DROP

What is the purpose of a primary key in a database?

• To store large amounts of data

• To link tables together

• To uniquely identify a record

• To allow duplicate entries

What is the function of a Database Administrator?

• To write application code

• To manage database security and performance

• To perform data analysis

• To design user interfaces

Which of the following is a feature of relational databases?

• Data is stored in files

• Data is organized in tables

• Data is stored in arrays

• Data is stored in objects

What is a foreign key?

• A key that uniquely identifies a record

• A key that links to a primary key in another table

• A key that is used for indexing

• A key that is generated automatically

Which SQL command is used to remove a table from a database?

• DROP

• TRUNCATE

• REMOVE

• DELETE

What is the purpose of normalization in database design?

• To simplify data retrieval

• To increase data redundancy

• To enhance data security

• To reduce data redundancy