1Z0-882 Online Practice Questions and Answers

The application logs contain many entries of the following:

ERROR 1153 (OSSO1): Got a packet bigger than `max_allowed_packet' bytes With two scenarios can

(Hibernate this error message?

A. The application tried to INSERT a row that exceeded max_allowed_packet.

B. The network caused an error Inducing the max_allowed_packet error.

C. The application did not use the COMPRESS () function for a large result set.

D. The application tried to SELECT many rows together that exceeded max__allowed_packet.

E. The application tried to SELECT a row that exceeded max_allowed_packet.

F. The operating system caused an error inducing the max_allowed_packet error.

The data from t1 table is:

Assuming You want to see this output: Which query achieves the preceding result?

A. SELECT name FROM t1 WHERE name LIKE ,_e%

B. SELECT name FROM t1 WHERE name LIKE,e%.;

C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;

D. SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

Which three are valid identifiers for the user table in the mysq1 database?

A. myssq1. user

B. `mysq1. user'

C. `mysq1'. `user'

D. Mysq1. `user'

E. `'mysq1. User''

Which three connector/J connection strings can be used to connect to the MYSQL server?

A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx

B. Jdbc :mysqli://localhost/test?user=xxxandpassword=xxx

C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx

D. Jdbc:mysql:proxy://localhost/test?user=xxxandpassword=xxx

E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx

Inspect the query:

Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE

dept_no'd004';

4 rows in set (0.00 sec)

Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004';

2 rows in set (0.00 sec)

Which two statements are true about the EXPLAIN output?

A. All data for the result is read from the indexex.

B. The PRIMARY KEY is used for filtering in both tables.

C. The minimal number of rows possible are read.

D. The dept_manager table has 4 times as many rows than the employees table.

Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN). Which query would you use?

A. SELECT UPPER (Location) as location FROM MemberLocation

B. SELECT UPPER (BINARY location) as location FROM MemberLocation

C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation

D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation

Consider the content of the class and student tables: Class

Which three queries produce the same result?

A. SELECT * FROM class INNER JOIN student ON class.class_id=student.class_id

B. SELECT * FROM JOIN student LEFT JOIN student ON class. Class.class_id=student.class_id

C. SELECT * FROM class INNER JOIN student WHERE NOT ISNULL (student.class_id)

D. SELECT * FROM JOIN student On class .class_id=student.class_id WHERE NOT ISNULL (student.class_id)

E. SELECT * FROM student RIGHT JOIN class ON class.class_id=student.class_id

Consider the stored procedure

CREATE PROCEDURE param_test (

IN P_in INT,

OUT P_out INT,

INPUT P_inout INT)

BEGIN

SELECT P_in, P_out, P_ inout;

SET P_in, P_inout

END

You execute a series of commands:

What is the output of the CALL and SELECT?

A. (0,0,0) and (0,0,0)

B. (0,0,0,) and (0,200,300)

C. (0,NULL,0) and(0,200,300)

D. (0,NULL,0) and (100,200,300)

Inspect the SELECT query:

Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11';

2 rows in set (0.00 sec) Which action will optimize the query?

A. Add an index to the employees. emp _no column.

B. Add the keyword STRAIGHT_JOIN.

C. Add an index on the to_ date column.

D. Add the FORCE INDEX (PRIMARY) optimizer hint for the employees table.

A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0

What happens when you execute an UPDATE statement without a WHERE clause?

A. Results in an error

B. Updates every row in the specified table(s)

C. Results in - -safe-updates being enabled automatically

D. Causes a syntax error