D127 Test Questions with 100% Correct
Answers
Children living within the boundaries of two school districts will be attending one of
four different schools.
How many entities are present in the narrative?
2
3
4
6
3
A data set currently contains horse details. A new requirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-competition relationship?
One-to-Many
Many-to-many
Many-to-one
One-to-one
Many-to-Many
Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of
information?
DATE
, DATETIME
DECIMAL
BIGINT
DATETIME
What is a primary function of a Database Management System (DBMS)?
Encrypting user passwords
Managing operating system updates
Storing, retrieving, and managing data
Designing user interfaces
Storing, retrieving, and managing data
What is the role of SQL in a database system?
It creates graphics for dashboards
It is a scripting language for webpages
It manages internet traffic
It is used to query and manipulate data
It is used to query and manipulate data
Which term refers to a unique identifier for a record in a database table?
Foreign key
Primary key
Composite key
Index
Answers
Children living within the boundaries of two school districts will be attending one of
four different schools.
How many entities are present in the narrative?
2
3
4
6
3
A data set currently contains horse details. A new requirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-competition relationship?
One-to-Many
Many-to-many
Many-to-one
One-to-one
Many-to-Many
Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of
information?
DATE
, DATETIME
DECIMAL
BIGINT
DATETIME
What is a primary function of a Database Management System (DBMS)?
Encrypting user passwords
Managing operating system updates
Storing, retrieving, and managing data
Designing user interfaces
Storing, retrieving, and managing data
What is the role of SQL in a database system?
It creates graphics for dashboards
It is a scripting language for webpages
It manages internet traffic
It is used to query and manipulate data
It is used to query and manipulate data
Which term refers to a unique identifier for a record in a database table?
Foreign key
Primary key
Composite key
Index
