Tips to Pass 1Z0-883 Exam (1 to 10)

Ucertify 1Z0-883 Questions are updated and all 1Z0-883 answers are verified by experts. Once you have completely prepared with our 1Z0-883 exam prep kits you will be ready for the real 1Z0-883 exam without a problem. We have Refresh Oracle 1Z0-883 dumps study guide. PASSED 1Z0-883 First attempt! Here What I Did.

Q1. Consider the Mysql Enterprise Audit plugin. 

The following event detail is found in the audit log: 

<AUDIT_RECORD 

TIMESTAMP=”2013-04-09t01:54:17” 

NAME=”Connect” 

CONNECTION_ID=”3” 

STATUS=”1045” 

USER=”kate” 

PROXY_USER=”” 

HOST=”localhost” 

IP=”” 

DB=””/> 

Which two points can be concluded from the given event? 

A. A connection was blocked by a firewall or a similar security mechanism. 

B. A connection was attempted via socket rather than TCP. 

C. A connection failed because the proxy user privileges did not match the login user. 

D. A connection as the user kate was successful. 

E. A connection failed due to authentication being unsuccessful. 

Answer:


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


Q3. Which three methods will show the storage engine for the Country table? 

A. SHOW CREATE TABLE Country; 

B. SHOW ENGINE Country STATUS; 

C. SHOW TABLE STATUS LIKE ‘Country’; 

D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’; 

E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= ‘Country’; 

Answer: A,D,E 


Q4. Which three are properties of the MyISAM storage engine? 

A. Transaction support 

B. FULLTEXT indexing for text matching 

C. Table and page level locking support 

D. Foreign key support 

E. Geospatial indexing 

F. HASH index support 

G. Table level locking only 

Answer: B,E,G 


Q5. Consider the events_% tables in performance Schema. 

Which two methods will clear or reset the collected events in the tables? 

A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current; 

B. Using the statement RESET PERFORMANCE CACHE; 

C. Using the statement FLUSH PERFORMANCE CACHE; 

D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current; 

E. Disabling and re-enabling all instruments 

F. Restarting Mysql 

Answer: D,E 

Reference: http://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html 


Q6. Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new 

application, which heavily reads and writes data. 

This requires the following config file options: 

Sync_binlog=1 

Innodb_flush_log_at_trx_commit=1 

Innodb_doublewrite=1 

However, this configuration is expected to introduce disk I/O overhead. 

What three changes will reduce disk I/O overheads? 

A. Use of soft links for database directories on the same physical disk 

B. Use of separate directories on the same physical disk for log files and data files 

C. Placement of InnoDB log files and datadir on separate physical disks 

D. Allocation of RAM to the buffer pool such that more of the data can fit in RAM 

E. Use of delay_key_write=ON for batch index update 

Answer: D,E 


Q7. You have forgotten the root user account password. You decide to reset the password and execute the following: 

Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer? 

A. --skip-networking, to prohibit access from remote locations 

B. --reset-grant-tables, to start the server with only the mysql database accessible 

C. --read-only,to set all data to read-only except for super users 

D. --old-passwords, to start Mysql to use the old password format while running without the grant tables 

Answer:


Q8. 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 


Q9. A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. 

Which two will optimize the security of this setup? 

A. Disabling connections from named pipes or socket files (depending on the operating system of the server) 

B. Running the server with – skip-networking specified 

C. Limiting logins to originate from the application server or the server’s subnet 

D. Starting the server with – bind- address=0.0.0.0 specified 

E. Installing Mysql on the application server, and running the database and application on the same server 

F. Enabling and using SSL for connections to the Mysql database 

Answer: E,F 


Q10. What are four capabilities of the mysql client program? 

A. Creating and dropping databases 

B. Creating, dropping, and modifying tables and indexes 

C. Shutting down the server by using the SHUTDOWN command 

D. Creating and administering users 

E. Displaying replication status information 

F. Initiating a binary backup of the database by using the START BACKUP command 

Answer: B,D,E,F