Candidates for 1Z0-882 might be gaining utilizing current technological know-how for Oracle items as well as with its answers and as such your people are usually secured utilizing fine job opportunities. Effective 1Z0-882 people might be gaining any responsible participant while in the Oracle organization in among the grounds (may be while in the revenue niche maybe in the info modern technology niche). Since successful 1Z0-882 people are increasingly becoming any responsible participant while in the organization, they can find honor on the corporation and also they might be gaining testimonials in outlining regarding the current Oracle technological know-how and the ways of the co-workers.

2017 Jan 1Z0-882 pdf exam

Q61. Your application is running slow. 

Which two features provide information that help to identify problems? 

A. The MYSQL error log 

B. The slow query log 

C. The performance schema 

D. The GET DIAGNOSTICS statement 

Answer: B,C 


Q62. 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 


Q63. ... 

When working with stored routines, these details are available: 

The affected –rows count 

The number of conditions that occurred 

The condition information, such as the error code and message 

Where can you find these default? 

A. In the Handler area, defined in the DECLARE handler_action HANDLER block in a stored routine 

B. In the Signal area, which is set with the help of the SIGNAL statement in a stored routine 

C. In the Diagnostics area, part, of which can be stored in user-defined or routine variables 

D. In the Error area, which can be accessed with the help of the SHOW ERRORS statement 

Answer:


Rebirth 1Z0-882 book:

Q64. Consider the query and its output: 

Mysql> SELECT Language As Lang FROM countrylanguage 

->WHERE countrycode =’GBR’; 

A user wants to have an output as shown: 

What query would achieve this? 

A. SELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE countrycode= ‘GBR’; 

B. SELECT GROUP_CAT(Language) As Lang FROM countrylanguage WHERE countrycode=’GBR’; 

C. SELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE countrycode=’GBR’; 

D. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode=’GBR’; 

Answer:

Reference:http://dcsg.bcs.org/sites/default/files/mysql-certification-41addendum_0.pdf(page 32, 1.9.) 


Q65. You create a new,empty database called ‘test’. You want to change the database ‘s CHARACTER SET to “latin1” and the database ‘sCOLLATION to ‘latin_german_ci’. 

Which statement is true? 

A. You can do this one command: 

ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci 

B. You can only do this with two separate commands: 

ALTER DATABASE ‘test’ CHARACTER SET latin1 

ALTER DATABASE ‘test’ COLLATE latin_german1_ci 

C. You cannot change the CHARACTER set or COLLATION value on an existing 

database. 

D. Databases do not have CHARACTER SET or COLLATION attributes. 

Answer:


Q66. 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? 

A. (0,0,0) and (0,0,0) 

B. (0,0,0,) and (0,200,300) 

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

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

Answer:


Q67. Which three database objects have non-case-sensitive names on all operating system? 

A. Table 

B. Column 

C. Index 

D. Stored procedure 

E. Trigger 

Answer: A,B,C