Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 1:

  Which three options describe the setup of MySQL High Availability solutions?

  A. Setting up three machines configured as follows: Machine A with 2 x Data Nodes Machine B with 2 x mysqld node Machine C with 2 x ndb_mgmd node
  B. setting up Master and Slave with MySQL Semi-Sync Replication Plugin
  C. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir
  D. setting up three machines configured as follows: Machine 1: Data Node and mysqld node Machine 2: Data Node and mysqld node Machine 3: ndb_mgmd
  E. providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover
  C. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir
  D. setting up three machines configured as follows: Machine 1: Data Node and mysqld node Machine 2: Data Node and mysqld node Machine 3: ndb_mgmd
  E. providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover

• Question 2:

  MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics?

  A. All MySQL (when MySQL connectors with Aggregator is used for the application)
  B. MySQL 5.5.9 (and later)
  C. MySQL 5.7.9 Community (and later)
  D. MySQL 5.6.14 Commercial (and later)
  E. All MySQL (with MySQL Enterprise Monitor Proxy)
  B. MySQL 5.5.9 (and later)
  C. MySQL 5.7.9 Community (and later)
  D. MySQL 5.6.14 Commercial (and later)
  E. All MySQL (with MySQL Enterprise Monitor Proxy)

• Question 3:

  A MySQL installation has the following required architecture components: client programs, MySQL utilities, and MySQL Server.

  Which client program would you use to emulate client load?

  A. mysqlslap
  B. mysqlshow
  C. mysqlimport
  D. mysqlcheck
  E. mysqladmin
  A. mysqlslap

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html

• Question 4:

  You want to access your MySQL Cloud Service cloud environment from an external application based on ODBC. What are the required steps?

  A. Enable ora_p2admin_mysql, which opens port 3306 on the Access Rules tab.
  B. Enable SSH tunnel and access MySQL based on TCP/IP over SSH.
  C. Access to the OS (SSH) and MySQL (3306) are open by default.
  D. Switch to the Compute Cloud Service Dashboard and disable reject:*.public-internet
  E. Create a new SSH key for your ODBC connector.
  B. Enable SSH tunnel and access MySQL based on TCP/IP over SSH.

• Question 5:

  What are security rules in Compute Cloud Service?

  A. They allow administrators access to applications in the cloud.
  B. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.
  C. They are user-role designation that assign rights to certain users.
  D. Security rules are data encryption levels that control who can see the data.
  E. These are rules established by HIPAA for securing end-user data.
  B. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.

  ---

  Reference: https://docs.oracle.com/cloud/latest/computecs_common/OCSUG/GUID-630622EC-160B-4523-88AD-F7B46463A0BE.htm#OCSUG145

• Question 6:

  Which command would you use to create a user named jenny for the localhost server with the hashed password SecretPass123!?

  A. CREATE USER `jenny'@localhost' IDENTIFIED WITH HASH PASSWORD (`SecretPass123!');
  B. CREATE USER `jenny'@localhost' IDENTIFIED BY SHA (`SecretPass123!', `256');
  C. CREATE USER `jenny'@localhost' WITH HASHED (password, `SecretPass123!');
  D. CREATE USER `jenny'@localhost' IDENTIFIED WITH sha_256PASSWORD by `SecretPass123!';
  B. CREATE USER `jenny'@localhost' IDENTIFIED BY SHA (`SecretPass123!', `256');

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/adding-users.html

• Question 7:

  Which three statements describe MySQL Cloud Service Backup?

  A. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Storage Service.
  B. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
  C. MySQL Cloud Service offers backup based on Oracle RMAN with optimized row locking.
  D. MySQL Cloud Service Backup is an optimized backup based on mysqldump with optimized row locking.
  E. MySQL Cloud Service Backup provides the point-in-time recovery functionality.
  C. MySQL Cloud Service offers backup based on Oracle RMAN with optimized row locking.
  D. MySQL Cloud Service Backup is an optimized backup based on mysqldump with optimized row locking.
  E. MySQL Cloud Service Backup provides the point-in-time recovery functionality.

• Question 8:

  Your customer wants you to install and configure MySQL on the customer's Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.

  What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer's requirement?

  A. The configuration datadir=/app/mysql/data is needed.
  B. The configuration basedir=/app/mysql/bin is needed.
  C. The configuration log-bin=/app/data is needed.
  D. The configuration datadir=/app/data is needed.
  E. The configuration innodb_log_group_home_dir=/datadir is needed.
  F. The configuration basedir=/app/mysql is needed.
  B. The configuration basedir=/app/mysql/bin is needed.
  D. The configuration datadir=/app/data is needed.

• Question 9:

  When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

  A. admin, ora-cloud, and oracle
  B. administrator, opc, and oracle
  C. root, opc-administrator, and oracle through sudo
  D. cloud-admin, oracle, and root
  E. opc, oracle, and root (through sudo)
  E. opc, oracle, and root (through sudo)

• Question 10:

  You have a text file named "xyz.csv" exported from another system.

  

  You are asked to import data to a MySQL Database table named "country". The table definition is as follows:

  

  Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

  A. Use the LOAD DATA INFILE syntax to load data into the database table.
  B. Use mysqlimport to load the mycountry.csv data file with the --csv option specified.
  C. Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv.
  D. Convert the data into MDI and restore the MySQL data from it.
  A. Use the LOAD DATA INFILE syntax to load data into the database table.