Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with ExamsMirror

MySQL Router is configured based on the information in files in directory_path.

MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

MySQL Router is restarted.

MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

recording the order in which queries are issued

audit of all queries

point-in-time recovery

replication

logging the duration and locks for all queries

It installs most Oracle MySQL products.

It performs product upgrades.

It provides only GUI-driven, interactive installations.

Manual download of separate product packages is required before installing them through MySQL Installer.

It provides a uniform installation wizard across multiple platforms.

ALTER TABLE employees -

ADD INDEX (birth_date DESC);

ALTER TABLE employees -

ADD INDEX ((MONTH(birth_date)));

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL,

ADD INDEX (birth_month);

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL,

ADD INDEX (birth_month);

ALTER TABLE employees -

ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

ALTER TABLE employees -

ADD INDEX (birth_date);

The slave relay logs should be deleted; then execute START SLAVE;

The relay logs from the master should be used to replace the corrupted relay logs.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

The slave needs to be restored from backup.

Remove group read/write privileges from the private_key.pem file.

Remove world read privileges from the server-cert.pem certificate file.

Change the group ownership of the mysql directory to the mysql user group.

Remove world read privileges from the public_key.pem file.

Change the parent directory owner and group to mysql.

Remove the world read/execute privilege from the accounting directory.

It creates a logical backup of all MySQL user accounts.

It creates a logical backup of all metadata, but contains no table data.

It returns an error because the mysqldump command should have been used.

It creates a logical backup of only the users database.

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

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

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

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

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

It supports only non-blob datatypes.

It does not support the transportable tablespaces feature.

It supports all indexes transparently.

It decrypts data for use in memory.

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

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

ADMIN OPTION causes the role to be activated by default.

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

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

ADMIN OPTION allows Mark to drop the role.

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