Database Concepts and Normalization Quiz

Which of the following is a feature of a Database Management System (DBMS)?

• Text editing

• Data redundancy

• Data security

• Image processing

What is the primary purpose of normalization in database design?

• To increase data redundancy

• To ensure data integrity and reduce redundancy

• To enhance data visualization

• To improve data encryption

Which of the following is a Data Definition Language (DDL) command?

• SELECT

• INSERT

• CREATE

• UPDATE

In the context of normalization, what is the main goal of the First Normal Form (1NF)?

• To remove all duplicate columns

• To ensure that all columns are atomic

• To create foreign keys

• To establish primary keys

Which of the following is NOT a feature typically provided by a DBMS?

• Data storage management

• Network routing

• Backup and recovery

• Data integrity

What does the ALTER command in DDL do?

• It retrieves data from the database

• It modifies the structure of an existing database object

• It deletes data from the database

• It inserts new data into the database

Which of the following is a requirement for a table to be in Third Normal Form (3NF)?

• It must have a composite key

• It must have no transitive dependencies

• It must have a single column

• It must have no primary key

Which of the following is a benefit of using a DBMS?

• Increased data redundancy

• Improved data sharing

• Slower data retrieval

• Manual data processing

In normalization, what is the purpose of the Second Normal Form (2NF)?

• To ensure that all non-key attributes are fully functional dependent on the primary key

• To remove all duplicate rows

• To create a composite key

• To establish foreign key relationships

Which DDL command is used to create a new database?

• CREATE DATABASE

• INSERT DATABASE

• SELECT DATABASE

• UPDATE DATABASE