Sign In

Computer Science for IGCSE & O level - Databases (Section 1)

1
What does the 'Length check' validation rule check for?
Answer
(C)
The number of characters in the data.
2
What is the purpose of the `Format` property for a field in a database?
Answer
(B)
To control how data is displayed.
3
Which of the following is true about the `FROM` clause in an SQL query?
Answer
(A)
It specifies which table to query.
4
Which of the following is an example of a DDL (Data Definition Language) command?
Answer
(C)
CREATE TABLE
5
Which of the following is NOT a typical function of a database management system (DBMS)?
Answer
(D)
Operating system management
6
What is the purpose of the 'Required' property for a field in a database?
Answer
(C)
To prevent the field from being left blank.
7
What is the purpose of the 'WHERE' clause in an SQL query?
Answer
(C)
To filter the records based on a condition.
8
What does the term 'database' primarily refer to?
Answer
(C)
An organized collection of data.
9
Which SQL command is used to delete records from a table?
Answer
(B)
DELETE
10
What does the 'SUM' function do in an SQL query?
Answer
(C)
Calculates the sum of values in a column.
11
What is the purpose of a primary key in a database table?
Answer
(B)
To identify a record uniquely.
12
What is a database used for in healthcare?
Answer
A
B
C
D
13
In the context of the provided material, what is the purpose of validation checks?
Answer
(B)
To ensure data is accurate and meets specific requirements.
14
What is an example of DML in SQL?
Answer
(C)
SELECT
15
What does the abbreviation 'DBMS' stand for?
Answer
(D)
Database Management System
16
What does the SQL command 'CREATE TABLE' do?
Answer
(B)
Creates a table definition.
17
What type of data is typically stored in an `INTEGER` data type?
Answer
(C)
Whole numbers
18
What are some common types of validation checks?
Answer
A
B
D
19
Which data type would you most likely use to store a value that could be TRUE or FALSE?
Answer
(C)
BOOLEAN
20
Which data type would be most appropriate for storing a person's first name?
Answer
(C)
Text
21
What is the primary purpose of a database?
Answer
(A)
To store and organize data
22
What is the function of the `ALTER TABLE` SQL command?
Answer
(B)
To modify an existing table structure.
23
What is the correct SQL command to retrieve all fields from a table named 'Patients'?
Answer
(A)
SELECT * FROM Patients;
24
What is an example of a suitable validation rule for a date of birth field?
Answer
(B)
Require a date format.
25
What is a single-table database?
Answer
(B)
A database containing only one table.
26
How are SQL statements written?
Answer
(B)
As a script.
27
In the context of a database, what does 'normalization' refer to?
Answer
(B)
Organizing data to reduce redundancy and improve data integrity.
28
In a car database, how could you use SQL to find all combinations of red seat colour and silver paint colour?
Answer
(A)
SELECT * FROM CAR WHERE SeatColour = 'Red' AND PaintColour = 'Silver';
29
Which of the following are benefits of using databases?
Answer
A
B
C
D
30
What is the purpose of the `COUNT` function in SQL?
Answer
(B)
To count the number of records that meet certain criteria.
31
What does the term 'record' refer to in a database?
Answer
(C)
A single instance of data stored in a table.
32
What would the SQL command be to display the family name, other names and email address in alphabetical order of the family name?
Answer
(A)
SELECT FamilyName, OtherNames, EmailAddress FROM Students ORDER BY FamilyName;
33
What is the purpose of an `SQL script`?
Answer
(C)
To perform a specific task, often to be reused.
34
What data type is most appropriate for storing a patient's ward number?
Answer
(C)
Integer
35
What is one of the functionalities in the 'Extension Activity'?
Answer
(B)
Use DML commands to set up the PATENT database.
36
If a database table stores information about books, what could be a suitable primary key?
Answer
(C)
ISBN
37
Which of the following is NOT an example of a validation check?
Answer
(D)
Query check
38
Which of the following statements is true regarding the `SELECT` statement in SQL?
Answer
(B)
It's used to retrieve data from one or more tables.
39
What is the purpose of a primary key in a database?
Answer
(B)
To uniquely identify each record in a table.
40
What is the difference between the terms 'table' and 'database'?
Answer
(B)
A database is a container for tables.
41
In a database, what does 'normalization' refer to?
Answer
(B)
The process of organizing data to reduce redundancy and improve data integrity.
42
What is a data type used for in a database?
Answer
(D)
To classify how data is stored and displayed.
43
What does DDL stand for in the context of databases?
Answer
(A)
Data Definition Language
44
In the provided example, what would be the correct SQL command to find records where SeatColour is 'Red' AND (White OR Silver)?
Answer
B
D
45
What are SQL scripts generally used for?
Answer
(B)
Automating database tasks.
46
What components make up a relational database?
Answer
A
B
C
D
47
In an SQL query, what does the `*` symbol represent?
Answer
(A)
All fields (columns)
48
Which of the following are considered key benefits of using a database?
Answer
B
C
D
49
What is the primary purpose of data redundancy?
Answer
(D)
To create multiple copies of data for backup and disaster recovery.
50
What does the term 'field' refer to in a database?
Answer
(B)
A column in a table