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: Apr 01, 2026

Add To Cart

Question 1

You want to shutdown a running Mysql Server cleanly.

Which three commands that are valid on either Windows or Linux will achieve this?

A : Shell> pkill –u mysql mysqld_safe

B : Shell> service mysql safe_exit

C : Shell> /etc/init.d/mysql stop

D : Shell> mysqladmin –u root –p shutdown

E : Mysql> STOP PROCESS mysqld;

F : Shell> net stop mysql

G : Shell> nmc mysql shutdown

Answer: A,C,D

Question 2

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 3

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

Question 4

You are using the Performance Schema to investigate replication on a slave which has a single master.

The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output? (Choose two.)

A : The salve has two intermediate relay slaves connected to it.

B : The slave is configured with slave_parallel_workers= 4.

C : At most, two schemas are being updates concurrently.

D : THREAD_ID 21 has stopped running.

E : The slave cannot process the relay log fast enough to use all threads.

F : The server needs more cores to use all slave threads.

Answer: A,B

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Apr 01, 2026

Add To Cart