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

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 2

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Question 3

Which three methods will show the storage engine for the Country table? (Choose three.)

A : SHOW CREATE TABLE Country;

B : SHOW ENGINE Country STATUS;

C : SHOW TABLE STATUS LIKE ‘Country’;

D : SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’;

E : SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= ‘Country’;

Answer: A,C,D

Question 4

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 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Apr 01, 2026

Add To Cart