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: Feb 19, 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

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 3

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 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

Why should you be selective when granting the PROCESS privilege to an account?

A : It allows a client to process scripts.

B : It allows the use of stored routines.

C : It allows a client to see another user-s queries with the SHOW PROCESSLIST command.

D : It allows a client to control running processes on a server.

Answer: C

Page: 1 / 79

Total 392 Questions | Updated On: Feb 19, 2026

Add To Cart