1Z1-920 by Oracle Actual Free Exam Questions And Answers

Question 1

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

B. Use mysqldump with the - -changesonly option.

C. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

D. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

Discussion 0

Correct Answer: B,E Vote an answer

Question 2

Which two methods help prevent MySQL security risks?

A. Transmit plain (unencrypted) data over networks.

B. Use the secure installation script "mysql_alays_secure_installation".

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

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

E. Allow unauthorized clients to connect to the server.

F. Grant only permissions that a user requires.

Discussion 0

Correct Answer: A,E Vote an answer

Question 3

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A. It allows backup to be done on the slave without impacting the master.

B. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

C. MySQL Enterprise Backup will back up from Slave automatically.

D. It provides multi-master access where the application can write and read data across the database servers.

E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 4

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. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what 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. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

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

B. Custom Image

C. ssh key pair

D. bare metal Oracle Linux shape

E. existing VCN

F. Object Storage

Discussion 0

Correct Answer: B,D,F Vote an answer

Question 6

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

A. Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

B. Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

C. Convert the private key to ppk format first and use the new private key for authentication.

D. Use the provided private key for authentication.

Discussion 0

Correct Answer: B Vote an answer

Question 7

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

A. Your instance does not have a public IP address, so you cannot connect with a public subnet.

B. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

C. You can connect directly to an instance over the internet, without a public IP address.

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.

Discussion 0

Correct Answer: C,E Vote an answer

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

Contact Us

Useful Links

Latest Updated