Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-888 Oracle MySQL 5.7 Database Administrator Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-888 MySQL 5.7 Database Administrator certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-888 Premium Access     Download Demo    
Page: 1 / 2
Total 124 questions

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

A.

Date should be a TIMESTAMP field for better performance.

B.

The User field is too long for most names.

C.

The engine type is not appropriate to the application use.

D.

Using default values for DATETIME causes table scans.

E.

No indexes are defined.

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.

Increase the value of the innodb_read_io_threads option.

C.

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

D.

Set the value of innodb_adaptive_hash_index to zero.

E.

Deactivate the query cache.

F.

Increase the size of the InnoDB buffer pool.

Which two capabilities are granted with the SUPER privilege?

A.

allowing change of the server runtime configuration

B.

allowing a client to shut down the server

C.

allowing client accounts to take over the account of another user

D.

allowing a client to kill other client connections

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

A.

mysqldumpslow

B.

mysqldump

C.

mysqlaccess

D.

mysqlshow

E.

mysqlslow

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?

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.

Consider that local disk files are accessible via MySQL with commands such as:

mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;

What change could be made to stop any breach via this insecurity?

A.

executing REVOKE LOAD FROM *.*

B.

setting the --local-service=0 option when starting mysqld

C.

executing REVOKE FILE FROM *.*

D.

executing REVOKE FILE ON *.* FROM ‘ ’ @’%’

E.

setting the --local-infile=0 option when starting mysqld

F.

setting the --open-files-limit=0 option when starting mysqld

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 time the query took is the sum of all timer_wait values.

B.

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

C.

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

D.

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

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:

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.

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

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?

A.

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

B.

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

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:

D.

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

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A.

Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

B.

Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

C.

No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

D.

No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

SQL injection is a common security threat.

Which two methods would help protect against this risk?

A.

using stored procedures to validate values that are input

B.

using SQL variables to secure input values

C.

using prepared statements to handle unsecured values

D.

installing the SQL Protection plugin to catch such attempts

E.

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

This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

A.

The master has performed a large transaction, which will take 360 seconds to complete on the slave.

B.

The network latency between the master and the slave is 360 milliseconds.

C.

The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

D.

The slave was configured for delayed replication with a delay of six minutes.

What does the possible_keys column in this output denote?

A.

if it is possible for you to include any indexes in your query

B.

whether there are any indexes on the tables that you are querying

C.

if there are any indexes that may be used to solve this query

D.

whether you are using any indexes in your query

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

A.

it contains the binary log.

B.

it contains a general tablespace.

C.

it is the default location for all new tables that you create.

D.

it contains the system tablespace.

E.

it contains the redo log.

F.

it contains the undo log.

You back up by using mysqldump.

Which configuration is required on the MySQL Server to allow point-in-time recovery?

A.

binlog_format=STATEMENT

B.

log-bin

C.

apply-log

D.

bonlog_format=ROW

E.

gtid_enable

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.

The colleague instant messages you this command:

mysql> SET SESSION max_connections = 200;

Why does the command fail?

A.

max_connections requires the GLOBAL scope.

B.

Its current user does not have the SUPER privilege.

C.

max_connections is not a dynamic variable. You need to change the config file and restart the database.

D.

Users can control only the max_user_connections variable.

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?

A.

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

B.

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

C.

Execute the mysql_secure_installation command.

D.

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

E.

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

F.

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

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

A.

- -no-create-info to skip writing CREATE TABLE statements

B.

- -single-transaction as this obtains a consistent view of data only

C.

- -data-only as this specifies that only data is to be dumped

D.

- -table=userdata in order to dump only the data from the userdata table

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

What should you do to resolve this error?

A.

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

B.

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

C.

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

D.

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

Consider the join_buffer_size parameter in MySQL Server.

Which two statements are true about the join buffer? (Choose two.)

A.

The value should be increased if the client performs several SELECT operations.

B.

The join buffer is set per connection.

C.

The join buffer is used to process sorts when complex joins are being performed.

D.

The value should be increased from the default if the query joins large rows without using an index.

E.

The join buffer is global and can be changed only by restarting the server.

Host slave1 has ip address 192.0.2.10.

Host slave2 has ip address 203.0.113.50

Examine these commands:

Why did this error occur?

A.

The host on the command line is not defined in the login path.

B.

The mysqld instance has not been restarted after creating the login path.

C.

There is no password defined in the login path.

D.

The DNS is not configured correctly for slave1 host.

E.

The .mylogin.cnf file is not readable.

Oracle 1z0-888 Premium Access     Download Demo    
Page: 1 / 2
Total 124 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved