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

Add To Cart

Question 1

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 2

You have just created a replication slave from a backup of the master made with mysqldump:

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

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.

Which two changes to the process can fix the issue?

A : After the restore, log in to the database and execute FLUSH PRIVILEGES.

B : Use the --flush-privileges with mysqldump.

C : Add a second dump for the 'mysql' database; --all-databases does not include it.

D : Use the --grants option to include GRANT statements in the dump.

Answer: B

Question 3

Which two methods will provide the total number of partitions on a table? (Choose two.)

A : Query the INFORMATION_SCHEMA.PARTITIONS table

B : Use the command: SHOW TABLE STATUS

C : Query the performance_schema.objects_summary_global_by_type table

D : Query the INFORMATION_SCHEMA.TABLES table for the partition_count

E : Use the command: SHOW CREATE TABLE

Answer: A

Question 4

Which statement is true about FLUSH LOGS command?

A : It requires the RELOAD, FILE, and DROP privileges.

B : It closes and reopens all log files.

C : It closes and sends binary log files to slave servers.

D : It flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

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: Apr 15, 2026

Add To Cart