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: Mar 22, 2026

Add To Cart

Question 1

Which three are properties of the MyISAM storage engine? (Choose three.)

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B

Question 2

Which query would you use to find connections that are in the same state for longer than 100 seconds?

A : SHOW FULL PROCESSLIST WHEER Time > 100;

B : SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Question 3

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 4

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

[ERROR] mysqld: unknown option ‘--ssl’

What is the cause of the error?

A : The -- ssl level was not specified.

B : The server was not started with the --enable–ssl-plugin option.

C : --ssl is not a valid server option.

D : The mysqld binary was not compiled with SSL support.

E : The server’s SSL certificate was invalid.

Answer: D

Question 5

Which three statements are true about memory buffer allocation by a MySQL Server? (Choose three.)

A : Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B : Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C : Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D : User buffers are allocated at server startup and freed when the user is dropped.

E : All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Mar 22, 2026

Add To Cart