Free Oracle 1z1-320 Exam Dumps Questions & Answers

Your system is being swamped by business users running multiple ad hoc queries. What is a valid way to limit the resources for a particular user?

• A.  MAX_QUERY_SIZE
• B.  MAX_CONNECTIONS
• C.  CONNECTIONS_PER_HOUR
• D.  MAX_UPDATES_PER_DAY
• E.  MAX_QUERIES_PER_HOUR

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.

• A.  Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• B.  On the Master server, disable binlog by removing the - - log -bin option.
• C.  To safely purge binary log files, perform the following steps:1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
• D.  Execute the PURGE BINARY LOGS statement without argument.
• E.  Delete all binlog files manually on the file system to release storage spaces.

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A.  INSERT INTO City_part SELECT * FROM City;
• B.  CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
• C.  CREATE TABLE City_part LIKE City;
• D.  CREATE TABLE City_part AS SELECT * FROM City;

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.  mysqlimport
• B.  mysqlslap
• C.  mysqlshow
• D.  mysqlcheck
• E.  mysqladmin

You want to monitor SQL statements, which are executed on the MySQL server, in MySQL Enterprise Monitor (MEM).
Select three possible ways.

• A.  Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager.
• B.  Configure the MySQL Router to send normalized SQL statements to MEM.
• C.  Route MySQL SQL statements through a MySQL Monitor Proxy.
• D.  Configure MySQL to replicate data via the MySQL binlog to MEM.
• E.  Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later.