Free Oracle 1Z1-920 Exam Dumps Questions & Answers

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.  Convert the private key to ppk format first and use the new private key for authentication.
• B.  Open Port 22 on your OCI Instance and configure Putty with the ssh private key.
• C.  Use the provided private key for authentication.
• D.  Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A.  SHOW PROCESSLIST;
• B.  SHUTDOWN
• C.  SHOW STATUS;
• D.  SHOW BINLOG EVENTS;
• E.  KILL PROCESS;
• F.  GRANT PROXY

Which three are characteristics of the JSON data type?

• A.  It supports indexing directly against the JSON-defined column.
• B.  It validates the JSON syntax on insert or merge.
• C.  Key or array references enable quick read-access to look up document elements directly.
• D.  A set of SQL functions substantially support the SQL utilization of the data type.
• E.  Comparisons of JSON values are not case-sensitive.
• F.  It is based on the TEXT data type.

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

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

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

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