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 20, 2026

Add To Cart

Question 1

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.

Which two conditions must be true? (Choose two.)

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C : The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 2

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 3

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

A : shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Question 4

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 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Apr 20, 2026

Add To Cart