1z1-883 by Oracle Valid Free Exam Practice Test

Question 1

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?

A. FLUSH HOST CACHE; B. CREATE USER 'admin' @'%'; C. UPDATE mysql.user SET Create_user_priv = 'Y' WHERE user= 'admin'; D. GRANT USAGE ON *.* TO 'admin'@'%'; E. FLUSH PRIVILEGES;

Correct Answer: E

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

Question 2

You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?

A. Shell> pkill -u mysql mysqld_safe B. Shell> net stop mysql C. Mysql> STOP PROCESS mysqld; D. Shell> nmc mysql shutdown E. Shell> /etc/init.d/mysql stop F. Shell> mysqladmin -u root -p shutdown G. Shell> service mysql safe_exit

Correct Answer: B,E,F

Question 3

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

A. Mysqlaccess B. Mysqldump C. Mysqlslow D. Mysqldumpslow E. Mysqlshow

Correct Answer: D

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

Question 4

Which two statements are true about InnoDB auto-increment locking?

A. The auto-increment lock can be a table-level lock. B. InnoDB never uses table-level locks. C. InnoDB does not use locks to enforce auto-increment uniqueness. D. InnoDB always protects auto-increment updates with a table-level lock. E. Some settings for innodb_autoinc_lock_mode can help reduce locking.

Correct Answer: A,D

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

Question 5

Which three are properties of the MyISAM storage engine?

A. Table level locking only B. Foreign key support C. Transaction support D. FULLTEXT indexing for text matching E. Table and page level locking support F. HASH index support G. Geospatial indexing

Correct Answer: A,D,G

Question 6

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

Correct Answer: D

Question 7

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

A. -- quick B. -- skip-buffer C. -- tab D. -- single-transaction

Correct Answer: A

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

Question 8

Which two options describe how MySQL Server allocates memory?

A. Thread memory is pre-allocated up to thread_cache_size for performance. B. Each connection may have its own per-thread memory allocations. C. Global memory resources are allocated at server startup. D. Each thread allocates memory from a global pool.

Correct Answer: B,C

Question 9

Which three data components are needed for point-in-time recovery?

A. The data backup B. Configuration files C. The general query log D. The error log E. Binary logs F. The backup log

Correct Answer: A,B,E

Question 10

Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?

A. 12; only top-level statements and stored procedure events are logged. B. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event. C. 111; top-level statements and all lower-level statements are logged. D. 3; only the top-level statements are logged.

Correct Answer: D

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

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