1z0-882 | 10 Tips For Replace 1z0-882 pdf
Q11. 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
Q12. 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
Q13. 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
Q14. 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
Q15. In MYSQL 5.6 you have the table t1: CREATE TABLE t1 (
id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB; There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1; Connection 2> TRUNCATE TABLE t1;
What happens to the TRUNCATE TABLE command in connection 2?
A. It immediately proceeds and causes an implicit commit of the transaction in connection1.
B. It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1 table.
C. It blocks waiting for a metadata lock until the transaction in connection 1 ends.
D. It blocks waiting for a table lock until the transaction in connection 1 ends.
Answer: C
Q16. 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)
Q17. Which Three options describe benefits of using the InnoDB memcached API?
A. Provides a simple, well supported method for accessing and updating data.
B. Provides a total in –memory storage system that eliminates disk1/0 overhead.
C. Bypasses the SQL layer thus avoiding extra processing.
D. Implements a fast caching mechanism to replace the query cache.
E. Provides protection via InnoDB buffers and crash recovery.
Answer: C,D,E
Q18. Which two queries return a value of NULL?
A. SELECT NULL =NULL
B. SELECT NULL is NULL
C. SELECT NULL <= > NULL
D. SELECT 1 > NULL
E. SELECT COUNT (NULL);
Answer: A,D
Q19. 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.
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