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 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 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

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 4

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.

You then TRUNCATE this table to empty it.

mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table? (Choose two.)

A : mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B : $ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Nov 22, 2025

Add To Cart