MySQL 5.7 Database Administrator Practice Tests and PDFs

Examine the mydata table and SELECT statements: You issue: mysql> begin; mysql> update mydata set a=0 where b=3; How many rows are now protected by locks with the default InnoDB configuration?

Consider: Which statement best describes the meaning of the value for the key_len column?

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time? E. mysqlslow

A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup The operation completed without error. What is the state of this backup and operation required before it is ready to be restored? E. Backup State = Raw BackupOperation = backupdir-to-image