2 packs: 15% off with code BUY2. 3 or more: 20% off with code BUY3.

Oracle 1Z0-908 Exam Practice Questions, practice question pack
ORACLE · 1Z0-908

Oracle 1Z0-908 Exam Practice Questions

99% pass rateUpdated 1 Nov 2026228 questions2 PDFs, instant download

US$39

Every question with the correct answer and why the other options are wrong.

Download the free sample

Card, Apple Pay, Google Pay or PayPal. Download links are on your order page and in your email the moment you pay.

99% pass rate. Pass or your money back.Fail the exam after using this pack and we refund it, or swap it for any other pack. How the guarantee works
Category:
TRY BEFORE YOU BUY

Three of the 228 questions in this pack

Question 1

Which three are characteristics of a newly created role? (Choose three.)

  1. It can be dropped using the DROP ROLE statement.
  2. It is stored in the mysql.role table.
  3. It is created as a locked account.
  4. It can be renamed using the RENAME ROLE statement.
  5. It can be granted to user accounts.
  6. It can be protected with a password.
Show answer and explanation

Correct answer: A, C, E. It can be dropped using the DROP ROLE statement; It is created as a locked account; It can be granted to user accounts.

A newly created role can be dropped with DROP ROLE, is created as a locked account by default (so no one can log in as the role, although it can still be granted and activated), and can be granted to user accounts to assign permissions. Roles are stored in the mysql.user table (not a separate mysql.role table), cannot be renamed with a RENAME ROLE statement (no such statement exists in MySQL), and are created with no password, because CREATE ROLE has no clause for setting one.

Why the other options are wrong

  • B. Roles are stored in the mysql.user table, not in a mysql.role table.
  • D. MySQL does not support a RENAME ROLE statement for renaming roles.
  • F. A newly created role has no password; CREATE ROLE provides no way to set one.

Question 2

Which statement is true about InnoDB persistent index statistics?

  1. Updating index statistics is an I/O expensive operation.
  2. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
  3. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
  4. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
  5. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
  6. Tables are scanned and index statistics recalculated when an instance is restarted.
Show answer and explanation

Correct answer: A. Updating index statistics is an I/O expensive operation.

Updating index statistics is an I/O expensive operation because it requires scanning table pages to gather statistical information about index distribution. The other options contain inaccuracies: statistics are calculated from actual table data (not just buffer pool pages), innodb_stats_auto_recalc affects existing tables during modifications (not new index creation), increasing sample pages improves precision but increases I/O cost (not just memory), and statistics are recalculated on demand with ANALYZE TABLE or automatically after enough rows change, not on restart.

Why the other options are wrong

  • B. Statistics are calculated from the actual table data, not limited to pages currently in the buffer pool.
  • C. innodb_stats_auto_recalc causes automatic updates when data changes significantly, not specifically when new indexes are created.
  • D. innodb_stats_persistent_sample_pages applies only to persistent statistics; transient statistics use innodb_stats_transient_sample_pages, so raising it does not change plans based on transient statistics.
  • E. Increasing sample pages increases I/O and memory usage together, and doesn't determine scanning speed.
  • F. Statistics are recalculated based on configuration settings and data changes, not automatically on instance restart.

Question 3

Which two are features of MySQL Enterprise Firewall? (Choose two.)

  1. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
  2. blocking of potential threats by configuring pre-approved whitelists
  3. modifying SQL statement dynamically with substitutions
  4. automatic locking of user accounts who break your firewall
  5. provides stateless firewall access to TCP/3306
Show answer and explanation

Correct answer: A, B. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands; blocking of potential threats by configuring pre-approved whitelists

The MySQL Enterprise Firewall records incoming SQL statements to build a whitelist of permitted commands, and blocks potential threats by enforcing pre-approved whitelists of allowed SQL patterns. The firewall does not dynamically modify SQL statements, does not automatically lock user accounts (it blocks statements), and operates at the application level rather than providing stateless TCP firewall functionality.

Why the other options are wrong

  • C. The firewall blocks threats but does not modify SQL statements with dynamic substitutions.
  • D. The firewall blocks SQL statements; it does not automatically lock user accounts.
  • E. MySQL Enterprise Firewall operates at the SQL statement level, not as a stateless network firewall at the TCP layer.

See all 57 free questions Get the full pack, US$39

How much of the Oracle 1Z0-908 bank is free?

228 questions in the bank

Each step includes the one before, so buying only adds new questions.

  • You are here10questionsFree sampleThree on this page, all ten as a PDF.Download the sample
  • 5725% of the bankPractice pageFree on the site, every answer explained.Go to the practice page
  • 109the first half of the packHalf PackFree by email, as one PDF, every answer explained.Get the Half Pack
  • 228100%, the whole bankFull pack, US$39Plus the questions-only PDF, monthly updates, refund if you fail.Get the full pack
ABOUT THIS PACK

What’s in the Oracle 1Z0-908 pack

  • 228 questions mapped to the 1Z0-908 exam topics
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Instant delivery by email the moment you check out
  • Free monthly updates for as long as the exam is live
  • Pass or your money back

A failed 1Z0-908 attempt means paying the exam fee again. This pack is US$39, paid once.

What makes the 1Z0-908 hard

1Z0-908 is the only MySQL administration certification Oracle offers, and it has stayed on the 8.0 exam code while MySQL itself moved on to the 8.4 LTS and 9.x innovation releases, so the questions are about the features that have been stable since 8.0: the data dictionary, roles, the InnoDB architecture and the tooling around it. It is a single exam for the OCP credential with no associate-level prerequisite, and it is written for people who run MySQL rather than people who query it; the SQL questions are administrative.

The exam topics follow the DBA job. Architecture covers the server components, the data dictionary, storage engines and InnoDB internals, tablespaces, redo and undo, the buffer pool and the query cache's removal. Installation and configuration covers installing on Linux and Windows, MySQL Shell and the option files, upgrading and the variables that matter. Security covers user accounts, authentication plugins, roles, privileges and the principle of least privilege, password policies, TLS, auditing and encryption at rest with the keyring. Monitoring covers the Performance Schema, sys schema, slow query log, EXPLAIN and error and general logs. Backup and recovery covers logical backups with mysqldump and MySQL Shell dump utilities, physical backups with MySQL Enterprise Backup, binary logs and point-in-time recovery. High availability covers replication with GTIDs and multi-threaded appliers, Group Replication and InnoDB Cluster. Query optimization covers how MySQL optimizes queries and which indexes improve server performance.

About the exam

1Z0-908 (MySQL 8.0 Database Administrator) earns the Oracle Certified Professional, MySQL 8.0 Database Administrator credential. It covers MySQL architecture, installation and configuration, security, monitoring, query optimization, backup and recovery, and high availability with replication, Group Replication and InnoDB Cluster. No prerequisites. Oracle retires this exam on 16 November 2026.

Questions before you buy

How quickly do I receive it?

Straight away. The full PDF and a questions-only copy are emailed to you the moment your payment goes through, and the same links are on your order page.

Are updates included?

Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.

What if I fail the exam?

We refund the pack, or swap it for any other pack if you would rather keep studying. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.

What is your pass rate?

99% of customers who prepare with a CertStash pack pass. If you do not, we refund the pack, or swap it for another pack.

Can I share it with colleagues?

Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.

Related products