Oracle 1Z0-920 Online Practice Questions and Exam Preparation

Oracle 1Z0-920 Online Questions & Answers

• Question 1:

  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.
  B. MySQL Enterprise Backup will back up from Slave automatically.
  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.

• Question 2:

  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
  B. SLAVE START

• Question 3:

  What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

  A. Data is encrypted automatically, in real time, after it is written to storage.
  B. Enables data-at-rest encryption by encrypting the physical files of the database.
  C. Encryption key is stored in a centralized key memory location
  D. Tablespace keys are managed manually behind the scenes.
  B. Enables data-at-rest encryption by encrypting the physical files of the database.

• Question 4:

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

• Question 5:

  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 provides the point-in-time recovery functionality.
  C. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
  D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
  E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
  B. MySQL Enterprise Backup provides the point-in-time recovery functionality.
  D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
  E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

• Question 6:

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

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

• Question 7:

  What three are ways to export and import data in MySQL Workbench?

  A. Result Data Export and Import
  B. Binary Data Export and Import Wizard
  C. SQL Data Export and Import Wizard
  D. Backup Data Export and Import Wizard
  E. Table Data Export and Import Wizard
  F. Data Modeling Import Export Wizard
  A. Result Data Export and Import
  C. SQL Data Export and Import Wizard
  E. Table Data Export and Import Wizard

• Question 8:

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

• Question 9:

  You just installed MySQL by Using a Package Manager on Linux. Where are the default InnoDB redo log files stored?

  A. /usr/mysql
  B. /var/lib/mysql
  C. /var/lib/mysql/innodb
  D. /usr/bin/logs
  E. /usr/redo
  F. /etc/my.cnf
  E. /usr/redo

• Question 10:

  Which statement would you use to remove the population column from the city table?

  A. ALTER TABLE city DROP population;
  B. DELETE population FROM city;
  C. ALTER TABLE city DELETE population;
  D. ALTER TABLE city LESS population;
  E. DROP population FROM city;
  A. ALTER TABLE city DROP population;