SOF102 Topic 6

Which of the following best defines a database?

• A collection of programs

• A structured set of data files

• A network of computer systems

• A method to design software

Which of the following is the smallest unit of data in a database?

• Record

• File

• Field

• Bit

What does a record represent in a table?

• A data file

• A single attribute

• A row of related fields

• A column

Which of the following is NOT a relational database management system (RDBMS)?

• Microsoft SQL Server

• Oracle

• MySQL

• Linux

Which is used to uniquely identify each record in a table?

• Foreign key

• Index

• Primary key

• Attribute

A foreign key in a table:

• Must contain unique values

• Is not required

• Links to a primary key in another table

• Stores temporary data

In many-to-many relationships, a third table is used. This table is called:

• Reference table

• Join table

• Master table

• Bridge record

Which of the following is NOT a common data type in databases?

• Character

• Numeric

• Logical

• Format

Attribute domain refers to:

• Column header format

• Valid range of values for an attribute

• Size of the database

• Attribute number

What happens in a cascading delete operation?

• Deletes all records

• Deletes matching records in a related table

• Updates data types

• Deletes all columns