You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

• 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.

Which three are characteristics of the JSON data type?

• A. It is based on the TEXT data type.
• B. It validates the JSON syntax on insert or merge.
• C. It supports indexing directly against the JSON-defined column.
• D. A set of SQL functions substantially support the SQL utilization of the data type.
• E. Comparisons of JSON values are not case-sensitive.
• F. Key or array references enable quick read-access to look up document elements directly.

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

• A. Direct support call from an Oracle representative
• B. Application-to-application messaging
• C. SMS-notification tab on the dashboard
• D. Browser pop-ups
• E. Email

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

• A. --decompress
• B. --uncompress-and-apply-log
• C. --apply-log-and-copy-back
• D. --copy-back-and-apply-log
• E. --uncompress

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

• A. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
• B. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
• C. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
• D. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
• E. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;