Page 1 of 87
ALL THE BEST CHAMP!!
1
WGU D426 DATA MANAGEMENT FOUNDATIONS EXAM
250 QUESTIONS AND CORRECT DETAILED ANSWERS
LATEST UPDATE THIS YEAR - JUST RELEASED
QUESTION: Which text-based interface is included in the MySQL Server download?
- MySQL Command-Line Client
- MySQL Workbench
- MySQL Enterprise
- MySQL Community - ANSWER-A. MySQL Command-Line Client
QUESTION: Which database system includes the World database during its installation?
- MySQL
- MongoDB
- Oracle
- PostgreSQL - ANSWER-A. MySQL
QUESTION: What is the standardized language of relational database systems?
- Contextual Query Language 1 / 4
Page 2 of 87
ALL THE BEST CHAMP!!
2
- Structured Query Language
- Select Query Language
- Object Query Language - ANSWER-B. Structured query language
QUESTION: Which SQL sublanguage is used to manage database access?
- Data Definition Language (DDL)
- Data Query Language (DQL)
- Data Manipulation Language (DML)
- Data Control Language (DCL) - ANSWER-D. Data Control Language DDL
QUESTION: Which SQL sublanguage is used to roll back database changes?
- Data Transaction Language (DTL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL) - ANSWER-A. Data Transaction Language - DTL
QUESTION: Which format is used by the TIME data type in MySQL?
A. YYYY-MM-DD
- YYYY-MM-DD hh:mm:ss 2 / 4
Page 3 of 87
ALL THE BEST CHAMP!!
3
- hh:mm:ss
- hh:mm:ss YYYY-MM-DD - ANSWER-C. hh:mm:ss
QUESTION: Which MySQL operator is the last in the order of operator precedence?
- -
- OR
C. NOT
D. = - ANSWER-B. OR
QUESTION: Which operator is used to compare columns from the left and right tables in MySQL?
- <=
- =
- +
D. * - ANSWER-B. =
QUESTION: Which type of join combines two tables without comparing columns?
A. SELF
B.EQUIJOIN 3 / 4
Page 4 of 87
ALL THE BEST CHAMP!!
4
C. OUTER
D. CROSS - ANSWER-D. CROSS
QUESTION: Which type of join compares columns using only the = operator?
- Equijoin
- Non-equijoin
- Outer join
- Inner join - ANSWER-A. Equijoin
QUESTION: Which type of join is demonstrated by the following query?
SELECT Dog. Nickname, Kennel.Address FROM Dog, Kennel WHERE Dog.KennelID = Kennel.ID
- Non-equijoin
- Self join
- Cross join
- Equijoin - ANSWER-D. Equijoin
- / 4