It is more faster and easier to pass the Oracle 1Z0-883 exam by using Guaranteed Oracle MySQL 5.6 Database Administrator questuins and answers. Immediate access to the Most recent 1Z0-883 Exam and find the same core area 1Z0-883 questions with professionally verified answers, then PASS your exam with a high score now.

Q11. You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. 

C: \> mysqld – install Mysql56 – defaults – file = C : \my –opts.cnf 

What is the expected outcome? 

A. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file. 

B. Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file 

C. An error message is issued because – install is not a valid option for mysqld. 

D. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf. 

Answer:


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

A. The error log 

B. The backup log 

C. The general query log 

D. Binary logs 

E. The data backup 

F. Configuration files 

Answer: D,E,F 


Q13. You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error: 

mysql> CALL film_in_stock (40, 2, @count); 

ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does not exist 

How would you identify all stored procedures that pose the same problem? 

A. Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;. 

B. Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’. 

C. Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER=’bob@localhost’;. 

D. Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’ and HOST=’ localhost’;. 

E. Examine the Mysql error log for other ERROR 1449 messages. 

Answer:


Q14. An employee cannot access the company database. You check the connection variables: Mysql> SHOW GLOBAL VARIABLES LIKE ‘%connect%’; 

8 rows in set (0.00 sec) 

A look at the user privileges shows: 

GRANT… TO ‘bob’@’%, example.com’ WITH MAX_USER_CONNECTIONS 0; 

GRANT… TO ‘key’@’%, example.com’ WITH MAX_USER_CONNECTIONS 1; 

GRANT… TO ‘joe’@’%, example.com’ WITH MAX_USER_CONNECTIONS 50; 

What is a valid explanation for why one of the users is unable to connect to the database? 

A. Bob has max_user_connections set to zero, which blocks all his connections 

B. Joe has exceeded the max_user_connections global limit. 

C. All users are blocked because max_user_connections is accumulated over the host account information. 

D. Kay is already connected elsewhere and attempting to log in again. 

E. Connect_timeout is too small to allow a connection to occur. 

Answer:


Q15. Consider the following statement on a RANGE partitioned table: 

ALTER TABLE orders DROP PARTITION p1, p3; 

What is the outcome of executing the above statement? 

A. Only the first partition (p1) will be dropped as only one can be dropped at any time. 

B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged. 

C. A syntax error will result as you cannot specify more than one partition in the same statement. 

D. All data in pi and p3 partitions are removed and the table definition is changed. 

Answer:

Reference: http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67772/partiti.htm 


Q16. You are using replication and the binary log files on your master server consume a lot of disk space. 

Which two steps should you perform to safely remove some of the older binary log files? 

A. Ensure that none of the attached slaves are using any of the binary logs you want to delete. 

B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files. 

C. Execute the PURGE BINARY LOGE NOT USED command. 

D. Remove all of the binary log files that have a modification date earlier than today. 

E. Edit the .index file to remove the files you want to delete. 

Answer:


Q17. You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. 

Why is it important to remove snapshots after completing a RAW backup in this way? 

A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup. 

B. The snapshot size will continue to grow as changes to the volume are made. 

C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data. 

D. The system keeps a copy of changes in memory and can cause an out of memory event. 

Answer:


Q18. Consider the Mysql Enterprise Audit plugin. 

You are checking user accounts and attempt the following query: 

Mysql> SELECT user, host, plugin FROM mysql.users; 

ERROR 1146 (42S02): Table ‘mysql.users’ doesn’t exist 

Which subset of event attributes would indicate this error in the audit.log file? 

A. NAME=”Query” 

STATUS=”1146” 

SQLTEXT=”select user,host from users”/> 

B. NAME=”Error” 

STATUS=”1146” 

SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/> 

C. NAME=”Query” 

STATUS=”1146” 

SQLTEXT=” Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/> 

D. NAME=”Error” 

STATUS=”1146” 

SQLTEXT=”select user,host from users”/> 

E. NAME=”Error” 

STATUS=”0” 

SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/> 

Answer:


Q19. Which statement is true about FLUSH LOGS command? 

A. It requires the RELOAD, FILE, and DROP privileges. 

B. It closes and reopens all log files. 

C. It closes and sends binary log files to slave servers. 

D. It flushes dirty pages in the buffer pool to the REDO logs. 

Answer:

Reference: http://dev.mysql.com/doc/refman/5.5/en/flush.html 


Q20. Which statement is true about the log-output variable? 

A. It is a static variable and can be set only at MySQL server startup. 

B. It enables and starts the General Query Log. 

C. It sets the target location for the binary logs generated by the MySQL sever. 

D. It specifies output destinations for the slow and General Query logs. 

Answer: