1z1-908無料問題集「Oracle MySQL 8.0 Database Administrator」

質問 1

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

（A）--shared-memory-base-name=world

（B）--database=world

（C）--port=3306

（D）--user=admin

（E）--socket=/tmp/mysql.sock

（F）--protocol=pipe

（G）--host=192.0.2.1

（H）--password

（I）--protocol=UDP

正解：A、F、G、H 解答を投票する

質問 2

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

（A）It decrypts data for use in memory.

（B）It does not support the transportable tablespaces feature.

（C）It supports only non-blob datatypes.

（D）It enforces encryption from disk to memory and over network transmission.

（E）It supports all indexes transparently.

正解：A、E 解答を投票する

質問 3

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

（A）Increase the number of buffer pool instances to 32.

（B）Increase the number of buffer pool instances to 12.

（C）Increase the number of buffer pool instances to 16.

（D）Decrease the number of buffer pool instances to 1.

（E）Decrease the number of buffer pool instances to 4.

正解：A 解答を投票する

質問 4

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

（A）change buffer

（B）doublewrite buffer

（C）user privileges

（D）primary indexes

（E）InnoDB Data Dictionary

（F）table data

正解：B、E 解答を投票する

質問 5

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

（A）user_variables_by_thread

（B）session_variables

（C）variables_by_thread

（D）global_variables

正解：B 解答を投票する

質問 6

Which three actions are effective in capacity planning? (Choose three.)

（A）basing expected growth on an average of the last 3 years

（B）buying more disk

（C）adding circular replication nodes for increased DML capability

（D）monitoring OS resources for patterns

（E）buying more CPU

（F）consulting the application team about any future projects and use

（G）upgrading to the latest application version

（H）buying more RAM

正解：A、D、F 解答を投票する

質問 7

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

（A）It is possible to retrieve a normalized statement, but never the exact statement that was executed.

（B）It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

（C）The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

（D）It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

（E）It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

正解：D、E 解答を投票する

質問 8

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

（A）Run mysqld with --datadir defined for each instance.

（B）Use resource groups to lock different instances on separate CPUs.

（C）Start mysqld or mysqld_safe using different option files for each instance.

（D）Run MySQL Server docker containers.

（E）Use systemd with different settings for each instance.

（F）Use system tools to lock each instance to its own CPU.

正解：A、C、E 解答を投票する

質問 9

A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

（A）undo_001

（B）ibdata1

（C）ib_buffer_pool

（D）ibtmp1

（E）ib_logfile0

（F）mysql.ibd

正解：C、F 解答を投票する

質問 10

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

（A）ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';

（B）ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

（C）ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';

（D）[mysqld]
default_authentication_plugin=mysql_native_password

（E）[mysqld]
default_authentication_plugin=caching_sha2_password

（F）[mysqld]
default_authentication_plugin=sha256_password

正解：C 解答を投票する

1z1-908 無料問題集「Oracle MySQL 8.0 Database Administrator」

弊社を連絡する

関連リンク

トップ試験