S4 DDD

What is a "field" in a database?

• A row in a table

• A column in a table

• The entire database

• A relationship between tables

Which of the following is the primary purpose of a database?

• To create spreadsheets

• To store and manage data efficiently

• To design websites

• To write computer programs

What does the term "record" refer to in a database?

• A single piece of data (e.g., a name)

• A collection of related fields

• A table in the database

• A query result

What is a "primary key" used for?

• To sort data alphabetically

• To uniquely identify each record in a table

• To create relationships between tables

• To filter data in a query

Which of the following is a common database operation used to retrieve specific data?

• Formatting

• Querying

• Debugging

• Compiling

What is a "relationship" in a database?

• A single piece of data

• A connection between two or more tables

• A type of query

• A database report

A ​ (a)   relationship allows one record in a table to be related to many records in another table? ​

• One-to-many
• one-to-one
• Many-to-many
• zero-to-one

SQL is an acronym for​ (a)  

• Structured Query Language
• Simple Query Language
• System Query Logic
• Sequential Query List

In a database, what is a "data type"?

• A method of sorting data

• The type of data that can be stored in a field (e.g., text, number, date)

• A type of query

• A way to create relationships

Which of the following best describes the purpose of a "foreign key"?

• To uniquely identify records within a table.

• To create a link between two tables.

• To sort data in a table.

• To filter data in a query.