Online Access Free 1z1-883 Exam Questions

Which two statements describe the behavior of the server's SQL mode?

• A.The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.
• B.The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command.
• C.The server's SQL mode, when globally set on a slave server, applies to events sent from the master.
• D.The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

Which statement is true about the log-output variable?

• A.It enables and starts the General Query Log.
• B.It sets the target location for the binary logs generated by the MySQL sever.
• C.It specifies output destinations for the slow and General Query logs.
• D.It is a static variable and can be set only at MySQL server startup.

Identify a performance impact when using the Performance Schema.

• A.There is no impact on performance.
• B.The overhead depends on the settings of the Performance Schema.
• C.There is an overhead for querying the Performance Schema but not for having it enabled.
• D.There is a constant overhead regardless of settings and workload.

User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?

• A.ALTER TABLE pets...
• B.SELECT....FROM pets
• C.INSERT INTO pets...
• D.UPDATE pets...

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

• A.Mysqlshow
• B.Mysqldump
• C.Mysqlaccess
• D.Mysqldumpslow
• E.Mysqlslow