Free Oracle 1Z0-908 Exam Questions

Become Oracle Certified with updated 1Z0-908 exam questions and correct answers

Page: 1 / 79

Total 392 Questions | Updated On: Mar 08, 2026

Add To Cart

Question 1

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Question 2

You execute this command:

shell> mysqlpump --exclude-databases=% --users

Which statement is true?

A : It creates a logical backup of all MySQL user accounts.

B : It creates a logical backup of all metadata, but contains no table data.

C : It returns an error because the mysqldump command should have been used.

D : It creates a logical backup of only the users database.

Answer: B

Question 3

You have an InnoDB Cluster configured with three servers.

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A : Stop all instances except the primary read/write master instance and run the restore.

B : Remove the @@GLOBAL.gtid_purged statement from the dump file.

C : Create the backup by using the --set-gtid-purged=OFF option.

D : Remove the group replication plugin from each instance before restoring.

E : Remove the @@GLOBAL.gtid_executed statement from the dump file.

F : Restore using the --set-gtid-purged=OFF option.

Answer: B,C

Question 4

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:

mysql> CREATE TABLE datatarget SELECT * FROM datasource;

ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

Why is this statment forbiden?

A : GTIDs have detected thar a slave is inconsistent and therefore, disallow upadtes until the problem is resolved.

B : The datasource table is using an older InnoDB tablespace format, which is not compatible with GTIDs.

C : The datasource table is using the MyISAM engine, which is not compatible with GTIDs.

D : The statement cannot be logged in a transactionally safe manner.

Answer: D

Question 5

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

Other-Image-30e9b1e03-8bbc-4275-a4c0-1ac8f11994b9

What statement is true about the start attempt?

A : MySQL server was not started due to a problem while executing process 2732.

B : MySQL server continued to start up even though another process existed.

C : systemd found the mysqld service disabled and failed to start it.

D : systemd waited for 30 seconds before timing out and start up failed.

E : systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: A

Page: 1 / 79

Total 392 Questions | Updated On: Mar 08, 2026

Add To Cart