MySQL is installed on a Linux server with the configuration:
Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

• A. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• B. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• C. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
• D. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
• B. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
• C. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
• D. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

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

Which two methods help prevent MySQL security risks?

• A. Use the secure installation script "mysql_alays_secure_installation".
• B. Use a firewall to control access to MySQL ports.
• C. Ensure that MySQL accounts have short and easy passwords.
• D. Allow unauthorized clients to connect to the server.
• E. Transmit plain (unencrypted) data over networks.
• F. Grant only permissions that a user requires.