[Q48-Q69] Latest Oracle 1Z0-888 First Attempt, Exam real Dumps Updated [May-2022]

ExamBoosts May 7, 2022 1Z0-888 > Oracle 0

Rate this post

Latest Oracle 1Z0-888 First Attempt, Exam real Dumps Updated [May-2022]

Get the superior quality 1Z0-888 Dumps Questions from ExamBoosts. Nobody can stop you from getting to your dreams now. Your bright future is just a click away!

NEW QUESTION 48
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

innodb_flush_log_at_trx_commit=0

NEW QUESTION 49
Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server’s health and performance?

Reduce the size of redo logs to improve storage efficiency.

Increase the size of redo logs.

Lower innodb_max_dirty_pages_pct to flush more often.

Move redo logs to /dev/shm to improve their speed.

NEW QUESTION 50
Which statement best describes the purpose of the InnoDB buffer pool?

It is amount of buffers available during a transaction.

It caches only the indexes for InnoDB tables.

It caches data and indexes for InnoDB tables.

It holds changes made during a transaction before they are written to the log.

It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

NEW QUESTION 51
You have a MySQL instance with the following variables in the /etc/my.cnffile:

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

The changes caused by the UPDATEstatement 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-formatvalue 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.

NEW QUESTION 52
Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

mysqld -e ‘shutdown’

service mysqld stop

mysqladmin shutdown

mysql -e ‘shutdown’

NEW QUESTION 53
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).

NEW QUESTION 54
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

–tab

–single-transaction

–quick

–skip-buffer

Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

NEW QUESTION 55
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)

Global variables are not persistent across server restarts.

Session variables are not persistent across server restarts.

The query benefited from sort_buffer_size increase.

sort_buffer_size should match tmp_table_size to be optimal.

The query benefited from tmp_table_size increase.

The query benefited from sort_buffer_size and tmp_table_size increases.

NEW QUESTION 56
Which three allocate memory per thread in MySQL?

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html

NEW QUESTION 57
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 mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

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

Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html

NEW QUESTION 58
You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
“permissive”.
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

3301

3303

3302

3304

NEW QUESTION 59
Which two statements are true regarding the creating of new MySQL physical and logical backups?
(Choose two.)

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

NEW QUESTION 60
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

Reference:
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html

NEW QUESTION 61
You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

Execute the PURGE BINARY LOGS NOT USED command.

Edit the .index file to remove the files you want to delete.

Ensure that none of the attached slaves are using any of the binary logs you want to delete.

Remove all of the binary log files that have a modification date earlier than today.

Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Explanation
A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file.
Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO ‘log_name’ | BEFORE datetime_expr }

NEW QUESTION 62
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

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

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’; mysql> GRANT PROXY ON ’employee’@’localhost’ TO ‘robert’@’localhost’;

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

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 ”@”;

NEW QUESTION 63
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

The salve has two intermediate relay slaves connected to it.

The slave is configured with slave_parallel_workers = 4

At most, two schemas are being updates concurrently.

THREAD_ID 21 has stopped running.

The slave cannot process the relay log fast enough to use all threads.

The server needs more cores to use all slave threads.

NEW QUESTION 64
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe?

Implement a failover strategy to another geographic location.

Create a master-master pair for each service.

Have a second data centre in a different region or country.

Keep software updated to the latest version.

Use RAID 10 storage for data.

Use on-site network-attached storage to separate service from data.

NEW QUESTION 65
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Implement a failover strategy to another geographic location.

Create a master-master pair for each service.

Have a second data centre in a different region or country.

Keep software updated to the latest version.

Use RAID 10 storage for data.

Use on-site network-attached storage to separate service from data.

NEW QUESTION 66
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

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

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;mysql> GRANT PROXY ON ’employee’@’localhost’ TO ‘robert’@’localhost’;

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

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 ”@”;

NEW QUESTION 67
There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackupcommand.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/,with extra instances having their own separate my.cnffile (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

–restore=2

–copy-back-from-log

–backup-instance=/var/lib/mysql/instance2

–instance=/var/lib/mysql/instance2

–defaults-file=/etc/mysql/instance2.cnf

NEW QUESTION 68
Exhibit:

What does the possible_keys column in this output denote?