Oracle Oracle Database 1Z0-888 Questions & Answers

• Question 31:

  You have just created a replication slave from a backup of the master made with mysqldump:

  

  You try to log in to the slave with the application user, but fail as follows:

  

  The login works on the master.

  Which two changes to the process can fix the issue?

  A. After the restore, log in to the database and execute FLUSH PRIVILEGES.

  B. Use the –-flush-privileges with mysqldump.

  C. Add a second dump for the ‘mysql’ database; --all-databases does not include it.

  D. Use the –-grants option to include GRANT statements in the dump.

  Correct Answer: C

• Question 32:

  The account [email protected] has been created with privileges, as shown in the output:

  

  The account [email protected] exists.

  The account [email protected] does not exist.

  Which three statements will succeed when executed by [email protected]? (Choose three.)

  A. GRANT SELECT ON audit.* TO [email protected];

  B. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

  C. GRANT SELECT ON world.* TO [email protected];

  D. GRANT INSERT ON audit.* TO [email protected];

  E. GRANT DELETE ON world.* TO [email protected];

  F. GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

  G. GRANT SELECT ON world.* TO [email protected];

  Correct Answer: BDE

• Question 33:

  Which statement describes how the relay log works?

  A. when a slave receives a change from the master, it is processed first, and then recorded in the relay log.

  B. It maintains a record of available master binary logs and the current executed log position.

  C. It stores changes on the master, and relays them to the slave.

  D. When a slave receives a change from the master, it is recorded in the relay log first and processed later.

  Correct Answer: B

• Question 34:

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

  A. It allows a client to process scripts.

  B. It allows the use of stored routines.

  C. It allows a client to see another user's queries with the SHOW PROCESSLIST command.

  D. It allows a client to control running processes on a server.

  Correct Answer: D

  Reference: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html

• Question 35:

  You want to dump only data from the userdata table.

  Which mysqldump command argument is required to accomplish this?

  A. - -no-create-info to skip writing CREATE TABLE statements

  B. - -single-transaction as this obtains a consistent view of data only

  C. - -data-only as this specifies that only data is to be dumped

  D. - -table=userdata in order to dump only the data from the userdata table

  Correct Answer: B

• Question 36:

  An employee cannot access the company database. You check the connection variables:

  

  A look at the user privileges shows: What is a valid explanation for why one of the users is unable to connect to the database?

  

  A. Bob has max_user_connections set to zero, which blocks all his connections.

  B. All users are blocked because max_user_connections is accumulated over the host account information.

  C. connect_timeout is too small to allow a connection to occur.

  D. Joe has exceeded the max_user_connections global limit.

  E. Kay is already connected elsewhere and attempting to log in again.

  Correct Answer: D

• Question 37:

  You have created a backup of the `sales' database with the command:

  

  Which two procedures can be used to restore the `orders' table from the backup?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: BC

• Question 38:

  You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-dddeee:3 on a slave.

  Which procedure would you execute from a MySQL prompt?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 39:

  You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

  Which 2 things should you investigate?

  A. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

  B. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

  C. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

  D. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"

  E. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

  Correct Answer: BE

• Question 40:

  The MySQL user `adam' currently has USAGE permissions to the database.

  The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the ?single-transaction option.

  Which extra GRANT permissions are required for adam to take mysqldump backups?

  A. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

  B. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

  C. The `adam' user must have the SUPER privilege in order to take data backups.

  D. The `adam' user must also have SELECT on the football database for backup to work.

  Correct Answer: C