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 are setting up a new server and you want to reserve 50GB of RAM for InnoDB use. What option would you set

A : innodb_ram_size=50GB

B : innodb_buffer_pool_size=50GB

C : innodb_buffer_pool=50G

Answer: B

Question 2

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

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

A : Set binlog_format=MIXED with the –replicate-ignore-temp-table option.

B : Use the –replicate-do-db, –replicate-do-table, or –replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C : Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D : Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E : Use the –replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Mar 08, 2026

Add To Cart