Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 71:

  You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries.

  Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user `employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

  A. Set Max Updates to 4 for `employee1'.
  B. Set Max. Queries to 14 for `employee1'.
  C. Set Max. Connections to 14 for `employee1'.
  D. Set Max. Queries to 10 for `employee1'.
  E. Set Concurrent Connections to 14 for `employee1'.
  C. Set Max. Connections to 14 for `employee1'.
  D. Set Max. Queries to 10 for `employee1'.

• Question 72:

  The MySQL server looks for option files in standard locations. The server might read multiple files from different locations. For a Linux installation, which two methods would you use to view the options file lookup locations, the order in which they are read, and groups?

  A. $ mysql - - print-defaults
  B. SHOW GLOBAL VARIABLES;
  C. $ mysqld - -help - -verbose | grep-A1 "Default options"
  D. $ mysqld --help
  C. $ mysqld - -help - -verbose | grep-A1 "Default options"
  D. $ mysqld --help

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/option-files.html

• Question 73:

  Which three features are available only on MySQL Enterprise Workbench?

  A. GUI for MySQL Enterprise Backup
  B. MySQL Audit Log Inspector
  C. Database Design
  D. Database Migration inclusive Support
  E. Visual Performance Dashboard
  A. GUI for MySQL Enterprise Backup
  B. MySQL Audit Log Inspector
  C. Database Design

  ---

  Reference: https://www.mysql.com/products/workbench/features.html

• Question 74:

  Which three statements are true about MySQL Enterprise Backup?

  A. It cannot backup encrypted tablespaces.
  B. It provides the ability to create incremental backups.
  C. It performs hot or warm backups.
  D. It performs logical backups.
  E. It enables you to take non-locking backups.
  B. It provides the ability to create incremental backups.
  D. It performs logical backups.
  E. It enables you to take non-locking backups.

• Question 75:

  Which three are part of the core MySQL architecture? (Choose three.)

  A. Parser
  B. mysqldump
  C. Disk parity/RAID
  D. Optimizer
  E. Storage engines
  B. mysqldump
  D. Optimizer
  E. Storage engines

• Question 76:

  Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

  A. mysqlrplcheck
  B. mysqlrplms
  C. mysqlrpladmin
  D. mysqlreplicatems
  E. mysqlreplicate
  B. mysqlrplms

  ---

  Reference: https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlrplms.html

• Question 77:

  Identify three characteristics of the JSON data type.

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

• Question 78:

  When creating a FOREIGN KEY constraint, what SQL variable must be specified?

  A. UNIQUE PRIMARY KEY values for both child and parent tables
  B. a REFERENCE in the child table to the parent table
  C. the SET_FOREIGN_KEY variable in the my.cnf file
  D. an INDEX on the FOREIGN KEY
  E. a TRIGGER on the child table for cascading DELETE statements
  E. a TRIGGER on the child table for cascading DELETE statements

  ---

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints

• Question 79:

  Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

  A. Email
  B. SMS
  C. Notification tab on the dashboard
  D. Browser pop-ups
  E. Direct support call from an Oracle representative
  A. Email
  B. SMS
  C. Notification tab on the dashboard

• Question 80:

  For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

  A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.
  B. Convert the private key to ppk format first, and use the new private key for authentication.
  C. Use the provided private key for authentication.
  D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
  D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.