Oracle 1z0-882 問題集

質問 1：
Your application is running slow.
Which two features provide information that help to identify problems?
A. The performance schema
B. The GET DIAGNOSTICS statement
C. The slow query log
D. The MYSQL error log
正解：A,C

質問 2：
You have two lists of values to correlate.

Which query lists all names in colors1 and how many total matches are there in colors2?
A. SELECT colors1. Name count (colors2.name)
FROM colors1
INNER JOIN colors2
on colors1. Name =colors2. Name
GROUP BY colors1 .name;
B. SELECT colors1.name, count (colors2.name)
FROM JOIN colors2
on colors1 .name =colors2.name
GROUP BY colors1.name;
SELECT colors1.name, count (colors2.name)
FROM colors1
RIGHT JOIN colors1
on colors1 .name =colors2.name
GROUP BY colors1.name;
C. SELECT colors1 .name.count (colors2.name)
FROM colors1. Colors2
WHERE
Colors1. Name = (SELECT DISTINCT name FROM colors2 WHERE colors1.name=colors2.name)
GROUP BY colorse1.name,
D. SELECT colors1.name, count(colorse2. Name)
FROM colorse1 .name =colors2.name
WHERE colors1. Name =colors2.name
GROUP BY colors1.name,
正解：B

質問 3：
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_CAT(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
B. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
C. SELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE countrycode= 'GBR';
D. SELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
When executing a stored routine, how is the SQL_MODE determined?
A. By using TRADITTIONAL regardless of any other settings
B. By the current SQL _MODE of the session
C. By the SQL_MODE that was set when the routine was defined
D. By the default SQL_MODE of the server
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 Diagnostics area, part, of which can be stored in user-defined or routine variables
C. In the Signal area, which is set with the help of the SIGNAL statement in a stored routine
D. In the Error area, which can be accessed with the help of the SHOW ERRORS statement
正解：B

質問 6：
A statement exists that can duplicate the definition of the 'world'table.
What is missing?
CREATE TABLE t1 ___________world
A. FROM
B. COPY
C. USING
D. LIKE
正解：D

質問 7：
Which two can be used to obtain information stored in the Diagnostics Area?
A. GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;
SELECT @errno, @msg;
B. SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
C. SHOW GLOBAL STATUS LIKE 'Diagnostics'
D. SHOW WARNINGS
正解：A,D
解説: (Topexam メンバーにのみ表示されます)