Database Management System Quiz

What is an Entity-Relationship Model used for in a database?

• It is used to create animations in the database

• It is used to play music in the database

• It is used to generate random data for the database

• It is used to design the database schema and visualize the relationships between different entities.

How are entities and relationships represented in an Entity-Relationship Model?

• Entities are represented as circles and relationships are represented as stars.

• Entities are represented as hexagons and relationships are represented as ovals.

• Entities are represented as triangles and relationships are represented as squares.

• Entities are represented as rectangles and relationships are represented as diamonds.

Why is SQL used in database management?

• To play music in the background

• To create 3D animations

• To send emails

• To query, insert, update, and delete data in a relational database.

What is the purpose of the SELECT statement in SQL?

• Creating a new database

• Deleting data from a database

• Retrieving data from a database

• Updating data in a database

What is indexing in the context of a database?

• A method for organizing data in a spreadsheet

• A type of encryption used to secure data

• A process for deleting data from a database

• A data structure to improve the speed of data retrieval operations

How does indexing improve the performance of database queries?

• By increasing the complexity of the database structure

• By causing the database to retrieve all rows in a table

• By allowing the database to quickly locate specific rows in a table

• By slowing down the database performance

What are some common methods of data security in a database?

• Using weak passwords for database access

• Storing sensitive data in plain text

• Data sharing with unauthorized users

• Encryption, access control, data masking, and regular backups

Why is it important to encrypt sensitive data in a database?

• To make the data more vulnerable to hacking

• To slow down the database performance

• To protect it from unauthorized access and ensure data security.

• To make the data more difficult to access