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

Oracle MySQL 8.0 Database Administrator Exam Practice Test

The Oracle MySQL 8.0 Database Administrator Exam practice page addresses administration and operation of MySQL databases. Its question bank samples SQL schema objects, constraints, server variables, connection limits, storage-engine behavior, logical backups, binary logging, and JSON columns. These subjects connect routine database configuration with data integrity, recovery planning, and the interpretation of MySQL commands.

Exam overview

Exam providerOracle
Exam code1Z0-908
CategoryIT Certifications

About the Oracle MySQL 8.0 Database Administrator Exam

Database administration requires understanding how MySQL stores and exposes data, and how server settings affect workloads. Practice topics include creating databases, using views to present query results, enforcing uniqueness with constraints, and configuring integer identifiers with AUTO_INCREMENT. Questions also touch on inspecting system-variable values and interpreting max_connections as a limit on concurrent client connections. InnoDB concepts include transaction support, foreign keys, and the consistency properties relevant to logical dumps made with mysqldump --single-transaction. Binary logs matter when coordinating backups with point-in-time recovery, while the JSON type supports structured document values in a column. Work through each scenario by identifying the relevant SQL statement or server feature, then consider its operational effect on integrity, availability, or recoverability.

Sample Practice Questions

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

Question 1

What is the purpose of a MySQL view?

  1. ATo present a stored query as a virtual table
  2. BTo store a second physical copy of every row in its underlying tables
  3. CTo allocate a separate transaction log for selected rows
  4. DTo automatically encrypt all columns in its underlying tables
Show answerCorrect answer: A

A view is a named query that can be used like a table in many SQL contexts. A view generally presents data from its underlying objects rather than storing a separate copy of their rows.

Question 2

A column stores values that must be unique across rows but is not intended to identify the table's primary key. Which constraint directly enforces this requirement?

  1. AUNIQUE
  2. BCHECK
  3. CDEFAULT
  4. DCOMMENT
Show answerCorrect answer: A

A UNIQUE constraint prevents duplicate values in the constrained column or column set. A table can have unique constraints in addition to its primary key.

Question 3

A MySQL server has `max_connections` set to 200. What does this setting limit?

  1. AThe maximum number of databases on the server
  2. BThe maximum number of simultaneous client connections the server permits
  3. CThe maximum number of connections a single account may create in a day
  4. DThe maximum number of queries that may run during one connection
Show answerCorrect answer: B

`max_connections` controls the maximum number of simultaneous client connections. Per-account connection limits are configured separately, and the variable does not limit databases or queries per connection.

Question 4

What is the effect of setting the `AUTO_INCREMENT` attribute on an integer column?

  1. AMySQL generates a new value when a row is inserted without an explicit value for that column
  2. BMySQL increments the column value whenever any column in the row is updated
  3. CMySQL assigns the same value to all rows inserted in one statement
  4. DMySQL prevents applications from inserting an explicit value
Show answerCorrect answer: A

An `AUTO_INCREMENT` column can receive a generated sequence value when an insert omits the value or supplies a value that triggers generation. The attribute does not make values change on updates or prohibit all explicit values.

Question 5

Which MySQL command displays the server's current system-variable values?

  1. A`SHOW VARIABLES;`
  2. B`SHOW COLUMNS;`
  3. C`DESCRIBE VARIABLES;`
  4. D`LIST SETTINGS;`
Show answerCorrect answer: A

`SHOW VARIABLES` displays system variables and their current values. `SHOW COLUMNS` and `DESCRIBE` describe table columns, while `LIST SETTINGS` is not a MySQL statement.

Question 6

What does the `mysqldump --single-transaction` option do for an InnoDB-only logical dump?

  1. AStarts a consistent transaction for the dump without locking the tables for the duration
  2. BCopies only table definitions and omits table data
  3. CStops the server before exporting any rows
  4. DConverts every table to the MyISAM storage engine
Show answerCorrect answer: A

For transactional tables such as InnoDB, --single-transaction uses a transaction-consistent snapshot so the dump can proceed without holding table locks for its duration. Concurrent schema changes can still affect dump reliability.

Question 7

Which statement creates a database named `inventory` only if it does not already exist?

  1. ACREATE DATABASE inventory;
  2. BCREATE DATABASE IF NOT EXISTS inventory;
  3. CCREATE SCHEMA inventory REPLACE;
  4. DALTER DATABASE inventory CREATE;
Show answerCorrect answer: B

`IF NOT EXISTS` lets `CREATE DATABASE` complete without an error when a database of that name already exists.

How to use this practice test

Access is free. When questions are available, a practice session presents up to 20 random questions from the 50-question bank and shows results after the session. Use the result review to identify which MySQL behaviors need closer attention, such as backup consistency, server variables, constraints, or storage-engine capabilities.

Preparation tips

  • Compare UNIQUE constraints with primary keys, and practice choosing the constraint that enforces distinct values without defining row identity.
  • Use MySQL commands to inspect system variables, then distinguish configured connection limits from the number of active sessions.
  • Review InnoDB transactions and foreign keys, and understand how --single-transaction affects logical dumps of InnoDB tables.
  • Trace a recovery plan from a backup through binary-log events to point-in-time restoration; distinguish this from restoring a logical dump alone.
  • Practice writing CREATE DATABASE IF NOT EXISTS statements and predicting the behavior of AUTO_INCREMENT and JSON columns.
Official sourceOfficial exam page ↗