Oracle Oracle Certifications 1Z0-920 Questions & Answers

• Question 31:

  How would you restrict a user Joe from accessing all MySQL database objects?

  A. CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

  B. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

  C. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

  D. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

  E. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

  Correct Answer: D

• Question 32:

  Which Oracle product is certified to work with MySQL Enterprise Edition?

  A. Oracle Enterprise Backup

  B. Oracle Data Pump

  C. Oracle Enterprise Manager

  D. Oracle Application Express

  Correct Answer: C

  https://www.mysql.com/products/enterprise/

• Question 33:

  You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

  A. Execute the sakila-data. sqi script to populate the database

  B. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

  C. Use MySQL Enterprise High Availability to access one of the available data tables

  D. Use mysqldump to import data from the sakila_dummy database sample data set.

  Correct Answer: B

• Question 34:

  Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

  A. The number of machines per group must be 3, 5, 7 or 9.

  B. use SSD's for data and replication logs

  C. Groups must be in even numbers; 2, 4, 6, 8.

  D. isolated machine resources

  E. Use Network-attached storage (NAS) for the data files.

  F. smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM

  G. Networks must be in separate regions.

  Correct Answer: ACE

• Question 35:

  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

  Correct Answer: BCE

• Question 36:

  You have created your Compute instance using an Oracle-provided Oracle Linux image. You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

  A. Public IP address

  B. User Password

  C. SSH private key

  D. The opc user

  E. SSH public key

  F. The root user

  Correct Answer: D

  If you've created your instance using an Oracle-provided Oracle Linux image, then you can log in to your instance using SSH as the opc user. https://docs.oracle.com/en/cloud/iaas-classic/compute-iaas-cloud/ stcsg/accessing-oracle-linux-instance-using-ssh.html#GUID-D947E2CC-0D4C-43F4-B2A9A517037D6C11 https://docs.cloud.oracle.com/en-us/iaas/Content/Compute/References/ bestpracticescompute.htm

• Question 37:

  Which three are characteristics of the JSON data type?

  A. A set of SQL functions substantially support the SQL utilization of the data type.

  B. It supports indexing directly against the JSON-defined column.

  C. It validates the JSON syntax on insert or merge.

  D. Comparisons of JSON values are not case-sensitive.

  E. Key or array references enable quick read-access to look up document elements directly.

  F. It is based on the TEXT data type.

  Correct Answer: BCE

• Question 38:

  Which is true about inserting an additional line in a single document stored in MySQL document store?

  A. You specify the new element's position in the JSON_ARRAY_INSERT statement.

  B. Any new lines can only be inserted at the end of the document.

  C. You cannot insert a single line, you have to replace the entire document with a new document.

  D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.

  Correct Answer: A

• Question 39:

  Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT =

  1:

  

  What is the result after issuing the rollback command?

  A. Both the tables, t1 and t2, are created.

  B. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

  C. Only the t2 table is created.

  D. Only the t1 table is created.

  Correct Answer: A

• Question 40:

  You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH). When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management. What are two ways to successfully configure Workbench based on the MySQL access credentials?

  A. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

  B. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

  C. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

  D. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.

  Correct Answer: A