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: Dec 28, 2025

Add To Cart

Question 1

Examine this command and output:

Which statement is true?

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Question 2

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 3

When the backup is taken, there are no errors.

Why are triggers missing from the backup?

A : The FILE privilege is required to back up the TRG files stored in the database directory.

B : The PROCESS privilege will allow the user access to process items such as triggers and functions.

C : The ALL privilege is required to back up triggers because triggers have a wide variety of abilities.

D : The TRIGGER privilege Is required to create, execute, and show triggers in a database.

Answer: D

Question 4

Examine this statement, which executes successfully:

Other-Image-2d087695c-370a-4149-9dae-43fdb2993133

You want to improve the performance of this query:

Other-Image-4d087695c-370a-4149-9dae-43fdb2993133

Which change enables the query to succeed while accessing fewer rows?

A : ALTER TABLE world.city ADD SPATIAL INDEX (Name);

B : ALTER TABLE world.city ADD SPATIAL INDEX (Population);

C : ALTER TABLE world.city ADD INDEX (Population);

D : ALTER TABLE world.city ADD INDEX (Name);

E : ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F : ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Answer: B

Question 5

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

mysql> SHOW SLAVE STATUS\G

... Slave_IO_Running: YesSlave_SQL_Running: No

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A : to allow the remaining events to be processed on the slave while not receiving new events from the master

B : to allow a backup to be created under reduced load

C : to allow for point-in-time recovery on the slave

D : to prevent schema changes from propagating to the slave before they are validated

E : to prevent any transaction experiencing a deadlock

Answer: B,C

Page: 1 / 79

Total 392 Questions | Updated On: Dec 28, 2025

Add To Cart