1z0-888 Oracle MySQL 5.7 Database Administrator exact Exam Questions

MySQL 5.7 Database Administrator

Last Update 23 hours ago Total Questions : 124

The MySQL 5.7 Database Administrator content is now fully updated, with all current exam questions added 23 hours ago. Deciding to include 1z0-888 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our 1z0-888 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these 1z0-888 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any MySQL 5.7 Database Administrator practice test comfortably within the allotted time.

Question # 21

Which statement is correct about how InnoDB storage engine uses disk space?

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

Question # 22

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

A .mylogin.cnf file can store at most one login path.

It provides a FIPS-compliant keyring for storing MySQL login details.

A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

It is an alternative to storing the MySQL login details in a my.cnf file.

It provides means to help avoid accidentally exposing the MySQL login details.

Question # 23

SQL injection is a common security threat.

Which two methods would help protect against this risk?

using stored procedures to validate values that are input

using SQL variables to secure input values

using prepared statements to handle unsecured values

installing the SQL Protection plugin to catch such attempts

starting the server with the –-injection-protection command-line option.

Question # 24

Which two statements are true regarding MySQL security? (Choose two.)

The mysql user needs to have sudo privileges.

The mysqld process owner should own all files and directories to which the server writes.

The root or administrator users should own all files and directories to which the server writes.

The mysqld process should be run as root or administrator.

The mysqld process should not be run as root or administrator.

Question # 25

Which two options describe how MySQL Server allocates memory? (Choose two.)

Each connection may have its own per-thread memory allocations.

Thread memory is pre-allocated up to thread_cache_size for performance.

Each thread allocates memory from a global pool.

Global memory resources are allocated at server startup.

Question # 26

What is the order of tables shown in an EXPLAIN output?

It lists tables from the smallest to the largest.

It lists tables in the order in which their data will be read.

It lists tables from the most optimized to the least optimized.

It lists tables in the order in which they are specified in the statement that is being explained.

Question # 27

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

UPDATE sales.january SET amount=amount+1000;

An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

Which statement is true? (Choose two.)

You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

The statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.

Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Question # 28

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

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

Question # 29

A crucial database, ‘db_prod’, just disappeared from your production MySQL instance.

In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:

SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’

Which three methods could have been used to prevent this SQL injection attack from happening? (Choose three.)

writing your client code to properly escape all user input

giving limited privileges to accounts used by application servers to interact with their backing databases

using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions

using a hashing or encryption method to secure all user passwords in your MySQL tables

removing any remaining anonymous accounts from your MySQL instance

validating all user input before sending it to the database server

changing all passwords for the MySQL account ‘root’@’%’ immediately after losing an employee who knew the current password

Question # 30

Consider the CHECK TABLE command.

In which two situations should this command be used? (Choose two.)