Oracle 1Z0-888 Quiz 3 Topic 7 Questions 11-15

Question: 1

Examine the mysqldumpslow output:

q1_1Z0-888

Which two options could explain the slow query?

AThere is network congestion between client and server.

BNo index has been defined on the filtered column.

CThere are 108 queries still being executed.

DA table lock is causing delays.

EA full table scan is being used.

Show Answer

Question: 2

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

ASet isolation level to be SERIALIZABLE.

BUse the binary log row format.

CSet isolation level to be READ COMMITTED.

DConfigure IPv6 network for hosts.

EGuarantee a secondary index on every table.

FGuarantee a primary key on every table.

GSet multiple slave parallel worker threads.

Show Answer

Question: 3

You created a backup of the world database with this command:

shell> mysqldump --opt world > dump.sql

Which two will import the data from dump.sql?

Ashell> mysqladmin recover test dump.sql

Bshell> mysql test < dump.sql

Cshell> mysqlimport test dump.sql

Dmysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';

Emysql>USE test; mysql>SOURCE dump.sql;

Show Answer

Question: 4

Which two statements describe how InnoDB recovery works?

AInnoDB handles most crash recoveries automatically.

BInnoDB blocks some operations when innodb_force_recovery is set to greater than 0.

CThere will in general be lost committed transactions after a crash using the default settings.

DIt is required to enable binlog_gtid_simple_recovery to perform a crash recovery.

EIt is recommended to set innodb_force_recovery = 1 as part of normal operations.

FIt is always required to enable innodb_force_recovery to perform a crash recovery.

Show Answer

Question: 5

Consider the table people with the definition:

q5_1Z0-888

The application uses a query such as:

SELECT * FROM people WHERE YEAR(Birthday) = 1980;

The query is not using an index.

Which two methods can be used to allow the query to use an index?

AChange the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

BAdd a functional index for YEAR(Birthday).

CExecute ANALYZE TABLE to update the index statistics.

DAdd a generated column calculating YEAR(Birthday) and index that column.

EAdd FORCE INDEX (Birthday) to the query.

Show Answer

Oracle 1Z0-888 Quiz:3 Topic:7 Questions:11-15