Databases - Multiple Choice Questions ( CHAPTER 3)

What is a database?

• A set of tables that store data

• A collection of spreadsheets

• A type of software

• A type of programming language

Which of the following is a record in a database?

• A single column in a table

• A collection of fields

• A row in a table

• A database table

What is the primary key in a database?

• A column with unique values

• A field that stores data

• A type of query

• A foreign key

Which command is used to retrieve data from a database?

• SELECT

• INSERT

• DELETE

• UPDATE

Which type of relationship is represented when one record in a table is related to many records in another table?

• One-to-one

• One-to-many

• Many-to-many

• Self-referencing

What does normalization do in a database?

• Reduces redundancy

• Adds more fields

• Deletes unnecessary records

• Creates foreign keys

Which of the following is a feature of a relational database?

• Data is stored in tables

• Data is stored in files

• Data is stored in objects

• Data is stored in arrays

Which of the following SQL commands is used to add a new record to a table?

• INSERT INTO

• SELECT

• UPDATE

• DELETE

Which SQL command is used to modify an existing record in a table?

• SELECT

• INSERT INTO

• UPDATE

• DELETE

What is the function of the foreign key in a relational database?

• To uniquely identify records

• To link two tables

• To store user data

• To store passwords