1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-888
  5. MySQL 5.7 Database Administrator Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions
Questions # 21:

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.

Which statement describes the activation of that access for the user?

Options:
A.

The access does not take effect until the user logs out and back in.

B.

The access does not take effect until the next time the server is started.

C.

The access is available immediately.

D.

The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Questions # 22:

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 # 22

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 # 22

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

Question # 22

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:
A.

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

1z0-888 Question 22 Option 1

B.

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

22

C.

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:

22

D.

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

22

Questions # 23:

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

Options:
A.

using SSL when transporting data over remote networks

B.

using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

C.

setting --skip-networking when remote connections are not required

D.

setting specific GRANT privileges to limit remote authentication

E.

setting --mysql_secure_configuration to enable paranoid mode

Questions # 24:

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

Options:
A.

It caches index blocks for MyISAM tables only.

B.

It caches index blocks for all storage engine tables.

C.

It is a global buffer.

D.

It is set on a per-connection basis.

E.

It caches index blocks for InnoDB tables only.

Questions # 25:

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

Options:
A.

Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

B.

Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

C.

Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

D.

Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

E.

Start the MySQL Server with –initialize-insecure to force a password reset procedure on the command line.

Questions # 26:

These details are shown when logged in to an account:

Question # 26

Which set of statements would match the accounts shown?

Options:
A.

mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

mysql> CREATE USER ’’@’’ IDENTIFIED BY ‘valid_password’ WITH PROXY ‘employee’@’localhost’;

B.

mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

mysql> GRANT PROXY ON ‘employee’@’localhost’ TO ‘robert’@’localhost’;

C.

mysql> CREATE USER ‘robert’@’localhost’ IDENTIFIED BY ‘secret_password’;

mysql>CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

D.

mysql> CREATE_USER ’’@’’ IDENTIFIED WITH authentication_pam ACCOUNT LOCK;

mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

mysql> GRANT PROXY ON ‘employee’@’localhost’ TO ’’@’’;

Questions # 27:

Where does MySQL Linux RPM install the mysqld binary?

Options:
A.

/usr/libexec/

B.

/usr/local/mysql/bin/

C.

/usr/sbin/

D.

/usr/bin/

E.

/opt/mysql/server/bin/

Questions # 28:

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?

Options:
A.

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

B.

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

C.

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

D.

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

E.

Secondary indexes no longer fit into the buffer pool.

Questions # 29:

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be “rolled forward” to provide all the latest data.

The SHOW SLAVE STATUS indicates these values:

    RELAY_LOG_FILE=hostname-relay-bin.00004

    RELAY_LOG_POS=1383

Which command set would make the slave current?

Options:
A.

STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

B.

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’,

RELAY_LOG_POS = 1383;

C.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

D.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

Questions # 30:

Which are three facts about backups with mysqldump? (Choose three.)

Options:
A.

will lock all storage engines for duration of backup

B.

can back up a remote database server

C.

allow a consistent backup to be taken

D.

are able to back up specific items within a database

E.

create automatically compressed backups

F.

are always faster to restore than binary backups

Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions