IC3 Database Applications 3

Question 1

What is the purpose of an index in a database?

Accepted Answer

To speed up data retrieval and search operations

Answer

To list all tables in the database

Answer

To define the visual layout of a form

Answer

To restrict user access permissions

Question 2

In a database table, what does the term 'data type' refer to?

Accepted Answer

The format that defines what kind of data a field can store

Answer

The name assigned to a table

Answer

The relationship between two tables

Answer

The order in which records are displayed

Question 3

Which SQL keyword is used to retrieve data from a database table?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 4

What happens when you delete a record from a database?

Accepted Answer

The record's data is permanently removed from the table

Answer

The record is moved to a recycle bin and can be restored anytime

Answer

The record is hidden but still counted in reports

Answer

The record is automatically archived to another table

Question 5

What is the advantage of using a relational database over a flat file database?

Accepted Answer

Relational databases eliminate data redundancy by linking related tables

Answer

Relational databases can only store text data

Answer

Flat file databases support more users simultaneously

Answer

Flat file databases are faster for all types of queries

Question 6

Which of the following is NOT a common database object in Microsoft Access?

Accepted Answer

Slide

Answer

Table

Answer

Query

Answer

Report

Question 7

What does DBMS stand for in the context of database software?

Accepted Answer

Database Management System

Answer

Data Backup and Management System

Answer

Digital Binary Memory Storage

Answer

Distributed Base Mapping Service