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 execute mysqladmin shutdown on a MySQL server that is decribed as follows:

- It is running with both active and idle client connections.

- It has open transactions against InnoDB.

- It has active multi-row inserts into MyISAM engine tables.

- Innodb_fast_shitdown is set to 1.

What are three effects of shutting down the server by using a mysqladmin shutdown command?

A : Connections that have an open transaction are rolled back.

B : Connections with statements running against MyISAM tables wait for completion.

C : New client connections are not accepted after shutdown is initiated.

D : Connections are accepted during the shutdown process because a graceful shutdown can take large amounts of time.

E : Partial updates may occur for non-transactional tables.

Answer: A,C

Question 2

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 3

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 4

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 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: Nov 22, 2025

Add To Cart