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: Nov 10, 2025

Add To Cart

Question 1

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin

Which database updates are logged on the master server to the binary log by default?

A : all updates except to the TEMPDB database

B : all updates except to the PERFORMANCE_SCHEMA database

C : all updates not involving temporary tables

D : all updates to the default database, except temporary tables

E : all updates to all databases

Answer: A

Question 2

Which three are properties of the MyISAM storage engine? (Choose three.)

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B

Question 3

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 4

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 5

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

A : shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Page: 1 / 79

Total 392 Questions | Updated On: Nov 10, 2025

Add To Cart