Online Access Free 1z0-883 Practice Test

Which query would you use to find connections that are in the same state for longer than 180 seconds?

• A.SHOW FULL PROCESSLIST WHEER Time > 180;
• B.SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;
• C.SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
• D.SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );

In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?

• A.Syntax when writing queries involving JOINS
• B.Memory usage when working with the data
• C.Disk usage when storing data
• D.Character set mapping index hash size
• E.Comparing the encoded data with similar columns on other tables

Which three tasks can be performed by using the performance Schema?

• A.Finding the size of each table
• B.Finding the part of a code in which a single query is spending time
• C.Finding rows that are locked by InnoDB
• D.Finding queries that are not using indexes
• E.Finding client connection attributes

Which two statements are true about InnoDB auto-increment locking?

• A.InnoDB does not use locks to enforce auto-increment uniqueness.
• B.The auto-increment lock can be a table-level lock.
• C.InnoDB never uses table-level locks.
• D.Some settings for innodb_autoinc_lock_mode can help reduce locking.
• E.InnoDB always protects auto-increment updates with a table-level lock.

Which two events will cause a slave server to create a new relay log file?

• A.Starting of the SQL thread
• B.Starting of the I/O thread
• C.Execution of FULSH TABLES WITH READ LOCK
• D.Execution of the FLUSH LOGS statement
• E.Reaching the slave_pendign _jobs_size_max limit