Oracle MySQL 2021 Implementation Essentials - 1Z1-921 Exam Practice Test

A. MySQL is a document database allowing PDF and Word documents

B. MySQL provides a native data type to store JSON data as a document

C. MySQL provides a NoSQL API to access the document store

D. MySQL provides a native data type to index PDF documents

E. MySQL can store XML as a schema-less database

A. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

B. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

C. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

D. MySQL Enterprise Monitor creates the required users automatically.

A. ALTER TABLE city DROP population;

B. DROP population FROM city;

C. ALTER TABLE city DELETE population;

D. DELETE population FROM city;

E. ALTER TABLE city LESS population;

A. SET GLOBAL force_password_complex_policy=0;

B. Add validate_password=,new level, in the [security] section of the MySQL configuration file.

C. SET GLOBAL validate_password_policy=,new level,;

D. Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

A. MySQL Enterprise Backup provides the point-in-time recovery functionality.

B. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

C. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

D. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

E. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

A. Enables data-at-rest encryption by encrypting the physical files of the database.

B. Encryption key is stored in a centralized key memory location

C. Tablespace keys are managed manually behind the scenes.

D. Data is encrypted automatically, in real time, after it is written to storage.

A. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

B. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

C. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

D. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;