1Z0-920 Online Practice Questions and Answers

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

A. You forgot to enable port 3306.

B. The opc user can be used to access MySQL only with the created SSH-Key.

C. Only root is allowed to access from non-localhost.

D. You forgot to create the correct SSL/TLC certificate during the setup process.

E. The OCI instance is still in the "creation" process.

Which three are levels in which MySQL Enterprise Monitor provides access control?

A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

B. Asset visibility: the rights to access data collected from hosts or MySQL instances

C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

D. Specific data access: the rights to view specific types of potentially sensitive data

E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

Which query will find rows in a table that have no counterpart in another table?

A. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

B. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

C. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

D. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

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

What SQL keyword must be specified when creating a foreign key constraint?

A. a TRIGGER on the child table for cascading delete statements

B. a REFERENCES in the child table to the parent table

C. unique PRIMARY key values for both child and parent tables

D. the SET_FOREGIN variable in the my .cnf file

E. an index on the foreign key

The user `fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands: You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?

A. Option A

B. Option B

C. Option C

D. Option D

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.

When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

A. Flash-archive recovery area

B. Cloud storage only

C. Cloud tape library

D. Both Cloud storage and local storage

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)

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.