1Z1-888 by Oracle Actual Free Exam Questions And Answers

Question 1

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
- It must be possible to rebuild the instance using the backup.
- It must be verified.
- It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

A. Include the binary logs in the backup.

B. Include the ibtmp1 file in the backup.

C. Include the operating system disk encryption key in the backup.

D. Include the relay logs in the backup.

E. Restore the backup to a clean MySQL instance.

F. Include the MySQL socket file in the backup.

G. Include the MySQL PID file in the backup.

H. Copy the backup to a remote host.

I. Include the keyring data and/or configuration in the backup.

Discussion 0

Correct Answer: C,D,G,H Vote an answer

Question 2

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

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

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

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

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

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which two methods will provide the total number of partitions on a table? (Choose two.)

A. Use the command: SHOW TABLE STATUS

B. Query the INFORMATION_SCHEMA.TABLES table for the partition_count

C. Use the command: SHOW CREATE TABLE

D. Query the performance_schema.objects_summary_global_by_type table

E. Query the INFORMATION_SCHEMA.PARTITIONS table

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

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? (Choose two.)

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

B. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;

C. Use DROP USER `mike'@'client.example.com';

D. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';

E. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;

F. Execute the mysql_secure_installation command.

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?

A. A text backup. A binary backup will still contain the corrupted segments.

B. A text backup. InnoDB does not allow you to make binary backups while the server is running.

C. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

A. Distribute client digital certificates to the client computers being used to log in by the user accounts.

B. Set the X509 option in the [client] section of the MySQL server's configuration file.

C. Restart the server with the --require-x509 option.

D. Provide users access to the server's private key.

E. Install the X509 plug-in on the server.

Discussion 0

Correct Answer: B Vote an answer

Question 7

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?

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

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

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

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

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

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB never uses table_level locks.

B. Some settings for innodb_autoinc_lock_mode can help reduce locking.

C. The auto-increment lock can be a table-level lock.

D. InnoDB does not use locks to enforce auto-increment uniqueness.

E. InnoDB always protects auto-increment updates with a table-level lock

Discussion 0

Correct Answer: B,C Vote an answer

Question 9

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

A. Increase the value of the innodb_lock_wait_timeout option.

B. Set the value of innodb_adaptive_hash_index to zero.

C. Increase the size of the InnoDB buffer pool.

D. Increase the value of the innodb_read_io_threads option.

E. Change the table to use HASH indexes instead of BTREE indexes.

F. Deactivate the query cache.

Discussion 0

Correct Answer: C,D Vote an answer

Question 10

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. The server will crash.

B. The server suspends operations for all storage engines until space becomes available.

C. The server suspends that INSERT operation until space becomes available.

D. An error message will be returned to the client .Server Error: ER_IO

Discussion 0

Correct Answer: C Vote an answer

Question 11

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

A. log-bin

B. apply-log

C. gtid_enable

D. binlog_format=STATEMENT

E. bonlog_format=ROW

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 12

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?

A. The OS needs to allow logging in as mysql so that administrative tasks can be performed.

B. The mysql user needs a login and its home directory must be the base directory of the installation.

C. This prevents creation of a command shell with the mysql account, while allowing mysqld to run.

D. This prevents mysqld from starting when standard startup scripts are used.

Discussion 0

Correct Answer: B Vote an answer

Question 13

Which MySQL utility copies the master instance to a slave instance on the same host?

A. mysqlserverclone

B. mysqlrplsync

C. mysqlfailover

D. mysqldbcopy

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle MySQL 5.7 Database Administrator - 1Z1-888 Exam Practice Test

Contact Us

Useful Links

Latest Updated