Exam Code: 1z0-882 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Certified Professional, MySQL 5.6 Developer
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-882 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-882 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1z0-882 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1z0-882-exam-dumps.html
Q1. 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
Q2. 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
Q3. Examine this table that contains over two million rows of data:
CREATE TABLE ‘news_feed’ (
.id’bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id’varchar (11) NOT NULL,
.dataline’ datetime NOT NULL,
.headline’ varchar (256) NOT NULL,
.story’ text NOT NULL,.tag varchar (32768) DEFAULT NULL, PRIMARY KEY (‘id’)
KEY ‘dateline’ ( ‘dateline’)
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= ‘2013-01-01’
Which change would show the greatest improvement in the response time of the query?
A. Use the LIKE operator:
SELECT . . .WHERE dateline LIKE ‘2013-10-01&’
B. USE the DATEDIFF function:
SELECT . . . WHERE DATEDIFF (dateline, ‘2013-01-01’) = 0
C. Use numeric equivalents for comparing the two dates:
SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP (‘2013-01-01’)
D. Use a date range comparison:
SELECT . . . WHERE dateline >= ‘2013-01’ and dateline < ‘2013-01-02’
Answer: D
Q4. 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;
Answer: C
Q5. A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?
A. The results are in ascending order.
B. The results are in descending order.
C. The results are in the order inserted.
D. The results are not in a set order.
Answer: C
Explanation: Reference: http://www.postgresql.org/docs/8.2/static/sql-select.html#SQL-ORDERBY
Q6. Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?
A. An error that @ a is undefined
B. A single NULL
C. An empty string
D. The value of GLOBAL variable @ a
Answer: B
Q7. 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/
Q8. 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?
A. ‘Casper’ and ‘ undefined values are inserted into the ‘name’ and gender’ column.
B. The server returns an error indicating that ‘undefined’ cannot be inserted into a column of ENUM type
C. The server returns a warning and the empty string is inserted to the ‘gender’ column.
D. The server returns a warning and the first specified value ,”male” is inserted to the gender column.
Answer: B
Q9. Consider the my_table table with two integer columns, a and b, and the contents as shown; Mysql > SELECT a, b FROM my_table;
1 row in set result of this query? SELECT a—b
FROM my_table;
A. 0
B. 2
C. 4
D. An error message
Answer: A
Q10. 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
