Database Management Quiz

What is one of the main functions of a DBMS?

• Designing user interfaces

• Encrypting data automatically

• Controlling access to data

• Performing web hosting tasks

Which best defines a database instance?

• A backup of the database

• The data stored at a particular moment

• A data model

• The structure of database tables

A candidate key must always be:

• Null

• Unique

• Composite

• A foreign key

Which SQL command is used to change data in existing records?

• MODIFY

• INSERT

• UPDATE

• APPEND

What is the purpose of a primary key?

• To allow null values

• To link to external databases

• To uniquely identify records

• To speed up queries

Which of the following is an example of a foreign key?

• A column that is always null

• A unique identifier in a table

• A key that references the primary key in another table

• An attribute that can be broken down

Which SQL statement is used to retrieve specific columns from a table?

• SELECT column_name FROM table_name

• GET column_name FROM table_name

• FETCH column_name FROM table_name

• PRINT column_name FROM table_name

The keyword 'NOT NULL' in SQL is used to:

• Allow zero values

• Set default values

• Prevent blank values

• Allow duplicates

Physical level data abstraction deals with:

• What data is stored

• How data is stored

• Who accesses the data

• Where data is displayed

A student’s GPA should be classified as a:

• Composite attribute

• Derived attribute

• Multi-valued attribute

• Key attribute