Oracle Oracle Database 1Z0-920 Questions & Answers

• Question 1:

  Which two methods help prevent MySQL security risks?

  A. Use a firewall to control access to MySQL ports.

  B. Transmit plain (unencrypted) data over networks.

  C. Ensure that MySQL accounts have short and easy passwords.

  D. Allow unauthorized clients to connect to the server.

  E. Use the secure installation script "mysql_alays_secure_installation".

  F. Grant only permissions that a user requires.

  Correct Answer: BD

• Question 2:

  Which two statements about the download of MySQL Enterprise Backup are correct?

  A. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

  B. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

  C. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

  D. MySQL Enterprise Backup comes with all MySQL editions including community edition.

  E. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

  Correct Answer: CD

• Question 3:

  Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

  A. Custom Image

  B. Object Storage

  C. existing VCN

  D. bare metal Oracle Linux shape

  E. ssh key pair

  F. subnet configured on a Virtual Cloud Network (VCN)

  Correct Answer: ABD

• Question 4:

  Which two statements are true about MySQL Enterprise Authentication?

  A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

  B. MySQL Enterprise Authentication determines what operation the user can perform.

  C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

  D. MySQL Enterprise Authentication supports Windows Active Directory.

  E. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

  Correct Answer: CD

• Question 5:

  The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being

  monitored with suitable privileges to collect information about the server.

  Which statement is correct?

  A. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

  B. MySQL Enterprise Monitor creates the required users automatically.

  C. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

  D. Monitoring metrics need super and root privileges because they are not available for a less- privileged user.

  Correct Answer: C

• Question 6:

  Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

  A. MySQL Enterprise Audit

  B. MySQL Enterprise Scalability

  C. MySQL Enterprise No-Login Authentication

  D. MySQL Enterprise Transparent Data Encryption (TDE)

  E. MySQL Enterprise Data Masking and De-identification

  Correct Answer: E

  New! MySQL Enterprise Masking and De-identification MySQL Enterprise Masking and De-identification provides an easy to use, built-in database solution to help organizations protect sensitive data from unauthorized uses by hiding and replacing real values with substitutes. https://www.mysql.com/products/enterprise/#:~:text=New!andtext=MySQL%20Enterprise% 20Maskin g%20and%20De%2Didentification%20provides%20an%20easy%20to,replacing%20real% 20values%2 0with%20substitutes.

• Question 7:

  Which activity will take place if a table is created with both the compression and encryption options?

  A. The compression is performed before tablespace data is encrypted.

  B. The tablespace data is encrypted first and then compression is performed.

  C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

  D. The compression is performed, the `'data_at_rest_flag" is turned on and the tablespace data is encrypted.

  Correct Answer: A

  If a table is created with both the COMPRESSION and ENCRYPTION options, compression is performed before tablespace data is encrypted. https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/innodb-data-encryption.html

• Question 8:

  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,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;

  C. CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE

  D. CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')

  E. CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)

  Correct Answer: E

• Question 9:

  Which three statements are true about MySQL Enterprise Backup?

  A. It performs hot or warm backups.

  B. It provides the ability to create incremental backups.

  C. It cannot back up encrypted tablespaces.

  D. It enables you to take non-locking backups.

  E. It performs logical backups.

  Correct Answer: BDE

• Question 10:

  The slave connects to the master and asks for updated records. What command was issued for this to happen?

  A. SLAVE RUN

  B. SLAVE START

  C. START RUN SLAVE

  D. RUN SLAVE

  E. START SLAVE

  Correct Answer: B