Question No. 1

Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

AThere are three indexes on the table.

BThere is a redundant index on the dept_no column.

CThe secondary indexes are optimized for unique key look-ups.

DThe values on the emp_no column must be unique.

EThe selectivity of the dept_no column is the best of the indexed columns.

FThere is a redundant index on the emp_no column.

Show Answer

Correct Answer: C, F

Question No. 2

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

UPDATE sales.january SET amount=amount+1000;

An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

Which statement is true? (Choose two.)

AYou would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

BThe changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

CThe statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.

DNothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

ENothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Show Answer

Correct Answer: D, E

Question No. 3

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

Which 2 things should you investigate?

ACheck the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

BCheck the difference between the InnoDB status values ''Log Sequence number'' and ''Last Checkpoint'' positions then compare that to the total size of the redo log.

CCheck the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

DCheck the difference between the InooDB status values ''Trx id counter'' and ''Purge done for'' and compare to the state substatus of the main ''Main thread''

ECheck the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Show Answer

Correct Answer: B, E

Question No. 4

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

AIt relies on the shared disk architecture being visible to both servers.

BIt is provided by means of IP-level disk replication.

CIt implements High Availability by using the .NET Connector's load balancing capabilities.

DIt is a shared-nothing architecture.

Show Answer

Correct Answer: A

Question No. 5

Which two methods will provide the total number of partitions on a table? (Choose two.)

AQuery the INFORMATION_SCHEMA.PARTITIONS table

BUse the command: SHOW TABLE STATUS

CQuery the performance_schema.objects_summary_global_by_type table

DQuery the INFORMATION_SCHEMA.TABLES table for the partition_count

EUse the command: SHOW CREATE TABLE
References:

Show Answer

Correct Answer: A, B

Free Oracle 1Z0-888 Exam Actual Questions

The questions for 1Z0-888 were last updated On Nov 19, 2024