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 26, 2025

Add To Cart

Question 1

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 2

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

Other-Image-30e9b1e03-8bbc-4275-a4c0-1ac8f11994b9

What statement is true about the start attempt?

A : MySQL server was not started due to a problem while executing process 2732.

B : MySQL server continued to start up even though another process existed.

C : systemd found the mysqld service disabled and failed to start it.

D : systemd waited for 30 seconds before timing out and start up failed.

E : systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: A

Question 3

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 4

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A : The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Nov 26, 2025

Add To Cart