6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
WGU D426 Database OA Taken by: Wiseman
Score 129/ 129
Practice Test 2025
1. Database administrators must make sure that ________ measures are in place and
enforced so that only authorized users can take authorized actions at
appropriate times.
Correct answer
security
2. What scenario is likely to trigger an error code and message in MySQL
Server?
a) When a user attempts to connect to a database with invalid
credentials
b) When a valid SQL statement is executed successfully
c) When the database is accessed from a compatible operating
system
d) When a backup is restored without any issues
3. What is the SQL function that retrieves the highest value from a specified
column in a database table?
MAX()
MIN()
HIGHEST()
TOP()
,6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
4. What does the acronym SQL represent in the context of database
management?
Structured Query Language
Standard Query Language
Simple Query Language
Sequential Query Language
5. You can use the ___________ statement to rename an existing table.
Correct answer
RENAME TABLE
6. Which of the following is the primary purpose of using a database?
To keep track of data
To create text files on the user's computer that contain information
about the user's visit to a website
To analyze data to help organizations with decision-making
To apply the resources of many computers in a network to a single
problem
7. What is the SQL command used to insert a new row into an existing database
table?
INSERT INTO
,6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
ADD RECORD
NEW ENTRY
INSERT ROW
8. How do you delete a column in SQL
ALTER TABLE tablename DROP COLUMN columnname;
ALTER TABLE tablename REMOVE COLUMN columnname;
ALTER TABLE tablename DELETE COLUMN columnname;
ALTER TABLE tablename ELIMINATE COLUMN columnname;
9. Which SQL command is used to take back privileges from a user?
REVOKE
DISALLOW
DENY
RESTRICT
10. What is a true statement about permissions in a database which uses SQL
(Structured Query Language)?
Only the owner of a database object can grant permission over that
object to other users.
The owner of a database object has complete control over that
object.
The account that creates a database object is the permanent owner
of that object.
An account with permission to access records in a table can access
all columns in the table.
, 6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
11. Which SQL function is used to find the lowest value in a numeric column?
LOWEST
MINIMUM
MIN
SMALLEST
12. What is the SQL command used to establish a new database within a
database management system?
CREATE DATABASE
INIT DATABASE
BUILD DATABASE
SETUP DATABASE
13. What is the purpose of an index?
Increasing the speed and accuracy of queries and update operations.
Increasing the speed of update operations.
Increasing the speed of queries and update operations.
Increasing the speed and accuracy of queries.
Increasing the speed of queries.
14. Which category of SQL statements control access/permission to the data?
Correct answer
results
WGU D426 Database OA Taken by: Wiseman
Score 129/ 129
Practice Test 2025
1. Database administrators must make sure that ________ measures are in place and
enforced so that only authorized users can take authorized actions at
appropriate times.
Correct answer
security
2. What scenario is likely to trigger an error code and message in MySQL
Server?
a) When a user attempts to connect to a database with invalid
credentials
b) When a valid SQL statement is executed successfully
c) When the database is accessed from a compatible operating
system
d) When a backup is restored without any issues
3. What is the SQL function that retrieves the highest value from a specified
column in a database table?
MAX()
MIN()
HIGHEST()
TOP()
,6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
4. What does the acronym SQL represent in the context of database
management?
Structured Query Language
Standard Query Language
Simple Query Language
Sequential Query Language
5. You can use the ___________ statement to rename an existing table.
Correct answer
RENAME TABLE
6. Which of the following is the primary purpose of using a database?
To keep track of data
To create text files on the user's computer that contain information
about the user's visit to a website
To analyze data to help organizations with decision-making
To apply the resources of many computers in a network to a single
problem
7. What is the SQL command used to insert a new row into an existing database
table?
INSERT INTO
,6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
ADD RECORD
NEW ENTRY
INSERT ROW
8. How do you delete a column in SQL
ALTER TABLE tablename DROP COLUMN columnname;
ALTER TABLE tablename REMOVE COLUMN columnname;
ALTER TABLE tablename DELETE COLUMN columnname;
ALTER TABLE tablename ELIMINATE COLUMN columnname;
9. Which SQL command is used to take back privileges from a user?
REVOKE
DISALLOW
DENY
RESTRICT
10. What is a true statement about permissions in a database which uses SQL
(Structured Query Language)?
Only the owner of a database object can grant permission over that
object to other users.
The owner of a database object has complete control over that
object.
The account that creates a database object is the permanent owner
of that object.
An account with permission to access records in a table can access
all columns in the table.
, 6/13/25, 1:19 PM WGU D426 Database OA Practice Test -
results
11. Which SQL function is used to find the lowest value in a numeric column?
LOWEST
MINIMUM
MIN
SMALLEST
12. What is the SQL command used to establish a new database within a
database management system?
CREATE DATABASE
INIT DATABASE
BUILD DATABASE
SETUP DATABASE
13. What is the purpose of an index?
Increasing the speed and accuracy of queries and update operations.
Increasing the speed of update operations.
Increasing the speed of queries and update operations.
Increasing the speed and accuracy of queries.
Increasing the speed of queries.
14. Which category of SQL statements control access/permission to the data?
Correct answer
