Oracle 1Z0-888 Quiz 1 Topic 14 Questions 1-5

Question: 1

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.

You start to restore your backup with this command;

shell> mysql --u root --p < backup.sql

After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.

Which is the most likely explanation for this slowdown?

AThe MySQL server has stopped inserting data to check index consistency.

BInnoDB is doing CRC32 checks over the tablespace data as it grows.

CThe MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.

DInnoDB has filled the redo log and now must flush the pages.

ESecondary indexes no longer fit into the buffer pool.

Show Answer

Question: 2

91 'mike'@'client.example.com'. This user is currently not connected to the server.

Which two actions can you take to stop any access from the user?

AUse ALTER USER 'mike'@'client.example.com' PASSWORD EXPIRE;

BUse REVOKE ALL PRIVILEGES FROM 'mike'@'client.example.com';

CExecute the mysql_secure_installation command.

DUse DROP USER 'mike'@'client.example.com';

EUse GRANT USAGE ON *.* TO 'mike'@'client.example.com' MAX_USER_CONNECTIONS=0;

FUse ALTER USER 'mike'@'client.example.com' ACCOUNT LOCK;

Show Answer

Question: 3

While attempting to set up a new replication slave on host '192.168.0.25' with the user 'replication', you encounter this error:

q3_1Z0-888

What should you do to resolve this error?

AAdd the user replication@192.168.0.25 with the correct password to the master.

BEdit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

CEdit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

DAdd the user replication@192.168.0.25 with the correct password to the slave.

Show Answer

Question: 4

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?

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

BCheck 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.

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

DCheck 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''

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

Show Answer

Question: 5

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

q5_1Z0-888

A look at the user privileges shows:

q5_1Z0-888

What is a valid explanation for why one of the users is unable to connect to the database?

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

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

Cconnect_timeout is too small to allow a connection to occur.

DJoe has exceeded the max_user_connections global limit.

EKay is already connected elsewhere and attempting to log in again.

Show Answer

Oracle 1Z0-888 Quiz:1 Topic:14 Questions:1-5