Master the Oracle 1z0-888 Exam: Essential Study Tips and Strategies

Questions 31

Which two capabilities are granted with the SUPER privilege?

Options:

allowing change of the server runtime configuration

allowing a client to shut down the server

allowing client accounts to take over the account of another user

allowing a client to kill other client connections

Buy Now

Questions 32

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?

Options:

The ‘adam’ user must also have SINGLE TRANSACTION global grant to take a consistent backup.

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

The ‘adam’ user must have the SUPER privilege in order to take data backups.

The ‘adam’ user must also have SELECT on the football database for backup to work.

Buy Now

Questions 33

This output is from a SHOW SLAVE STATUS:

1z0-888 Question 33

What would cause the SQL_Delay variable to have a value of 360?

Options:

The master has performed a large transaction, which will take 360 seconds to complete on the slave.

The network latency between the master and the slave is 360 milliseconds.

The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

The slave was configured for delayed replication with a delay of six minutes.

Buy Now

Questions 34

You are investigating the performance of a query which selects data from an InnoDB table.

Consider this Performance Schema diagnostics output for the query:

1z0-888 Question 34

Which statement is true about the output?

Options:

The time the query took is the sum of all timer_wait values.

The query did not find its table in the table definition cache.

The query read data from the data file rather than directly from the buffer pool.

The event with event_id = 8945 is a child of the event with event_id=8944.

Buy Now

Questions 35

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

1z0-888 Question 35

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

1z0-888 Question 35

The login works on the master.

Which two changes to the process can fix the issue?

Options:

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

Use the –-flush-privileges with mysqldump.

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

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

Buy Now

Questions 36

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user’s shell setting.

Which statement is true?