It is impossible to pass Oracle 1Z0-883 exam without any help in the short term. Come to Examcollection soon and find the most advanced, correct and guaranteed Oracle 1Z0-883 practice questions. You will get a surprising result by our Leading MySQL 5.6 Database Administrator practice guides.
♥♥ 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
Q11. A MySQL replication slave is set up as follows:
User all InnoDB tables Receives ROW-based binary logs Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find the following entries:
2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653,
Error_code: 1062
2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’
Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_master-bin.000003’ position 496
What are two possible causes for this error to occur?
A. The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.
C. For tables with UNIQUE keys, statement-based replication must be used maintain integrity.
D. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
E. The applications have the SUPER privilege, which allows them to update rows.
Answer: A,E
Q12. Which two options describe how MySQL Server allocates memory?
A. Each thread allocates memory from a global pool.
B. Global memory resources are allocated at server startup.
C. Thread memory is pre-allocated up to thread_cache_size for performance.
D. Each connection may have its own per-thread memory allocations.
Answer: B,D
Q13. In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data.
You then TRUNCATE this table to empty it.
Mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;
mysql> TRUNCATE t1;
Which two methods will restore data to the t1 table?
A. Mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;
B. $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
C. $ mysql – u root – p – h localhost test < /tmp/t1.sql
D. $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
E. Mysql> INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql’;
Answer: A
Q14. You need to replicate a table from a master to a slave. The master and slave copies of the
table will have different number of columns.
Which two conditions must be true?
A. Each extra column in the copy with more columns must not have a default value.
B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave.
C. The slave database cannot have more columns than the master. Only the master database can have more columns.
D. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.
E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.
Answer: A,E
Q15. When backing up a replication slave, which three should also be backed up in addition to data?
A. The master.info and relay.info files
B. The relay log files
C. The relay index file
D. Mysql.slave_master_info table
E. Mysql.slave_relay_log_info table
F. Mysql.slave_worker_info table
Answer: A,B,E
Reference: http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-rawdata.html
Q16. You want a record of all queries that are not using indexes.
How would you achieve this?
A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B. By enabling the Error Log because not using indexes is an error
C. By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D. By enabling the Error Log and using the – log-queries-not-using-indexes option
Answer: C
Reference: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Q17. You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin ‘mysql_clear_password’ connot be loaded: plugin not enabled
What would you run to fix the issue?
A. The mysql client with the – ignore-password-hashing option
B. The mysql_secure_installation script to update server security settings
C. The mysql client with the – enable-cleartext-plugin option
D. The mysql_upgrade script
E. The install plugin command for the mysql_cleartext_password plugin
Answer: C
Reference: http://planet.mysql.com/entry/?id=34077
Q18. Which two are true regarding MySQL binary and text backups?
A. Binary backups are usually faster than text backups.
B. Binary backups are usually slower than text backups.
C. Text backups are human-readable while binary backups are not.
D. Binary backups are not portable across different operating systems.
Answer: C,D
Q19. MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the ‘root’ user, change the datadir location by executing:
Shell> cp –R /var/lib/mysql/data/mysql/
Shell> chown –R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the ‘mysql’ user?
A. MySQL cannot be run as the root user.
B. MySQL requires correct file ownership while remaining secure.
C. MySQL needs to be run as the root user, but file cannot be owned by it.
D. The mysqld process requires all permissions within datadir to be the same.
Answer: B
Q20. Consider the following table:
CREATE TABLE ‘game’ (
‘id’ int (10) unsigned NOT NULL AUTO_INCREMENT,
‘keyword’ varchar (45) DEFAULT NULL,
‘date’ datetime NOT NULL,
PRIMARY KEY (‘id’ , ‘date’),
UNIQUE KEY ‘keyword_idx’ (‘keyword’ , ‘date’)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (TO_DAYS (date) ) (
PARTITION g201301 VALUES LESS THAN (TO_DAYS (‘2013-01-01 00:00:00’) ),
PARTITION g201302 VALUES LESS THAN (TO_DAYS (‘2013-02-01 00:00:00’) ),
PARTITION g201303 VALUES LESS THAN (TO_DAYS (‘2013-03-01 00:00:00’) ),
PARTITION g201304 VALUES LESS THAN (TO_DAYS (‘2013-04-01 00:00:00’) ),
PARTITION gMORES VALUES LESS THAN (MAXVALUE) );
Which method should used to add a new g201305 partition to the table?
A. ALTER TABLE games
REORGANIZE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),
gMORES VALUES LESS THAN (MAXVALUE) );
B. ALTER TABLE games
ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) );
C. ALTER TABLE games
COALESCE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),
gMORES VALUES LESS THAN (MAXVALUE) );
D. ALTER TABLE games
SPLIT PARTITION (gMORES)
INTO
g201305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),
gMORES VALUES LESS THAN (MAXVALUE) );
E. ALTHER TABLE games
DROP PATITION gMORES,
ADD PARTITION
g201305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),
gMORES VALUES LESS THAN (MAXVALUE) );
Answer: B
