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 24, 2026

Add To Cart

Question 1

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

Question 2

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

mysql> SHOW SLAVE STATUS\G

... Slave_IO_Running: YesSlave_SQL_Running: No

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A : to allow the remaining events to be processed on the slave while not receiving new events from the master

B : to allow a backup to be created under reduced load

C : to allow for point-in-time recovery on the slave

D : to prevent schema changes from propagating to the slave before they are validated

E : to prevent any transaction experiencing a deadlock

Answer: B,C

Question 3

User bob@% has the following roles granted: app_read and app_write.

How would you show the privileges for bob@% when it uses app_write? (Choose one).

A : SHOW GRANTS FOR bob@'%';

B : SHOW GRANTS FOR bob@'%' USING 'app_write';

Answer: B

Question 4

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

[ERROR] mysqld: unknown option ‘--ssl’

What is the cause of the error?

A : The -- ssl level was not specified.

B : The server was not started with the --enable–ssl-plugin option.

C : --ssl is not a valid server option.

D : The mysqld binary was not compiled with SSL support.

E : The server’s SSL certificate was invalid.

Answer: D

Question 5

Which statement is true about FLUSH LOGS command?

A : It requires the RELOAD, FILE, and DROP privileges.

B : It closes and reopens all log files.

C : It closes and sends binary log files to slave servers.

D : It flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

Page: 1 / 79

Total 392 Questions | Updated On: Mar 24, 2026

Add To Cart