D426 Practice Test 2 Questions with Verified
Correct Answers
Which component is responsible for executing instructions from the query processor?
storage engine
The IN operator is used in a WHERE clause to:
Check if a value matches any value in a list
Consider the following database table Order with the following columns:
OrderID (Primary Key)
CustomerID
CustomerName
OrderDate
ProductID
ProductName
Quantity
Which of the following normal forms does the Order table currently satisfy IF:
1) Each OrderID has a unique value (i.e. is a primary key)
2) Each entry in the table is atomic (no repeating groups or arrays).
First Normal Form
Which operation combines rows from two tables based on related columns?
JOIN
In ER modeling, what describes the relationship between a salesperson and an office
space/cubicle?
One-to-One
What is the term for a row in a relational database?
tuple
, What is the main purpose of the MySQL Monitor in the Enterprise Edition?
To collect and display system performance information
What is a primary function of a Database Management System (DBMS)?
Managing database security and access
The MySQL Enterprise Edition includes components for:
High-end commercial installations, like backup and security
What is a composite attribute?
An attribute that can be divided into smaller parts, each representing a more basic attribute
What describes data in terms of scope, format, and access?
Data Characteristics
Which SQL command is used to create a new table?
CREATE TABLE
Which of the following best describes a strong entity?
An entity that has a unique identifying attribute
Which term describes the process of denormalization?
Merging Tables
Which layer of MySQL architecture manages connections from multiple users?
Query processor
The LIKE operator is used to:
Search for a specified pattern in a column
What is the purpose of an ER Diagram?
To visually represent the data model of a system
Which statement about NoSQL databases is true?
They are optimized for big data
______________ ensures the consistency and validity of relationships between tables. It
dictates that foreign key values in one table must either be null or match primary key values
in another table (or the same table in the case of self-referencing relationships)
Correct Answers
Which component is responsible for executing instructions from the query processor?
storage engine
The IN operator is used in a WHERE clause to:
Check if a value matches any value in a list
Consider the following database table Order with the following columns:
OrderID (Primary Key)
CustomerID
CustomerName
OrderDate
ProductID
ProductName
Quantity
Which of the following normal forms does the Order table currently satisfy IF:
1) Each OrderID has a unique value (i.e. is a primary key)
2) Each entry in the table is atomic (no repeating groups or arrays).
First Normal Form
Which operation combines rows from two tables based on related columns?
JOIN
In ER modeling, what describes the relationship between a salesperson and an office
space/cubicle?
One-to-One
What is the term for a row in a relational database?
tuple
, What is the main purpose of the MySQL Monitor in the Enterprise Edition?
To collect and display system performance information
What is a primary function of a Database Management System (DBMS)?
Managing database security and access
The MySQL Enterprise Edition includes components for:
High-end commercial installations, like backup and security
What is a composite attribute?
An attribute that can be divided into smaller parts, each representing a more basic attribute
What describes data in terms of scope, format, and access?
Data Characteristics
Which SQL command is used to create a new table?
CREATE TABLE
Which of the following best describes a strong entity?
An entity that has a unique identifying attribute
Which term describes the process of denormalization?
Merging Tables
Which layer of MySQL architecture manages connections from multiple users?
Query processor
The LIKE operator is used to:
Search for a specified pattern in a column
What is the purpose of an ER Diagram?
To visually represent the data model of a system
Which statement about NoSQL databases is true?
They are optimized for big data
______________ ensures the consistency and validity of relationships between tables. It
dictates that foreign key values in one table must either be null or match primary key values
in another table (or the same table in the case of self-referencing relationships)
