100% Free Oracle 1Z0-908 Practice Test Questions and Answers 2026

Start Learning with the Latest and Real 100% Free Oracle 1Z0-908 Exam Questions

Page: 1 / 79

Total 392 Questions | Updated On: May 21, 2026

Add To Cart

Question 1

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

Question 2

You are using the Performance Schema to investigate replication on a slave which has a single master.

The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output? (Choose two.)

A : The salve has two intermediate relay slaves connected to it.

B : The slave is configured with slave_parallel_workers= 4.

C : At most, two schemas are being updates concurrently.

D : THREAD_ID 21 has stopped running.

E : The slave cannot process the relay log fast enough to use all threads.

F : The server needs more cores to use all slave threads.

Answer: A,B

Question 3

You execute this command:

shell> mysqlpump --exclude-databases=% --users

Which statement is true?

A : It creates a logical backup of all MySQL user accounts.

B : It creates a logical backup of all metadata, but contains no table data.

C : It returns an error because the mysqldump command should have been used.

D : It creates a logical backup of only the users database.

Answer: B

Question 4

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A : The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: May 21, 2026

Add To Cart