Free Oracle 1z0-908 Practice Exam with Questions & Answers | Set: 4

Take a physical backup of the MySQL system.

Use the Clone Plugin to copy the data to another MySQL system.

Take a logical backup of the MySQL system.

Take your backup from a slave of the MySQL system.

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);

All databases are backed up to the output file.

All non-active binary logs are removed from the master.

All binary logs are deleted from the master.

All binary logs are backed up and then deleted.

All databases, excluding master metadata, are backed up to the output file.

All details regarding deleted logs and master metadata are captured in the output file.

Updating index statistics is an I/O expensive operation.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

Execution plans based on transient index statistics improve precision when

innodb_stats_persistent_sample_pages is increased.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Tables are scanned and index statistics recalculated when an instance is restarted.

GRANT ALL PRIVILEGES ON ‘world’.‘city’ TO ‘tom’@’%’;

GRANT SELECT (‘code’) ON ‘world’.‘country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;

GRANT ALL PRIVILEGES ON ‘world’.‘country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.‘country’ TO ‘tom’@’%’;

named pipes

shared memory

SOCKET

X Protocol

UDP

TCP/IP

performance metrics

InnoDB buffer pool LRU management data

access control lists

view definitions

server runtime configuration

server configuration rollback

stored procedure definitions

NDB

ARCHIVE

InnopB

BLACKHOLE

MEMORY

MyISAM

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

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

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

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

$HOME/.my.cnf file

$MYSQL_HOME/my.cnf file

DATADIR/mysqld-auto.cnf file

$HOME/.mylogin.cnf file

$HOME/.mysql/auth/login file

/etc/my.cnf file

$HOME/.mysqlrc file