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 have just created a replication slave from a backup of the master made with mysqldump:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.

Which two changes to the process can fix the issue?

A : After the restore, log in to the database and execute FLUSH PRIVILEGES.

B : Use the --flush-privileges with mysqldump.

C : Add a second dump for the 'mysql' database; --all-databases does not include it.

D : Use the --grants option to include GRANT statements in the dump.

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

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 4

When using MySQL Group Replication you can use the following storage engines:

A : InnoDB and MyISAM

B : InnoDB

C : MyISAM

D : All the engines included with MySQL

Answer: B

Question 5

Which three statements are true about memory buffer allocation by a MySQL Server? (Choose three.)

A : Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B : Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C : Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D : User buffers are allocated at server startup and freed when the user is dropped.

E : All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Mar 08, 2026

Add To Cart