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

Add To Cart

Question 1

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

A : Set binlog_format=MIXED with the –replicate-ignore-temp-table option.

B : Use the –replicate-do-db, –replicate-do-table, or –replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C : Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D : Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E : Use the –replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer: A,C

Question 2

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 3

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 4

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 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Nov 10, 2025

Add To Cart