Oracle Oracle Certifications 1Z0-920 Questions & Answers

• Question 51:

  You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug- in

  from being removed at run time.

  Which two options should you include in the MySQL configuration file?

  A. audit_log_permanent=ON

  B. audit-log=FORCE_PLUS_PERMANENT

  C. plugin-load=audit_log.so

  D. plugin-audit=ON, ALWAYS

  E. LOAD PLUGIN=AUDIT_LOG

  Correct Answer: AB

• Question 52:

  You execute this statement: SELECT NULL=NULL; What is the result?

  A. FALSE

  B. NULL

  C. 0

  D. TRUE

  E. 1

  Correct Answer: B

• Question 53:

  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. Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

  B. Use the provided private key for authentication.

  C. Convert the private key to ppk format first and use the new private key for authentication.

  D. Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

  Correct Answer: A

• Question 54:

  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;

  Correct Answer: B

• Question 55:

  Which statement will display the status of the partitioning plug-in?

  A. SHOW STATUS PLUGINS WHERE Name= `PARTITIONING';

  B. SHOW PLUGINS WHERE Name= `partition';

  C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= `partition';

  D. USE SYS SCHEMA; SHOW PLUGINS STATUS;

  Correct Answer: C

• Question 56:

  Which three options are valid reasons for using a primary key in a table?

  A. increasing performance when using select statements

  B. exporting data faster with mysqldump

  C. preventing duplicate keys

  D. to make it easier to change the PRIMARY KEY value

  E. automatic storage of data in a sorted order

  F. maintaining a history of row insertions or updates

  Correct Answer: ABC

• Question 57:

  You are using the innoDB engine and the innodb_f ile_per_table option is set. You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory. What will happen to the inventory table?

  A. The table will be optimized and replicated.

  B. The table will be checked for errors and repaired.

  C. The table storage space will be reduced.

  D. The table statistics will be stored.

  Correct Answer: A

• Question 58:

  Which two statements are correct about MySQL Enterprise Edition?

  A. MySQL configuration can be changed in /etc/lib/myi.cnf.

  B. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

  C. Oracle MySQL Enterprise tools and plugins are available as optional services (installation Feature Pack I/ II).

  D. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

  E. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

  Correct Answer: AC

• Question 59:

  What are Security Lists in Oracle Cloud Infrastructure?

  A. They allow administrators access to applications in the cloud and external servers.

  B. They are user-role designations that assign rights to certain internal users and external users.

  C. They are essentially firewall rules that help control traffic between OCI instances.

  D. Security lists are data encryption levels that control who can see the data.

  E. They contain rules established by HIPAA for securing end-user data.

  Correct Answer: C

• Question 60:

  The MySQL Replication Environment (Master and Slave) is prepared. What two are options for connecting a Java application to the MySQL Master and Slave?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A