Note! Following 1z0-882 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-882 Exam Dumps - Oracle Certified Professional - MySQL 5.6 Developer

Go to page:

Question # 4

A statement exists that can duplicate the definition of the â€˜worldâ€™table.

What is missing?

CREATE TABLE t1 ___________world

FROM

USING

COPY

Full Access

Question # 5

Inspect the query:

Mysql> SELECT count (emp_no) FROM titles WHERE title = â€˜senior staffâ€™;

How can this query be optimized?

The query need an index on the emp-no column.

The query cannot be optimized as an index is already used.

The query needs an index that includes the title column.

The query cannot be optimized as count () must read all rows.

Full Access

Question # 6

Assume your connection uses SQL mode ANSI_QUOTES.

Which two statements cause a syntax error?

CREATE TABLE FRIENDS (NAME CHAR (10))

CREATE TABLE BINARY (PRIMARY SMALLINT)

CREATE TABLE â€˜TABLEâ€™ (COLUMNâ€™ INTEGER)

CREATE TABLE â€œCONDITIONâ€ (â€œDESCRIBEâ€ TEXT)

CREATE TABLE INTERVAL (ELAPSED_TIME TIME)

Full Access

Question # 7

A table (t1) contains 1000 random integer values in the first column (col1).The random values are in the range of 0-1000.

Examine this query:

SELECT col1 FROM t1 WHERE col1 <=100 UNION

SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC

What is the expected output?

A list of all values, including duplicates, sorted in descending order in the ranges of 0-100 and 900-1000

A list of all random unsorted values, including duplicates, in the range of 0-100 followed by the list of all values, including in the range of 900-1000 sorted in descending order

A list of unique random values in the range of 0-100 followed by the list of unique values in the range of 900-1000 sorted in descending order

A list of all unique values sorted in descending order within the ranges of 0-100 and 900-1000

Full Access

Question # 8

You wish to create a trigger on the â€˜cityâ€™ table that will check the value of the â€˜Districtâ€™ field before any INSERT. The trigger needs to change it toâ€ Unknownâ€ for an empty string or NULL.

CREATE TRIGGER City_bi

BEFORE INSERT ON CITY

FOR EACH ROW

BEGIN

IF OLD. District IS NULL OR OLD.District= . .

THEN

SET NEW.District=â€™Unknownâ€™;

END IF :

END;

Does the CREATE TRIGGER statement accomplish this goal?

Yes; the trigger works correctly.

No; FOR EACH ROW is invalid syntax.