oracle 1Z0-908 Exam Questions

Questions for the 1Z0-908 were updated on : Dec 26 ,2025

Page 1 out of 10. Viewing questions 1-15 out of 140

Question 1

Which statement is true about InnoDB persistent index statistics?

  • A. Updating index statistics is an I/O expensive operation.
  • B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
  • C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
  • D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
  • E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2

Which three sets of item information are visible in the mysql system database? (Choose three.)

  • A. help topics
  • B. performance monitoring information
  • C. plugins
  • D. information about table structures
  • E. audit log events
  • F. rollback segments
  • G. time zone information and definitions
Answer:

A, C, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%

Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000

Question 3

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

  • A. ALTER TABLE employees - ADD INDEX (birth_date DESC);
  • B. ALTER TABLE employees - ADD INDEX ((MONTH(birth_date)));
  • C. ALTER TABLE employees - ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);
  • D. ALTER TABLE employees - ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);
  • E. ALTER TABLE employees - ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));
  • F. ALTER TABLE employees - ADD INDEX (birth_date);
Answer:

A, D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 4

You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting
data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)

  • A. ibdatal:12M;ibdata2:12M;ibdata3:12M
  • B. ibdatal:12M:autoextend;ibdata2:12M:autoextend
  • C. ibdatal:12M:autoextend
  • D. ibdatal:12M;ibdata2:12M:autoextend
  • E. ibdatal:12M
  • F. ibdatal:12M;/tmp/ibdata2:12M:autoextend
Answer:

A, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 5

You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

  • A. Remove ib_logfile0 and ib_logfile1 files from the file system.
  • B. Execute mysqladmin flush-logs.
  • C. First run mysqld --initialize to refresh the Size of ib_logfile.
  • D. Create a new ib_logfile0 file of size 26214400.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?

  • A. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')
  • B. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')
  • C. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;
  • D. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()
  • E. It has been expelled from the cluster because of a transaction error.
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7

You have a MySQL client installed on your Linux workstation with a default installation. You have your
admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

  • A. --shared-memory-base-name=world
  • B. --protocol=UDP
  • C. --protocol=pipe
  • D. --password
  • E. --user=admin
  • F. --host=192.0.2.1
  • G. --socket=/tmp/mysql.sock
  • H. --port=3306
  • I. --database=world
Answer:

A, C, D, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
H
50%
I
50%

Discussions
vote your answer:
A
B
C
D
E
F
G
H
I
0 / 1000

Question 8

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

  • A. [mysqld] default_authentication_plugin=sha256_password
  • B. ALTER USER user - IDENTIFIED WITH mysql_native_password BY 'password';
  • C. [mysqld] default_authentication_plugin=caching_sha2_password
  • D. ALTER USER user - IDENTIFIED WITH caching_sha2_password BY 'password';
  • E. ALTER USER user - IDENTIFIED WITH sha256_password - BY 'password';
  • F. [mysqld] default_authentication_plugin=mysql_native_password
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 9

Which two are true about differences between logical and physical upgrades of MySQL databases?
(Choose two.)

  • A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
  • B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
  • C. Logical upgrades are much faster because they do not require restarting the mysqld process.
  • D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
  • E. Physical upgrades are much faster because they do not require restarting the mysqld process.
  • F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.
Answer:

C, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 10

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()
Which two statements are true? (Choose two.)

  • A. Group Replication will be dissolved and all metadata purged.
  • B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
  • C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
  • D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
  • E. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
  • F. Connections driven by MySQL Router are not affected by the command.
Answer:

C, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

  • A. Increase the number of buffer pool instances to 16.
  • B. Increase the number of buffer pool instances to 32.
  • C. Decrease the number of buffer pool instances to 1.
  • D. Increase the number of buffer pool instances to 12.
  • E. Decrease the number of buffer pool instances to 4.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 12

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5
seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

  • A. min_examined_row_limit=5000
  • B. long_query_time=5 log_throttle_queries_not_using_indexes=5
  • C. log_throttle_queries_not_using_indexes=5 min_examined_ row_limit=5000
  • D. long_query_time=5
  • E. long_query_time=5 min_examined_row_limit=5000
  • F. log_throttle_queries_not_using_indexes=5
  • G. long_query_time=5 log_throttle_queries_not_using_indexes=5 min_examined_row_limit=5000
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%

Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000

Question 13

Your MySQL environment has asynchronous position based-replication with one master and one
slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are
damaged.
You restart MySQL Server.
How can replication be restored?

  • A. The slave relay logs should be deleted; then execute START SLAVE;
  • B. The relay logs from the master should be used to replace the corrupted relay logs.
  • C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
  • D. The slave needs to be restored from backup.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

Which two statements are true about MySQL Installer? (Choose two.)

  • A. It installs most Oracle MySQL products.
  • B. It performs product upgrades.
  • C. It provides only GUI-driven, interactive installations.
  • D. Manual download of separate product packages is required before installing them through MySQL Installer.
  • E. It provides a uniform installation wizard across multiple platforms.
Answer:

B, C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 15

Which three are types of information stored in the MySQL data dictionary? (Choose three.)

  • A. performance metrics
  • B. InnoDB buffer pool LRU management data
  • C. access control lists
  • D. view definitions
  • E. server runtime configuration
  • F. server configuration rollback
  • G. stored procedure definitions
Answer:

A, D, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%

Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000
To page 2