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

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

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

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

Question 4

You want to shutdown a running Mysql Server cleanly.

Which three commands that are valid on either Windows or Linux will achieve this?

A : Shell> pkill –u mysql mysqld_safe

B : Shell> service mysql safe_exit

C : Shell> /etc/init.d/mysql stop

D : Shell> mysqladmin –u root –p shutdown

E : Mysql> STOP PROCESS mysqld;

F : Shell> net stop mysql

G : Shell> nmc mysql shutdown

Answer: A,C,D

Question 5

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.

Which two conditions must be true? (Choose two.)

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C : The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Page: 1 / 79

Total 392 Questions | Updated On: Jan 15, 2026

Add To Cart