WGU D426 Data Management

Which requirement within large, complex databases ensures users have limited access to the database?
Recovery
Performance
Authorization
Confidentiality – correct answer✔✔ Authorization
Which design type specifies database requirements without regard to a specific database system?
Physical design
Conceptual design
Logical design
Abstract design – correct answer✔✔ Conceptual design

3. What characterizes the rules of relational databases?
   -They are logical constraints that ensure the data is valid.
   -They are based on business policy and specific databases.
   -They represent data volumes and rapidly changing data structures.
   -They embody the theoretical foundation of the SQL language. – correct answer✔✔ They are logical
   constraints that ensure the data is valid.
4. Which event will result in an error code and error description when using MySQL Server?
   When the server or updates are incorrectly installed

When an SQL statement is entered to locate errors in the database
When an SQL statement is syntactically incorrect
When a Mac OS shortcut code is used on a Windows OS – correct answer✔✔ When an SQL statement is
syntactically incorrect

5. Which data type should be used to store whole integer values, such as age?
   NUM
   VARCHAR
   DATE
   INT – correct answer✔✔ INT
6. Which text-based interface is included in the MySQL Server Download?
   MySQL Command-Line Client
   MySQL Workbench
   MySQL Enterprise
   MySQL Community – correct answer✔✔ MySQL Command-Line Client
7. Which database system includes the World database during its installation?
   MySQL
   MongoDB
   Oracle
   PostgreSQL – correct answer✔✔ MySQL
8. What is the standardized language of relational database systems?
   Contextual Query Language

Structured Query Language
Select Query Language
Object Query Language – correct answer✔✔ Structured Query Language

9. 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) – correct answer✔✔ Data Control Language (DCL)
10. 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) – correct answer✔✔ Data Transaction Language (DTL)
11. Which format is used by the TIME data type in MySQL?
    YYYY-MM-DD
    YYYY-MM-DD hh:mm:ss
    hh:mm:ss
    hh:mm:ss YYYY-MM-DD – correct answer✔✔ hh:mm:ss

13. Which operator is used to compare columns from the left and right tables in MySQL?

<=

+

*

14. Which type of join combines two tables without comparing columns?

SELF
EQUIJOIN
OUTER
CROSS
CROSS

15. Which type of join compares columns using only the = operator?

Equijoin
Non-equijoin
Outer join
Inner join
Equijoin

16. 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
EQUIJOIN

17. What is another name for a subquery?

Outer query
Nested query
Correlated query
Search query
Nested query

18. Which operator is used to compare against a list of values when determining a match in a WHERE clause?

IN
BETWEEN
LIKE
OR
IN

19. Which wildcard character is used to represent zero or more characters when searching for a specified pattern using a LIKE operator?

%
_
< >
%

20. Which function is considered an aggregating function in SQL?

TRIM
REPLACE
MIN
SUBSTRING
MIN

21. Which clause or function is used with aggregate functions to produce summary rows?

TRIM
REPLACE
ORDER BY
GROUP BY
GROUP BY

22. Which type of join returns only the matching values when selecting rows from two or more tables?

Full Join
Outer Join
Equijoin
Inner Join
Inner Join

23. Which join type selects only matching left and right table rows?

Full Join
Left Join
Right Join
Inner Join
Inner Join

24. Which phrase refers to the view in which data is persisted and is automatically changed as the underlying data is changed?

Virtual View
Snapshot View
Denormalized View
Materialized View
Materialized View

25. Which SQL command uses the correct syntax to update the salary of an employee in the Employee table?

CHANGE Employee Salary = 50000 WHERE ID = 1;
UPDATE Employee SET Salary = 50000 WHERE ID = 1;
ALTER Employee SET Salary = 50000 WHERE ID = 1;
UPDATE Employee (Salary) = (50000) WHERE ID = 1;
UPDATE Employee SET Salary = 50000 WHERE ID = 1;

Download the full exam pdf here https://learnexams.com/search/study?query=