Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
MySQL Database Administration
1z0-888
MySQL 5.7 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-888 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-888 Premium Access

View all detail and faqs for the 1z0-888 exam

Go to Exam

694 Students Passed

94% Average Score

90% Same Questions

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Questions # 31:

Examine the mysqldumpslow output:

Question # 31

Which two options could explain the slow query? (Choose two.)

Options:

There is network congestion between client and server.

No index has been defined on the filtered column.

There are 108 queries still being executed.

A table lock is causing delays.

A full table scan is being used.

Answer

A, E

Questions # 32:

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

Options:

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

Answer

A, E

Questions # 33:

The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.

You investigate and gather this information:

Question # 33

Three tables are stored in the InnoDB shared tablespace and the details are as follows:

The table data_current has 1,000,000 rows.

The table data_reports has 1,500,000 rows.

The table data_archive has 4,500,000 rows.

Question # 33

You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.

Question # 33

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.

Which set of actions will allow you to free disk space back to the file system?

Options:

Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:

Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:

Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:

Take a backup, stop the server, remove the data files, and restore the backup:

Answer

Questions # 34:

You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.

Total dataset size is 200G with an average schema size of 2G.

The data is transient and is not backed up and can be repopulated easily.

Performance and responsiveness of the DB is paramount.

The query pattern for the DB instance is split 90/10 read/write.

DB host is dedicated server with 256G RAM and 64 cores.

One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.

Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

Options:

table_open_cache = 64

innodb_buffer_pool_instances=64

innodb_buffer_pool_size=200G

log_bin=mysql –bin

Innodb_flush_log_at_trx_commit=1

sync_binlog=10

innodb_flush_method=O_DIRECT

max_heap_table_size = 2G

tmp_table_size=2G

query_cache_size = 2G

query_cache_enabled=1

Answer

A, B, E, G

Questions # 35:

You want to immediately stop access to a database server for remote user ‘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?

Options:

Use ALTER USER ‘mike’@’client.example.com’ PASSWORD EXPIRE;

Use REVOKE ALL PRIVILEGES FROM ‘mike’@’client.example.com’;

Execute the mysql_secure_installation command.

Use DROP USER ‘mike’@’client.example.com’;

Use GRANT USAGE ON *.* TO ‘mike’@’client.example.com’ MAX_USER_CONNECTIONS=0;

Use ALTER USER ‘mike’@’client.example.com’ ACCOUNT LOCK;

Answer

D, E

Questions # 36:

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

Question # 36

You execute a ‘SHOW CREATE TABLE mytable” on the slave:

Question # 36

The table mytable on the slave contains:

Question # 36

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?