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 test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
• C.The encryption feature only works with InnoDB tables. You are creating a MylSAM table, 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.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

What are Security Lists in Oracle Cloud Infrastructure?

• A.They are essentially firewall rules that help control traffic between OCI instances.
• B.They contain rules established by HIPAA for securing end-user data.
• C.They are user-role designations that assign rights to certain internal users and external users.
• D.Security lists are data encryption levels that control who can see the data.
• E.They allow administrators access to applications in the cloud and external servers.

Comment: *

Name: *

Email: *

Verification: *

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.--uncompress-and-apply-log
• B.--apply-log-and-copy-back
• C.--uncompress
• D.--decompress
• E.--copy-back-and-apply-log

Comment: *

Name: *

Email: *

Verification: *