Oracle 1z1-908 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-908
Exam Name/Title: MySQL 8.0 Database Administrator
Certification Provider: Oracle
Corresponding Certification: MySQL Database Administration

Exam Questions: 142
Updated On: Aug 16, 2026

Question #1

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A. cluster.setPrimaryInstance()

B. dba.createCluster()

C. cluster.forceQuorumUsingPartitionOf()

D. dba.configureLocalInstance()

E. cluster.addInstance()

F. dba.configureInstance()

G. dba.checkInstanceConfiguration()

Discussion 0

Correct Answer: A,C Vote an answer

Question #2

A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

A. You use the MyISAM storage engine for most common tables.

B. The Innodb Buffer pool is full.

C. You use the InnoDB storage engine and statements wait while data is inserted.

D. Your table accesses wait for the operating system level flush.

Discussion 0

Correct Answer: C Vote an answer

Question #3

Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

A. Executing ALTER TABLE transactions will enable you to free up disk space.

B. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

C. Truncating the transactions table will free up the most disk space.

D. The transactions table was created with innodb_file_per_table=OFF.

E. Truncating the sales and leads table will free up disk space.

Discussion 0

Correct Answer: B,D Vote an answer

Question #4

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. user privileges

B. primary indexes

C. change buffer

D. InnoDB Data Dictionary

E. doublewrite buffer

F. table data

Discussion 0

Correct Answer: D,E Vote an answer

Question #5

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.

B. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

C. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

D. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

E. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

Discussion 0

Correct Answer: B,C Vote an answer

Question #6

Examine this statement, which executes successfully:

Now examine this query:

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

A. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

B. ALTER TABLE employees -
ADD INDEX (birth_date DESC);

C. ALTER TABLE employees -
ADD INDEX (birth_date);

D. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

E. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

F. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

Discussion 0

Correct Answer: B,E Vote an answer

Question #7

Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)

A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

B. InnoDB tablespaces outside the datadir are able to be cloned.

C. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

D. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

E. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

F. It is always slower than {recoveryMethod: 'incremental'}.

Discussion 0

Correct Answer: A,C,F Vote an answer

Question #8

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

A. ALTER TABLE t1 SET TDE = 'ON';

B. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

C. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

D. ALTER TABLE t1 ENCRYPTION='Y';

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1z1-908 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-908 exam.