1. In a relational database, what is a table?
Explanation: In a relational database, a table is a collection of records
Report for correction3. What is a composite key in database design?
Explanation: A composite key is made up of multiple columns and is used to uniquely identify records.
Report for correction4. What is a foreign key in a relational database?
Explanation: A foreign key is used to establish a relationship between tables.
Report for correction5. What is a primary key?
Explanation: A primary key is a unique identifier for a record in a table.
Report for correction6. What is a database transaction?
Explanation: A database transaction is a series of database operations treated as a single unit for data consistency.
Report for correction7. Which term refers to a row in a database table?
Explanation: A record is a row in a database table
Report for correction8. What does DBMS stand for?
Explanation: DBMS stands for Database Management System.
Report for correction9. What is a SQL JOIN used for?
Explanation: A SQL JOIN is used to combine data from multiple tables based on a related column.
Report for correction10. What is a database index used for?
Explanation: A database index improves data retrieval performance by enabling faster searching.
Report for correction11. What is an ERD in database design?
Explanation: ERD stands for Entity-Relation Diagram, used for visualizing database relationships.
Report for correction12. Which SQL command is used to update existing data in a table?
Explanation: The UPDATE command is used to update existing data in a table.
Report for correction13. Which term refers to the structure that defines the data format and relationships in a database?
Explanation: A schema defines the structure and organization of data in a database.
Report for correction14. What is normalization in database design?
Explanation: Normalization is the process of splitting data into smaller tables to reduce redundancy.
Report for correction15. What is cardinality in a database relationship?
Explanation: Cardinality refers to the number of related records between tables in a database relationship.
Report for correction