ICT Database Management Concepts 5

Question 1

Which SQL statement is used to modify existing records in a table?

Accepted Answer

UPDATE

Answer

The UPDATE statement changes existing data in one or more rows of a table based on a specified condition.

Question 2

What is data integrity in a database?

Accepted Answer

The accuracy, consistency, and reliability of data stored in a database

Answer

Data integrity ensures that data remains accurate, consistent, and trustworthy throughout its lifecycle in the database.

Question 3

Which type of database backup copies only the data that has changed since the last full backup?

Accepted Answer

Incremental backup

Answer

An incremental backup saves only the data that has changed since the last backup, reducing storage and time requirements.

Question 4

What is a composite key in a relational database?

Accepted Answer

A primary key made up of two or more columns

Answer

A composite key uses two or more columns together to uniquely identify a row in a table.

Question 5

Which SQL command is used to add a new column to an existing table?

Accepted Answer

ALTER TABLE ... ADD

Answer

ALTER TABLE with the ADD clause modifies an existing table's structure by adding a new column.

ICT - Information Communication Technology Practice Test