How Does Ucertify Oracle 1Z0-883 sample question Work?

It is more faster and easier to pass the Oracle 1Z0-883 exam by using Refined Oracle MySQL 5.6 Database Administrator questuins and answers. Immediate access to the Down to date 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. 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:


Q12. 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:


Q13. Consider typical High Availability (HA) solutions that do not use shared storage. 

Which three HA solutions do not use shared storage? 

A. Mysql Replication 

B. Distributed Replicated Block Device (DRBD) and Mysql 

C. Windows Cluster and Mysql 

D. Solaris Cluster and Mysql 

E. Mysql NDB Cluster 

Answer: A,C,D 


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

A. Mysqlslow 

B. Mysqldumpslow 

C. Mysqlshow 

D. Mysqldump 

E. Mysqlaccess 

Answer:

Reference: http://dev.mysql.com/doc/refman/5.0/en/mysqldumpslow.html 


Q15. 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:


Q16. 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> service mysql safe_exit 

C. Shell> /etc/init.d/mysql stop 

D. Shell> mysqladmin –u root –p shutdown 

E. Mysql> STOP PROCESS mysqld; 

F. Shell> net stop mysql 

G. Shell> nmc mysql shutdown 

Answer: C,D,E 


Q17. A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event. 

The server is configured with: 

You have identified that the DELETE statement to skip has the Global Transaction Identifier (GTID) ‘dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with: 

Mysqlbinlog – exclude-gtides=’ dbbe07da-fe25-11e2-b6c7-0800274aa49e:5’ binlog.00000.2 | mysql 

However all events were skipped instead of just the one deleting the wrong row. 

What is the reason for this? 

A. Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs. 

B. The server keeps track of which GTIDs have already been executed and skips those. 

C. Enforce_gtid_consistency is set to ON. 

D. Gtid_mode must be set to AUTO during point in time recoveries. 

Answer:


Q18. ROW-based replication has stopped working. You investigate the error log file and find the following entries: 

2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can’t find record in ‘t1’, Error_code: 1032; handler error 

HA_ERR_KEY_NOT_FOUND; the event’s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 

2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in ‘t1’ Error_code: 1032 

2013-08-27 14:15:47 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 684 

Why did you receive this error? 

A. The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s 

B. The table definition on the slave -litters from the master. 

C. Multi-threaded replication slaves can have temporary errors occurring for cross database updates. 

D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist. 

Answer:


Q19. A Mysql Server has been running an existing application successfully for six months. 

The my.cnf is adjusted to contain the following additional configuration: 

[mysqld] 

Default-authentication-plugin=sha256_password 

The Mysql Server is restarted without error. 

What effect will the new configuration have in existing accounts? 

A. They will have their passwords updated on start-up to sha256_password format. 

B. They will have to change their password the next time they login to the server. 

C. They are not affected by this configuration change. 

D. They all connect via the secure sha256_password algorithm without any configuration change. 

Answer:

Reference: http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html 


Q20. An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be ”rolled forward” to provide all the latest data. 

The SHOW SLAVE STATUS indicates the following values: 

RELAY_LOG_FILE = hostname-relay-bin.00004 

RELAY_LOG_POS = 1383 

Which command set would make the slave current? 

A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE; 

B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = ‘hostname-relay-bin.00004’ , RELAY_LOG_POS = 1383; 

C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383; 

D. STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE; 

Answer: