SQL D427 Applications Exam Questions with complete
solution 2025/2026
1. Children living within the boundaries of two
school dis- 3 tricts will be attending one of four
different schools. How many entities are present
in the narrative?
2. Which data type will store "2022-01-10 datetime
14:22:12" as a temporal value without loss of
information?
Many-to-Many
3. A data set currently contains horse details. A
new re-quirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-
competition re-lationship?
4. What is a primary function of a Database Management Storing,
retrieving, and
System (DBMS)? managing data
5. What is the role of SQL in a database system? It is used to query and ma-
nipulate data
6. Which term refers to a unique identifier for a record in Primary Key
a database table?
7. The School table will have the following maximum 20
columns: SchoolID—positive integer char-acters
SchoolName—variable-length string,
maximum 50 characters
DateConstructed—date
OperatingBudget—positive decimal value of
up to 99.9, with one decimal place
Classification—fixed-length string with one
character President—variable-length string,
1/
15
, CREATE TABLE School ( SchoolID INT UNSIGNED,
SchoolName VAR-CHAR(50),
DateConstructed DATE, OperatingBudget DECI-MAL(3,1) UNSIGNED,
Classification CHAR(1), President VARCHAR(20)
);
2/
15
solution 2025/2026
1. Children living within the boundaries of two
school dis- 3 tricts will be attending one of four
different schools. How many entities are present
in the narrative?
2. Which data type will store "2022-01-10 datetime
14:22:12" as a temporal value without loss of
information?
Many-to-Many
3. A data set currently contains horse details. A
new re-quirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-
competition re-lationship?
4. What is a primary function of a Database Management Storing,
retrieving, and
System (DBMS)? managing data
5. What is the role of SQL in a database system? It is used to query and ma-
nipulate data
6. Which term refers to a unique identifier for a record in Primary Key
a database table?
7. The School table will have the following maximum 20
columns: SchoolID—positive integer char-acters
SchoolName—variable-length string,
maximum 50 characters
DateConstructed—date
OperatingBudget—positive decimal value of
up to 99.9, with one decimal place
Classification—fixed-length string with one
character President—variable-length string,
1/
15
, CREATE TABLE School ( SchoolID INT UNSIGNED,
SchoolName VAR-CHAR(50),
DateConstructed DATE, OperatingBudget DECI-MAL(3,1) UNSIGNED,
Classification CHAR(1), President VARCHAR(20)
);
2/
15
