1z1-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

A. MySQL Query Analysis data

B. CPU utilization

C. disk usage and disk characteristics including disk advisors warnings

D. MySQL Replication monitoring

E. network-related information and network characteristics

F. security-related advisor warnings

G. operating system memory utilization

正解：A,C,F 解答を投票する

出題：2

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

A. ALTER TABLE t1 SET TDE = 'ON';

B. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

C. ALTER TABLE t1 ENCRYPTION='Y';

D. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

正解：D 解答を投票する

出題：3

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

A. They allow direct copying of table rows with operating system copy commands.

B. They do not back up views, stored procedures, or configuration files.

C. They take roughly twice as long as logical backups.

D. They work best for transaction storage engines that can perform their own recovery when restored.

E. There is a slight performance cost while the snapshot is active.

F. They do not use additional disk space.

G. The backup window is almost zero from the perspective of the application.

正解：B,D,F 解答を投票する

出題：4

Which three sets of item information are visible in the mysql system database? (Choose three.)

A. information about table structures

B. audit log events

C. help topics

D. rollback segments

E. plugins

F. performance monitoring information

G. time zone information and definitions

正解：C,D,E 解答を投票する

出題：5

Which two statements are true about the mysql_config_editor program? (Choose two.)

A. It can be used to create and edit SSL certificates and log locations.

B. It will use [client] options by default unless you provide --login-path.

C. It manages the configuration of the MySQL Firewall feature.

D. It manages the configuration of user privileges for accessing the server.

E. It manages the configuration of client programs.

F. It provides an interface to change my.cnf files.

G. It can move datadir to a new location.

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

出題：6

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

B. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

D. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

正解：A 解答を投票する

出題：7

You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Roll back the transaction and start the transaction again in the same session.

B. Change the default database and re-execute the failed statement in your transaction.

C. Close the connection, reconnect, and start the transaction again.

D. Re-execute the failed statement in your transaction.

正解：D 解答を投票する

出題：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 ((MONTH(birth_date)));

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

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

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

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

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

正解：B,F 解答を投票する

出題：9

Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

A. BLACKHOLE

B. NDB

C. MEMORY

D. InnopB

E. ARCHIVE

F. MyISAM

正解：A,B,F 解答を投票する

出題：10

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

A. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

C. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

正解：C 解答を投票する

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