N5 Database Design Revision Quiz

What does an Entity-Relationship Diagram (ERD) primarily represent in database design?

• The physical layout of the database

• The logical structure of the database

• The actual data stored in the database

• The users of the database

Which SQL query is used to retrieve all records from a table named `Students`?

• `SELECT * FROM Students;`

• `INSERT INTO Students VALUES (...);`

• `UPDATE Students SET ...;`

• `DELETE FROM Students;`

What is the purpose of validation in database design?

• To speed up database queries

• To ensure data integrity and accuracy

• To create relationships between tables

• To delete unnecessary data from the database

In a data dictionary, what information is typically provided for each attribute?

• The attribute's name, data type, and any constraints

• The SQL queries related to the attribute

• The physical storage location of the attribute

• The number of records that use the attribute

What type of relationship in a database involves two tables where a record in one table can be associated with multiple records in another table?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

Which SQL statement is used to add a new record to a table named `Orders`?

• `SELECT * FROM Orders;`

• `INSERT INTO Orders VALUES (...);`

• `UPDATE Orders SET ...;`

• `DELETE FROM Orders;`

Which of the following is a benefit of using a data dictionary in database development?

• Increases the speed of database queries

• Provides a plan of the entities and their attributes

• Automatically updates data in the database

• Reduces the need for testing

In SQL, how do you modify the value of a column for all records in a table named `Products` where the `Category` is 'Electronics'?

• `UPDATE Products SET Category = 'Electronics';`

• `UPDATE Products SET Category = 'Electronics' WHERE Category = 'Electronics';`

• `UPDATE Products SET ColumnName = NewValue WHERE Category = 'Electronics';`

• `SELECT * FROM Products WHERE Category = 'Electronics';`

What is the primary purpose of testing in database development?

• To design the database schema

• To ensure the database meets specified requirements

• To populate the database with data

• To create user interfaces for the database

Which of the following is a type of integrity constraint in a relational database?

• Referential integrity

• Domain integrity

• Distributive integrity

• Entity integrity