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 22, 2025

Add To Cart

Question 1

You have forgotten the root user account password. You decide to reset the password and execute:

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

Which additional argument makes this operation safer?

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

Question 2

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 3

User bob@% has the following roles granted: app_read and app_write.

How would you show the privileges for bob@% when it uses app_write? (Choose one).

A : SHOW GRANTS FOR bob@'%';

B : SHOW GRANTS FOR bob@'%' USING 'app_write';

Answer: B

Question 4

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 5

Which query would you use to find connections that are in the same state for longer than 100 seconds?

A : SHOW FULL PROCESSLIST WHEER Time > 100;

B : SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Page: 1 / 79

Total 392 Questions | Updated On: Nov 22, 2025

Add To Cart