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

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 2

Which three methods will show the storage engine for the Country table? (Choose three.)

A : SHOW CREATE TABLE Country;

B : SHOW ENGINE Country STATUS;

C : SHOW TABLE STATUS LIKE ‘Country’;

D : SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’;

E : SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= ‘Country’;

Answer: A,C,D

Question 3

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:

mysql> CREATE TABLE datatarget SELECT * FROM datasource;

ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

Why is this statment forbiden?

A : GTIDs have detected thar a slave is inconsistent and therefore, disallow upadtes until the problem is resolved.

B : The datasource table is using an older InnoDB tablespace format, which is not compatible with GTIDs.

C : The datasource table is using the MyISAM engine, which is not compatible with GTIDs.

D : The statement cannot be logged in a transactionally safe manner.

Answer: D

Question 4

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

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Nov 10, 2025

Add To Cart