Latest Oracle 1Z0-888 Dumps for success in Actual Exam Sep-2023 [Q11-Q33]

Rate this post

Latest Oracle 1Z0-888 Dumps for success in Actual Exam Sep-2023]

Realistic 1Z0-888 100% Pass Guaranteed Download Exam Q&A

QUESTION 11
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?

The time the query took is the sum of all timer_waitvalues.

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

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

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

QUESTION 12
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

The log_bin variable is set to OFF on the slave.

server_id is not unique.

The max_connections variable on the slave needs to be increased.

The shared_memory_base_name variable must match the master.

The version of the slave is newer that the version of the master.

QUESTION 13
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 -binlogformat = 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 14
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?

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

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

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

QUESTION 15
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index?

Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

Add a functional index for YEAR(Birthday).

Execute ANALYZE TABLEto update the index statistics.

Add a generated column calculating YEAR(Birthday)and index that column.

Add FORCE INDEX (Birthday)to the query.

QUESTION 16
What is the best method for monitoring Group Replication conflict resolution?

the PERFORMANCE_SCHEMAtables

the SHOW PROCESSLISTcommand

the INNODBLock Monitor details

the SHOW STATUScommand

the INFORMATION_SCHEMAtables

QUESTION 17
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

They are not affected by this configuration change.

They all connect via the secure sha256_passwordalgorithm without any configuration change.

They will have their passwords updated on start-up to sha256_passwordformat.

They will have to change their password the next time they login to the server.

QUESTION 18
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?

Yes. Shut down the mysqldprocess, enable the transportable_tablespaceoption, and move the UNDO directory to the SSD.

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

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

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

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

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;

QUESTION 20
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 21
Suppose you are adding rows to a MyISAM table and the –datadir location runs out of disk space. What will happen when this occurs?

The server will crash.

The server suspends that INSERT operation until space becomes available.

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

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

QUESTION 22
You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

DROP USER `’@’localhost’;

ALTER USER `’@’localhost’ PASSWORD = `secret_password’;

ALTER USER bob@’%’ IDENTIFIED BY `secret_password’;

ALTER USER `root’@’localhost’ ACCOUNT LOCK;

ALTER USER bob PASSWORD = `secret_password’;

REVOKE ALL PRIVILEGES FROM `’@’localhost’;

QUESTION 23
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

Add a functional index for YEAR(Birthday).

Execute ANALYZE TABLEto update the index statistics.

Add a generated column calculating YEAR(Birthday)and index that column.

Add FORCE INDEX (Birthday)to the query.

QUESTION 24
Which three allocate memory per thread in MySQL? (Choose three.)

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

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

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

The table mytable on the slave contains:

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?

SET GTID_NEXT=”CONSISTENCY”;BEGIN; COMMIT;SET GTID_NEXT=”AUTOMATIC”;

SET GTID_NEXT=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8″;BEGIN; COMMIT;SET GTID_NEXT=”AUTOMATIC”;

SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

SET GLOBAL enforce_gtid_consistency=ON

SET GTID_EXECUTED=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8″;

QUESTION 26
Which three options are most likely to be changed for production form their default values? (Choose three.)

innodb_buffer_pool_size

max_connections

join_buffer_size

character_set_system

innodb_log_file_size

max_user_connections

port

QUESTION 27
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

mysql –protocol=PLAIN -uroot -p -h dbhost.example.com

INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

SET GLOBAL mysql_cleartext_passwords=1;

mysql –enable-cleartext-plugin -uroot -p -h dbhost.example.com

QUESTION 28
Suppose you are adding rows to a MyISAM table and the –datadirlocation runs out of disk space.
What will happen when this occurs?

The server will crash.

The server suspends that INSERT operation until space becomes available.

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

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

QUESTION 29
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?

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

innodb_flush_log_at_trx_commit=0

QUESTION 30
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

to allow the remaining events to be processed on the slave while not receiving new events from the master

to allow a backup to be created under reduced load

to allow for point-in-time recovery on the slave

to prevent schema changes from propagating to the slave before they are validated

to prevent any transaction experiencing a deadlock

QUESTION 31
Which two are considered good security practices when using passwords? (Choose two.)

Use one-way encryption for storage of passwords.

Store passwords external to the database.

Choose short passwords to save on storage space.

Use simple keyboard actions that give mixed letters.

Do not use dictionary-based words.

QUESTION 32
You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORD EXPIRE; What is the outcome?

When ‘erika’@’localhost’tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql>prompt.

When ‘erika’@’localhost’tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.

When ‘erika’@’localhost’tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

You receive a syntax error that indicates that you cannot set a password and expire it at the same time.

QUESTION 33
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)