UUS Practice Tests⌕ Search
IT Certifications · 1Z0-918

Oracle MySQL Database Administration Professional Exam Practice Test

This practice page covers MySQL database administration, including server configuration, account access, connection behavior, and schema metadata. The available questions sample operational decisions such as selecting a configuration file, setting defaults for new databases, managing privileges, and inspecting database objects.

Exam overview

Exam providerOracle
Exam code1Z0-918
CategoryIT Certifications

About the Oracle MySQL Database Administration Professional Exam

Administrative work in these areas involves understanding how MySQL identifies accounts by user and host, and how privileges can be changed without deleting an account. Server settings affect connection limits, idle-session timeouts, startup configuration, and defaults such as the character set for newly created databases. Schema metadata supports inspection of triggers, stored routines, and scheduled events; the Event Scheduler handles recurring SQL tasks. Query-plan inspection helps administrators and developers examine how MySQL intends to execute a SELECT statement. These concepts connect configuration and access control with routine maintenance and performance investigation. The practice bank uses short scenarios to test recognition of relevant MySQL settings, statements, and built-in facilities.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

A MySQL account should be allowed to connect only from the host named batch01. In an account name, what does the host component specify?

  1. AThe database the account may select
  2. BThe client host or host pattern from which the account may connect
  3. CThe server's listening interface
  4. DThe authentication plugin used by the account
Show answerCorrect answer: B

MySQL accounts are identified by a user name and a host component. The host component limits which client hosts or host patterns can match that account; it does not specify a database or network listening interface.

Question 2

An administrator needs to inspect the definitions of triggers, routines, and events associated with a MySQL schema. Which built-in schema is the most appropriate starting point for querying this metadata?

  1. Aperformance_schema
  2. Binformation_schema
  3. Cmysql
  4. Dsys
Show answerCorrect answer: B

INFORMATION_SCHEMA provides metadata about database objects, including routines, triggers, and events. PERFORMANCE_SCHEMA focuses on runtime instrumentation, while the mysql schema stores server-managed account and privilege data.

Question 3

Which MySQL system variable controls how long the server waits for an inactive noninteractive connection before closing it?

  1. Await_timeout
  2. Bconnect_timeout
  3. Clock_wait_timeout
  4. Dnet_read_timeout
Show answerCorrect answer: A

wait_timeout sets the inactivity period before the server closes a noninteractive connection. connect_timeout concerns establishing a connection, while the other timeout variables apply to different waits or network operations.

Question 4

Which command-line option for the MySQL server daemon specifies an alternate configuration file to read at startup?

  1. A--defaults-file
  2. B--socket
  3. C--user
  4. D--datadir
Show answerCorrect answer: A

The --defaults-file option directs the server to read options from a specified option file. Options such as --socket and --datadir configure particular server resources rather than selecting the configuration file itself.

Question 5

What is the purpose of the MySQL system variable max_connections?

  1. AIt limits the number of databases on the server
  2. BIt sets the maximum number of simultaneous client connections
  3. CIt controls how many rows a query can return
  4. DIt sets the maximum number of tables in a transaction
Show answerCorrect answer: B

max_connections sets the maximum number of concurrent client connections the server permits. Connections beyond that limit are rejected until capacity becomes available.

Question 6

Which MySQL statement can be used to remove a user's access privileges while leaving the account itself in place?

  1. AREVOKE
  2. BDROP USER
  3. CDELETE PRIVILEGES
  4. DREMOVE ACCOUNT
Show answerCorrect answer: A

REVOKE removes specified privileges from an account without deleting the account. DROP USER, by contrast, removes the account itself.

Question 7

A MySQL server is configured to use a specific character set for newly created databases when no character set is specified. Which server setting controls this default?

  1. Acharacter_set_server
  2. Bcollation_connection
  3. Csql_mode
  4. Dtime_zone
Show answerCorrect answer: A

The character_set_server system variable sets the server-level default character set, which is used for new databases when their character set is not explicitly specified. A database can still override that default.

How to use this practice test

Access is free. Each practice session presents up to 20 random questions from the 50-question bank, with results shown after the session. Use the questions to check whether you can match administrative scenarios to MySQL commands, system variables, configuration sections, and metadata sources; revisit missed concepts before another session.

Preparation tips

  • Distinguish account identity from privileges: review how MySQL account host components constrain connection sources and how privilege revocation differs from account removal.
  • Practice locating server settings by purpose, including connection limits, noninteractive idle timeouts, and default character sets for newly created databases.
  • Review startup configuration syntax, especially the [mysqld] option group and the server option used to select an alternate configuration file.
  • Use the INFORMATION_SCHEMA metadata model to identify where schema-object definitions are exposed, and review how the Event Scheduler runs recurring SQL statements.
  • Compare EXPLAIN output with query execution: identify what an execution plan reveals without treating EXPLAIN as a normal run of the SELECT.
Official sourceOfficial exam page ↗