1z1-908問題集、Oracle実際の試験問題

質問 1

Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

A. A raw backup is created.

B. The backup operation will finish only when apply-log is executed.

C. The backup operation will finish only when backup-and-apply-log is executed.

D. A single-file backup is created.

E. The --backup-dir option holds temporary output, status, and metadata files.

正解: B,E

質問 2

The mysqld instance has the connection control plugin enabled with these settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

A. The minimum value increases to 3000 and the maximum value increases to 4000.

B. An error is returned.

C. The minimum connection value is changed to 2000.

D. Only the minimum connection value is increased to 3000.

正解: D

質問 3

Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

A. Truncating the transactions table will free up the most disk space.

B. Executing ALTER TABLE transactions will enable you to free up disk space.

C. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

D. Truncating the sales and leads table will free up disk space.

E. The transactions table was created with innodb_file_per_table=OFF.

正解: C,E

質問 4

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The transaction tables are backed up first, then the archive tables and redo logs.

B. The redo logs are backed up first, then the transaction and archive tables.

C. The archive tables are backed up first, then the transaction tables and redo logs.

D. The redo logs are not backed up at all.

E. The redo logs are backed up only if there are changes showing for the transactions tables.

正解: E

質問 5

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

A. Use mysql_secure_installation to encrypt stored login credentials.

B. Use the AES_ENCRYPT() MySQL function on the option file.

C. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

D. Use mysql_config_editor to create an encrypted file.

正解: D

質問 6

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A. cluster.forceQuorumUsingPartitionOf()

B. dba.configureInstance()

C. cluster.addInstance()

D. dba.configureLocalInstance()

E. cluster.setPrimaryInstance()

F. dba.checkInstanceConfiguration()

G. dba.createCluster()

正解: A,E

質問 7

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

A. binary log

B. slow query log

C. general query log

D. audit log

E. error log

正解: A

質問 8

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

A. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

B. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

C. ALTER TABLE employees -
ADD INDEX (birth_date DESC);

D. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

E. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

F. ALTER TABLE employees -
ADD INDEX (birth_date);

正解: C,E

質問 9

How can mysql_multi be configured to allow MySQL instances to use the same port number?

A. The instances use different socket names.

B. The instances listen on different IP addresses.

C. The instances have appropriate net masks set.

D. The instances use different user accounts unique to each instance.

正解: B

質問 10

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

A. Mark must connect from localhost to activate the r_read@localhost role.

B. Mark can grant the r_read@localhost role to another user.

C. Mark can grant the privileges assigned to the r_read@localhost role to another user.

D. ADMIN OPTION causes the role to be activated by default.

E. ADMIN OPTION allows Mark to drop the role.

F. Mark can revoke the r_read@localhost role from another role.

正解: B,F

解説: (PassTest メンバーにのみ表示されます)

Oracle MySQL 8.0 Database Administrator - 1z1-908 模擬練習