Which statement will display the status of the partitioning plug-in?

• A. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
• B. USE SYS SCHEMA; SHOW PLUGINS STATUS;
• C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM
  INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
• D. SHOW PLUGINS WHERE Name= 'partition';

When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

• A. opc, oracle, and root (through sudo)
• B. cloud-admin, oracle, and root
• C. administrator, opc, and oracle
• D. root, opc-administrator, and oracle through sudo
• E. admin, ora-cloud, and oracle

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 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 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.
• 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 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.
• 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 true about MySQL Enterprise Firewall?

• A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• B. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• C. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• D. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• E. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• F. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.