You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

• A.You need to agree to the maintenance windows. If not, you are not affected by the outage.
• B.There are no maintenance operations planned. You need to do them manually.
• C.Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
• D.You can expect an outage of your MySQL OCI instance during the planned time..

Comment: *

Name: *

Email: *

Verification: *

Which three statements describe MySQL Enterprise Backup?

• A.MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
• B.MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
• C.MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
• D.MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
• E.MySQL Enterprise Backup provides the point-in-time recovery functionality.

Comment: *

Name: *

Email: *

Verification: *

You execute this statement:
SELECT NULL=NULL;
What is the result?

• A.1
• B.NULL
• C.0
• D.FALSE
• E.TRUE

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about MySQL Enterprise Authentication?

• A.MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
• B.MySQL Enterprise Authentication determines what operation the user can perform.
• C.MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
• D.MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
• E.MySQL Enterprise Authentication supports Windows Active Directory.

Comment: *

Name: *

Email: *

Verification: *

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'@'%' IDENTIFIED WITH sha256_password BY 'SecretPass123!';
• B.CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')
• C.CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE
• D.CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;
• E.CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)

Comment: *

Name: *

Email: *

Verification: *