1Z0-920 Exam Training Practice Tests (Oracle MySQL 2019 Implementation Essentials)]

Question 1

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. You must have an Internet gateway to connect to a public address on an Oracle Linux instance. B. You can connect directly to an instance over the internet, without a public IP address. C. Your instance does not have a public IP address, so you cannot connect with a public subnet. D. You must have an IPSec VPN to connect to an Oracle Linux instance. E. You can connect directly to the VCN without a define subnet.

Correct Answer: B,E

Question 2

You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

A. The table statistics will be stored. B. The table storage space will be reduced. C. The table will be optimized and replicated. D. The table will be checked for errors and repaired.

Correct Answer: C

Question 3

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 compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted. C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together. D. The tablespace data is encrypted first and then compression is performed.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

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

A. Custom Image B. bare metal Oracle Linux shape C. existing VCN D. Object Storage E. ssh key pair F. subnet configured on a Virtual Cloud Network (VCN)

Correct Answer: A,B,D

Question 5

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. Only root is allowed to access from non-localhost. B. The opc user can be used to access MySQL only with the created SSH-Key. C. You forgot to create the correct SSL/TLC certificate during the setup process. D. You forgot to enable port 3306. E. The OCI instance is still in the "creation" process.

Correct Answer: D

Question 6

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

Correct Answer: A,E

Question 7

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

A. The root password displayed on the screen via a [warning] message. B. The root password is not given and is blank. You must manually set the root password. C. The root_pw variable stored in the mysq1.install table. D. As root, execute the show password command by using the SHA-256 password encryption plug-in. E. The root password inserted in the error log set by the --log-error=[file_name] variable

Correct Answer: C,D

Oracle MySQL 2019 Implementation Essentials - 1Z0-920 Exam Practice Test