Free Oracle 1Z1-888 Exam Dumps Questions & Answers

How does the InnoDB storage engine handle deadlocks when they are detected?

• A.  Both the affected transactions will be rolled back.
• B.  One of the affected transactions will be rolled back, the other is allowed to proceed.
• C.  The transaction isolation level determines which transaction is rolled back.
• D.  The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
• E.  The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

• A.  mysql_config_editor
• B.  mysqladmin
• C.  mysqld_safe
• D.  mysqlpasswd

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
- It must be possible to rebuild the instance using the backup.
- It must be verified.
- It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

• A.  Include the ibtmp1 file in the backup.
• B.  Include the MySQL socket file in the backup.
• C.  Include the operating system disk encryption key in the backup.
• D.  Include the MySQL PID file in the backup.
• E.  Include the keyring data and/or configuration in the backup.
• F.  Include the relay logs in the backup.
• G.  Include the binary logs in the backup.
• H.  Copy the backup to a remote host.
• I.  Restore the backup to a clean MySQL instance.

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

• A.  --single-transaction
• B.  --skip-buffer
• C.  --tab
• D.  --quick

Why should you be selective when granting the PROCESS privilege to an account?

• A.  It allows a client to see another user's queries with the SHOW PROCESSLIST command.
• B.  It allows a client to process scripts.
• C.  It allows the use of stored routines.
• D.  It allows a client to control running processes on a server.