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: Feb 19, 2025

Add To Cart

Question 1

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

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

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

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

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

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

Answer: C,D

Question 2

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 : qld uses internal configuration versioning and reverts to the previous configuration.

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

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

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

Answer: D

Question 3

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

A : ansaction support

B : LLTEXT indexing for text matching

C : ble and page level locking support

D : reign key support

E : ospatial indexing

F : H index support

G : ble level locking only

Answer: A,B

Question 4

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

A : ell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : ell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : ell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : ell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Question 5

Examine this command and output:

Which statement is true?

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

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

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

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

Answer: C

Page: 1 / 79

Total 392 Questions | Updated On: Feb 19, 2025

Add To Cart