Pass 1z0-882 Exam Guide

Oracle Certified Professional, MySQL 5.6 Developer Questions and Answers

Question 5

Which three statement types can be prepared?

Options:

LOAD DATA INFILE

CREATE TABLE

CREATE VIEW

ALTER VIEW

CALL

Question 6

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?

Options:

(0,0,0) and (0,0,0)

(0,0,0,) and (0,200,300)

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

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

Question 7

You started a MySQL command –line session with sq1_ mode (empty), and created the person table with the structure:

Mysql> DESC person;

You issue:

INSERT INTO person VALUES (‘casper’, ‘undefined’)

What is the effect?

Options:

‘Casper’ and ‘ undefined values are inserted into the ‘name’ and gender’ column.

The server returns an error indicating that ‘undefined’ cannot be inserted into a column of ENUM type

The server returns a warning and the empty string is inserted to the ‘gender’ column.

The server returns a warning and the first specified value ,”male” is inserted to the gender column.

Question 8

The people table contains the data as shown:

Which two statements return two rows each?

Options:

SELECT DISTINCT last_name, first_name FROM people

SELECT 1,2 FROM people GROUP BY last_name

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

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

SELECT first _name, last_name FROM people LIMIT 1, 2

Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Certified Professional, MySQL 5.6 Developer Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce