Tested of 1z0-882 download materials and ebook for Oracle certification for examinee, Real Success Guaranteed with Updated 1z0-882 pdf dumps vce Materials. 100% PASS Oracle Certified Professional, MySQL 5.6 Developer exam Today!

Q21. The people table contains the data as shown:

Which two statements return two rows each?

A. SELECT DISTINCT last_name, first_name FROM people

B. SELECT 1,2 FROM people GROUP BY last_name

C. SELECT first_name, last _name FROM people WHERE age LIKE ‘2’

D. SELECT 1, 2 FROM people WHERE last _name =’smith’

E. SELECT first _name, last_name FROM people LIMIT 1, 2

Answer: C,E


Q22. In the office table, the city column is structured as shown: Mysql> show columns from office like ‘city’G

•••---------------------------------------------------1. row ---------------------  

Field: city

Type: enum(‘paris’.’Amsterdam’.’New York’.’Tokyo’) Null: Yes

Key: Default:NULL Extra:

Consider the output of the SELECT query executed on the office table: Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:

SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR)

In what order are the rows returned?

A. Paris, Amsterdam. New York, Tokyo

B. Tokyo, New York, Amsterdam, Paris

C. Amsterdam, New York, Paris, Tokyo

D. Tokyo, Paris, New York, Amsterdam

Answer: C


Q23. Which two keywords cannot be used in multi-table deletes?

A. USING

B. ORDER BY

C. LIMIT

D. IGNORE

E. JOIN

Answer: B,C

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

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE.


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

Answer: C


Q25. Which three database objects have non-case-sensitive names on all operating system?

A. Table

B. Column

C. Index

D. Stored procedure

E. Trigger

Answer: A,B,C


Q26. Consider a table my_table , with contents shown:

You execute: SELECT a b, b a

FROM my_table WHERE a < s ORDER BY b;

What does this statement return?

A. Option A

B. Option B

C. Option C

D. Option D

Answer: A


Q27. Inspect the CREATE TABLE below:

Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;

Query Ok, 0 rows affected, 2 warnings (0.11 sec) Mysql> SHOW WARNINGS;

Which two is true connecting the meaning of the warnings?

A. The InnoDB storage engine was disabled during server startup.

B. Global variable skip _innodb was set to ON after the server had started.

C. The default storage engine MYISAM was used for the table created.

D. MYSQL server was not started with the option default –storage –engine=InnoDB

E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB

Answer: D,E


Q28. Which statement correctly demonstrates using a subquery as a scalar expression?

A. SELECT (

SELECT SUM (population) FROM Country

SELECT SUM (population) FROM Country

WHERE Code =’CAN’

)

B. SELECT SUM (population) FROM Country

WHERE Code =”USA”

+ (SELECT SUM (population) FROM Country

WHERE Code =.’CAN’

)

C. SELECT

(SELECT SUM (population) FROM Country

WHERE Code =’USA’

FROM country WHERE Code= ‘CAN’

)

D. (SELECT SUM (population) FROM Country

WHERE Code =”USA’

Answer: D

Explanation: Reference:http://dev.mysql.com/doc/refman/5.0/en/scalar-subqueries.html