あなたを必ず合格させる1Z1-888問題集PDF2022年最新のに更新されたのは155問あります [Q10-Q25]

Rate this post

あなたを必ず合格させる1Z1-888問題集PDF2022年最新のに更新されたのは155問あります

Oracle 1Z1-888リアル試験問題と解答を無料で提供いたします

Oracle 1Z1-888 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Explain How Mysql Stores Data Identify Redo And Undo Logs
トピック 2	Explain Operating System Security Understand How Mysql Processes Requests Understand The EXPLAIN Statement
トピック 3	Monitor Replication Start And Stop Mysql Configure Replication
トピック 4	Configuring A Replication Topology Troubleshoot Replication
トピック 5	Identify The Causes Of Server Slowdowns Create And Modify User Accounts
トピック 6	Identify Replication Threads Use Password Security Identify Slow Queries
トピック 7	Configure Passwords And Account Expiration Identify Mysql Privilege System
トピック 8	Protect Against SQL Injections Understand Network Security
トピック 9	Explain Techniques That Use The Binary Log Understand Initial Configuration
トピック 10	Understand Authentication Plug-Ins Maintaining A Stable System
トピック 11	Reset A Forgotten Root Password Use System Variables Use Capacity Planning

質問 10
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.

質問 11
Which three tasks are handled by the optimizer?

Decide which indexes to use.

Rewrite the WHEREclause.

Parse the query.

Change the order in which the tables are joined.

Validate the query.

Execute the query.

Verify that the user is allowed to execute the query.

質問 12
A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

The applications have the SUPER privilege, which allows them to update rows.

The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

The slave was created with mysqldump -u root -p –skip-lock-tables -all-databases > /data/data.sql

The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

質問 13
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 mysqldinstance 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.cnffile is not readable.

質問 14
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?

Install the X509plug-in on the server.

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

Restart the server with the –require-x509option.

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

Provide users access to the server’s private key.

質問 15
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

質問 16
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).

質問 17
A MySQL replication slave is set up as follows:
* Uses all InnoDB tables
* Receives ROW-based binary logs
* Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

The applications have the SUPER privilege, which allows them to update rows.

The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

The slave was created with mysqldump -u root -p –skip-lock-tables -all-databases > /data/data.sql

The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

質問 18
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.

質問 19
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

binlog_cache_size=1024is too small and transactions are lost.

binlog_format=STATEMENTand a non-deterministic query was executed.

enforce_gtid_consistency=ONand consistency is broken between the master and the slave.

The sync_relay_log=1000setting on the slave is too small.

sync_binlog=0and the master server crashed.

質問 20
You have created a backup of the ‘sales’ database with the command:

Which two procedures can be used to restore the ‘orders’ table from the backup?

質問 21
You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S’ in a number of locations in the output.
What does the N indicate?

the number of times the statement was executed

an abbreviation for NULL in a statement

the name of the user issuing the statement

an abstracted substitution for numbers indicated in WHERE clauses

https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html

質問 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?

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.

質問 23
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

質問 24
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.

質問 25
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?