Fundamentals of Database Management

What does SQL stand for?

• Structured Query List

• Structured Query Language

• Standard Query Language

• Simple Query Language

Which SQL command is used to retrieve data?

• INSERT

• DELETE

• SELECT

• UPDATE

What is the purpose of the Entity-Relationship Model?

• To optimize query performance in SQL databases.

• To create a programming language for database management.

• To store data in a flat file format.

• To visually represent data structures and relationships in database design.

In an ER diagram, what does a rectangle represent?

• A rectangle represents an attribute.

• A rectangle represents an entity.

• A rectangle represents a constraint.

• A rectangle represents a relationship.

What is a primary key in a database?

• A primary key is a type of foreign key in a database.

• A primary key can have duplicate values in a database.

• A primary key is a unique identifier for a record in a database.

• A primary key is used to store large amounts of data in a database.

What is a foreign key?

• A foreign key is a field in a table that links to the primary key of another table.

• A foreign key is a unique identifier for a table.

• A foreign key is a type of primary key.

• A foreign key is a field that cannot be null.

What is the purpose of data integrity constraints?

• To enhance the speed of data retrieval in a database.

• To provide a backup for lost data in a database.

• The purpose of data integrity constraints is to maintain the accuracy and consistency of data in a database.

• To allow unlimited data entry without restrictions.

Name one type of data integrity constraint.

• Primary key constraint

• Unique constraint

• Foreign key constraint

• Check constraint

What is the main difference between a file system and a database management system?

• A file system manages files, while a database management system manages structured data.

• A file system requires SQL for data manipulation, while a database management system does not.

• A file system is used for data backup, while a database management system is for data retrieval.

• A file system stores data in tables, while a database management system stores files.

What are the advantages of using a database management system?

• Increased data duplication

• Advantages of using a database management system include data integrity, security, efficient management, reduced redundancy, and improved access.

• Limited data access

• Higher maintenance costs