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: Apr 28, 2026

Add To Cart

Question 1

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

Question 2

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

A : They take roughly twice as long as logical backups.

B : They allow direct copying of table rows with operating system copy commands.

C : They work best for transaction storage engines that can perform their own recovery when restored.

D : The backup window is almost zero from the perspective of the application.

E : They do not back up views, stored procedures, or configuration files.

F : There is a slight performance cost while the snapshot is active.

G : They do not use additional disk space.

Answer: A,C

Question 3

Examine this command and output:

Which statement is true?

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Question 4

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 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: Apr 28, 2026

Add To Cart