1z0-883 by Oracle Actual Free Exam Q&As

Question 1

Which statement is true about FLUSH LOGS command?

A. It requires the RELOAD, FILE, and DROP privileges. B. It flushes dirty pages in the buffer pool to the REDO logs. C. It closes and reopens all log files. D. It closes and sends binary log files to slave servers.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

A. File system snapshots B. Mysqldumpslow C. Mysqlhotcopy D. Mysqldump with - binary-data option E. Mysql Enterprise Backup

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

A general purpose MySQL instance is configured with the following options:
-- log-slow-queries -- long-query-time=,0001 -- log-slow-admin-queries -- general-log -- log-bin -- binlog-format=STATEMENT -- innodb-flush-log-at-trx-commit=1
Which three statements are true?

A. The General Query Log records more data than the Binary Log. B. The General Query Log records more data than the Slow Query Log. C. The binary Log records more data than the General Query Log. D. The Slow Query Log records more data than the Binary Log. E. The Slow Query Log records more data than the General Query Log. F. The Binary Log records more data than the Slow Query Log.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 4

Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data:
'GREEN01020495888331993-12-10/2...'
What should you do to improve the overall performance?

A. Create multiple prefix indexes of differing lengths. B. Redesign the table so that the most commonly searched for string patterns are in their own columns. C. Convert their column to BINARY. D. Convert the column to TEXT and add a fulltext index to the table.

Discussion 0

Correct Answer: D Vote an answer

Question 5

Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?

A. Start the server as usual, and then execute the REPAIR TABLE command. B. Start the server with the - innodb_recover_options option set to FORCE. C. Start the server as usual, and then execute the CHECK TABLE command. D. Start the server with the - innodb_force_recovery option set to a non-zero value.

Discussion 0

Correct Answer: D Vote an answer

Question 6

Consider the query:
Mysql> SET @run = 15;
Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)
FROM iteminformation
WHERE run=@run AND objective='7.1'
GROUP BY objective,stage
ORDER BY stage;

The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.
What is the primary improvement that can be made for this scenario?

A. Add a composite index on (run,objective,stage) to allow the query to fully utilize an index. B. Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations. C. Execute the run_2 index because it has caused a conflict in the choice of key for this query. D. Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes. E. Drop the run_2 index because it has caused a conflict in the choice of key for this query.

Discussion 0

Correct Answer: E Vote an answer

Question 7

Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?

A. Using the statement RESET PERFORMANCE CACHE; B. Restarting Mysql C. Disabling and re-enabling all instruments D. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current; E. Using the statement FLUSH PERFORMANCE CACHE; F. Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

What are three methods to reduce Mysql server exposure to remote connections?

A. Setting -- skip-networking when remote connections are not required B. Using SSL when transporting data over remote networks C. Setting specific GRANT privilege to limit remote authentication D. Setting - mysql_secure_configuration to enable paranoid mode E. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 9

Which three statements describe how the strict SQL mode provides added security?

A. It rejects statements that try to insert out-of-range values B. It rejects queries that produce out-of-range values. C. It rejects dates with zero day or month values. D. It rejects invalid dates. E. It limits the operations that the server can perform.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 10

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:
$ pidof mysqld
$tail - n2 /var/lib.mysql/hostname.err
2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.13-enterprise-commercial-advaced' socket: '/tmp/mysql.sock' port;
3306 Mysql Enterprise Server - Advanced Edition (Commercial)
You attempt to log in as the root user with the following command:
$mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Which statement is true about this scenario?

A. The mysql_install_bd post-installation script used - random-password. B. The local root user must log in with a blank password initially: mysql -u root -p. C. New security measures mean that the mysql_secure_installation script must be run first on all new installations. D. The RPM installation script sets a default password of password for new installations.

Discussion 0

Correct Answer: B Vote an answer

Oracle MySQL 5.6 Database Administrator - 1z0-883 Exam Practice Test