Database Concepts Quiz No 2

In a database context, what does a "record" refer to?

• A collection of related files

• A single row in a table representing a complete set of related data

• A category of data types

• A file stored on disk

Which term describes a single piece of information within a record?

• File

• Field

• Attribute

• Composite key

What is a "field" in a database?

• A collection of related records

• A single piece of information within a record

• A type of data structure

• A secondary key

What is an "attribute" in the context of a database?

• A primary key for a table

• A field that allows NULL values

• A grouping of related records

• A characteristic of an entity represented by a column in a table

What is a "primary key" in a database table?

• A unique identifier for each record in the table

• A field that allows duplicate values

• A field that cannot contain NULL values

• A field used for sorting data

What is a "composite key" in a database?

What is a "foreign key" in a relational database?

• A) A key that is used for encryption

• B) A key that uniquely identifies each record in a table

• C) A key that references the primary key in another table

• D) A key that is used for indexing purposes

In a database system, what is a "file"?

• A) A collection of related records

• B) A single record in a table

• C) A data type

• D) A software program used for database management

Which term refers to a unique identifier for each record in a table that is composed of more than one field?

• A) Primary key

• B) Composite key

• C) Foreign key

• D) Secondary key

What term is used to describe the process of organizing data into tables to minimize redundancy and dependency?

• A) Normalization

• B) Denormalization

• C) Abstraction

• D) Concatenation