Oracle Oracle Certifications 1Z0-920 Questions & Answers

• Question 21:

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

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

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

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

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

  E. 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.

  Correct Answer: BDE

• Question 22:

  Which two statements are true about MySQL Enterprise Firewall?

  A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

  B. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

  C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

  D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

  E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

  F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

  Correct Answer: DE

• Question 23:

  You have a backup image file that is backed up using MySQL Enterprise Backup with the --compress option: /home/mysq1/backup/full/mybackup/myimage. Img

  

  You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  E. Option E

  Correct Answer: B

• Question 24:

  What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

  A. Email

  B. Browser pop-ups

  C. Direct support call from an Oracle representative

  D. SMS-notification tab on the dashboard

  E. Application-to-application messaging

  Correct Answer: AD

• Question 25:

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

  A. You can connect directly to the VCN without a define subnet.

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

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

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

  E. You must have an IPSec VPN to connect to an Oracle Linux instance.

  Correct Answer: AD

• Question 26:

  MySQL is installed on a Linux server with the configuration:

  

  Which two methods can change the default options to use the authentication plug-in that implements SHA256 hashing for user account passwords?

  A. Create user by using CREATE USER `newuser' @'localhost' SET PASSWORD AS `Sh@256Pa33';

  B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

  C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

  D. Create user by using CREATE USER `newuser'@'localhost' IDENTIFIED WITH `Sh@256Pa33';

  Correct Answer: BD

• Question 27:

  An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore. What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

  A. MySQL Enterprise Backup does not back up system data so that it is much faster.

  B. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

  C. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

  D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

  E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

  Correct Answer: DE

• Question 28:

  You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by

  a MEM agent should automatically monitor discovered instances.

  How can you change the Advisor Setting?

  A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

  B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

  C. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

  D. Go to the configuration section (MEM) and configure the default login credentials.

  Correct Answer: B

• Question 29:

  Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

  A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

  B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

  C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

  D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

  E. A browser-based wizard to remotely deploy the MySQL Monitor Agent

  Correct Answer: ABC

• Question 30:

  An Oracle Cloud Infrastructure customer already has many database instances configured and running in

  the cloud; however, they are reporting that they are unable to create any more instances.

  What could be the problem?

  A. The customer does not have proper user rights.

  B. The customer reached the database instance limit of 32.

  C. The customer account might have reached resource quota/limits.

  D. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.

  Correct Answer: B