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: Jan 15, 2026

Add To Cart

Question 1

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A : Users could overwrite configuration files.

B : Data files could be deleted.

C : SQL injections could be used to insert bad data into the database.

D : MySQL binaries could be damaged, deleted, or altered.

E : Extra startup time would be required for the MySQL server to reset the privileges.

Answer: A,B

Question 2

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 3

You have forgotten the root user account password. You decide to reset the password and execute:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

Which additional argument makes this operation safer?

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

Question 4

You have just created a replication slave from a backup of the master made with mysqldump:

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 5

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Page: 1 / 79

Total 392 Questions | Updated On: Jan 15, 2026

Add To Cart