Which statement adds a column with the largest integer data type?

A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

B. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

C. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. You forgot to enable port 3306.

B. The opc user can be used to access MySQL only with the created SSH-Key.

C. Only root is allowed to access from non-localhost.

D. You forgot to create the correct SSL/TLC certificate during the setup process.

E. The OCI instance is still in the "creation" process.

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 all three machines.

3.

Start mysqlbackup on all machines to back up the database to the mounted volume using - -backupdir.

4.

Validate the backup 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 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.

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 two statements are correct about MySQL Enterprise Edition?

A. MySQL configuration can be changed in /etc/lib/myi.cnf.

B. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

C. Oracle MySQL Enterprise tools and plugins are available as optional services (installation Feature Pack I/ II).

D. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

E. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH). When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management. What are two ways to successfully configure Workbench based on the MySQL access credentials?

A. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

B. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

C. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

D. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.