CXC - Caribbean Examinations Council Information Technology: Database Management Questions and Answers

Question 1

In a relational database for a school, the 'Students' table needs a field that uniquely identifies each student. Which type of key should be used for the 'StudentID' field?

Accepted Answer

Primary Key

Answer

Foreign Key

Answer

Composite Key

Answer

Sort Key

Question 2

A database administrator needs to create a new table to store information about suppliers. Which of the following SQL commands belongs to the Data Definition Language (DDL) and would be used for this task?

Accepted Answer

CREATE

Answer

INSERT

Answer

UPDATE

Answer

SELECT

Question 3

A hospital database has a 'Patients' table and a 'Doctors' table. To establish a many-to-many relationship showing which doctors have treated which patients, a third table called 'Treatments' is created. This 'Treatments' table contains both 'PatientID' and 'DoctorID'. In the 'Treatments' table, 'PatientID' is an example of a:

Accepted Answer

Foreign Key

Answer

Candidate Key

Answer

Super Key

Answer

Primary Key

Question 4

Which of the following is a primary function of a Database Management System (DBMS)?

Accepted Answer

Enforcing data security and user access control.

Answer

Creating graphical assets for a user interface.

Answer

Compiling program code into an executable file.

Answer

Providing an operating system for a server.

Question 5

The process of organizing data in a database to reduce redundancy and improve data integrity by creating smaller, well-structured tables is known as:

Accepted Answer

Normalization

Answer

Validation

Answer

Encryption

Answer

Indexing

Question 6

A database field is intended to store whether a customer has subscribed to a newsletter. The only possible values are 'Yes' or 'No'. Which of the following data types is the MOST efficient and appropriate for this field?

Accepted Answer

Boolean/Logical

Answer

Text/Varchar

Answer

Number/Integer

Answer

Date/Time