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

An index stores a sorted reference to key field values, allowing the database engine to find matching records much faster than scanning every record.

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

A data type specifies what kind of data a field can hold — such as text, number, date, or Boolean — and determines how the data is stored and used.

Question 3

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

Accepted Answer

SELECT

Answer

The SELECT statement is the fundamental SQL command for querying and retrieving data from one or more database tables.

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

Deleting a database record permanently removes that row's data from the table; unlike the OS recycle bin, database deletes are typically irreversible without a backup.

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 store data across multiple linked tables, avoiding repetition of the same information and making updates consistent across all related records.

IC3 - Digital Literacy Certification Practice Test

IC3 - Digital Literacy Certification Practice Test

IC3 Database Applications 3