Breathing of 1Z0-883 download materials and preparation for Oracle certification for IT professionals, Real Success Guaranteed with Updated 1Z0-883 pdf dumps vce Materials. 100% PASS MySQL 5.6 Database Administrator exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-883 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-883 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-883-exam-dumps.html
Q1. Which two capabilities are granted with the SUPER privilege?
A. Allowing a client to kill other client connections
B. Allowing a client to shut down the server
C. Allowing change of the server runtime configuration
D. Allowing client accounts to take over the account of another user
Answer: A,B
Reference: http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html
Q2. 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: C
Q3. 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: C
Q4. You have table ‘apps’,’userdata’ on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead.
You execute the following commands:
ServerB commands:
Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps
Shell> mysql –u root –p –h server –e ‘ALTER TABLE ‘apps’,’userdata’ ENGINE=InnoDB;’
Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps
What effect does the – order-by-primary argument have on the mysqldump command?
A. It exports tables with the most indexes first to assist with import speeds.
B. It ensures that unique indexes have no conflicts when the data is dumped.
C. It orders by primary key to assist in speeding up importing to InnoDB tables.
D. It must be specified so index data is dumped correctly when –on-create-info is used.
Answer: C
Q5. What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?
A. Mysql Enterprise Backup
B. Mysqldump with – binary-data option
C. Mysqlhotcopy
D. File system snapshots
E. Mysqldumpslow
Answer: A,B
Reference: http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html
Q6. Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?
A. Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
B. Check the command-line options provided for the Mysql Server and compare them with default values.
C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
D. Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
Answer: C
Q7. User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A. UPDATE pets…
B. SELECT….FROM pets
C. INSERT INTO pets…
D. ALTER TABLE pets…
Answer: B
Q8. A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database:
'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') '
Skip_Counter: 0
Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8
Auto _Position: 1
You execute a “SHOW CREATE TABLE mytable” on the slave:
CREATE TABLE ‘mytable’ (
‘ID’ int(11) NOT NULL DEFAULT ‘0’,
‘name’ char(10) DEFAULT NULL,
PRIMARY KEY (‘ID’)
)
The table mytable on the slave contains the following:
You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.
Which statement should be used?
A. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
B. SET GTID_NEXT=”CONSISTENCY”;
BEGIN; COMMIT;
SET GTID_NEXT=” AUTOMATIC’;
C. SET GLOBAL enforce_gtid_consistency=ON
D. SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
E. SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;
Answer: A
Q9. You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl’
What is the cause of the error?
A. The --- ssl level was not specified.
B. The server was not started with the – enable--ssl-plugin option.
C. -- ssl is not a valid server option.
D. The mysqld binary was not compiled with SSL support.
E. The server’s SSL certificate was invalid.
Answer: B
Q10. What are three actions performed by the mysql_secure_installation tool?
A. It prompts you to set the root user account password.
B. It checks whether file permissions are appropriate within datadir.
C. It asks to remove the test database, which is generated at installation time.
D. It can delete any anonymous accounts.
E. It verifies that all users are configuration with the longer password hash.
Answer: A,C,D
Reference: http://prefetch.net/blog/index.php/2006/06/18/securing-mysql-installations-with-mysql_secure_installation/