Pass4sure offers free demo for 1z0-882 exam. "Oracle Certified Professional, MySQL 5.6 Developer", also known as 1z0-882 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0-882 exam, will help you answer those questions. The 1z0-882 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0-882 exams and revised by experts!
Q17. A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.
You execute this query:
SELECT col1 FROM t1 WHERE col1< 100 UNION
SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200
UNION ALL
SELECT col1 FROM t1 WHERE col 1 >=900
What is the output?
A. A list of unique values within the ranges of 1-200 and 900-1000
B. A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the range of 900-1000
C. A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000
D. A list of all values, including duplicates, in the ranges of 1-200 and 900-1000
E. An error, because mixing UNION and UNION ALL in the same query is not permitted
Answer: C
Q18. Consider the structure of the table countryLanguage and the distribution of the column Is official.
DESCRIBE CountryLanguage;
SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;
You add an index on the Isofficial column. Which two statement are true?
A. The optimizer will choose the index when Isofficial=’T’ is in the WHERE clause.
B. The optimizer will choose the index when Isofficial=’F’ is in the WHERE clause.
C. The optimizer will not choose the index on the Isofficial column.
D. The speed of INSERT statements to this table will be improved.
E. The speed of INSERT statements to this table will be reduced.
F. The speed of INSERT statements to this table will be unchanged.
Answer: C,E
Q19. Assume that none of the databases exist. Which statement results in an error?
A. CREATE DATABASE $test
B. CREATE DATABASE 1$
C. CREATE DATABASE $
D. CREATE DATABASE _
E. CREATE DATABASE 12
Answer: A
Q20. Which statement describes the process of normalizing databases?
A. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
B. Redundant tables are combined into one larger table to simplify the schema design.
C. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
D. Columns that contain repeating data values are split into separate tables to reduce item duplication.
E. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.
Answer: D
Q21. Which condition must be true in order that a view is considered updateable?
A. The user must have the UPDATE or DELETE privilege for the underlying table.
B. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.
C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.
D. The view must only refer to literal values.
Answer: C
Explanation: Reference:http://dev.mysql.com/doc/refman/5.0/en/view-updatability.html(first para)
Q22. 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
Answer: A
Explanation: Reference:http://justalittlebrain.wordpress.com/2010/09/15/you-are-using-safe-update-mode-and-you-tried-to-update-a-table-without-a-where-that-uses-a-key-column/
Q23. Given the data:
Expected output:
Which query produces the expected output?
A. SELECT colors2.name, colors1.name FROM colors2
OPTIONAL JOIN colors1
ON colors2.name, colors1.name
B. SELECT colors2.name, colors1.name FROM colors2
NATURAL JOIN colors1
ON colors2.name=colors1.name
C. SELECT colors2.name, colors1.name FROM colors2
STRAIGHT JOIN colors1
ON colors2.name, =colors1.name
D. SELECT colors2.name,colors1.name FROM colors2
LEFT JOIN colors1
ON colors2.name=colors1.name
E. SELECT colors2.name,colors1.name FROM colors2
RIGHT JOIN colors1
ON colors2.name=colors1.name
Answer: E
Q24. Which three statement types can be prepared?
A. LOAD DATA INFILE
B. CREATE TABLE
C. CREATE VIEW
D. ALTER VIEW
E. CALL
Answer: B,C,E
Explanation: http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-prepared-statements.html