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: Jan 04, 2026

Add To Cart

Question 1

On a master server that is using Statement-based replication a table of log data has become very large. You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A : Use the LIMIT clause to limit the deletion to 100,000 rows.

B : Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

C : Use the LIMIT clause in conjunction with the ORDER BY clause.

D : Use the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Answer: B,C

Question 2

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

mysql> SHOW SLAVE STATUS\G

... Slave_IO_Running: YesSlave_SQL_Running: No

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A : to allow the remaining events to be processed on the slave while not receiving new events from the master

B : to allow a backup to be created under reduced load

C : to allow for point-in-time recovery on the slave

D : to prevent schema changes from propagating to the slave before they are validated

E : to prevent any transaction experiencing a deadlock

Answer: B,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

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 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: Jan 04, 2026

Add To Cart