Oracle 1z0-882日本語 問題集

質問 1：

A. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
B. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc
C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin
D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
正解：B

質問 2：

A. Option A
B. Option C
C. Option D
D. Option B
正解：B,D

質問 3：

Mysql> drop function foo;
ERROR 1305 (420000): FUNCTION test, foo does not exist
Mysql > show warnings;

Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT;

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 4：



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

質問 5：

CREATE TRIGGER Country_ad
AFTER DELETE ON Country
FOR EACH ROW
SET @old _CountryName= NEW.Name,
@ old _CountryCode=NEW.Code;

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 6：

CREATE TRIGGER City_bi
BEFORE INSERT ON CITY
FOR EACH ROW
BEGIN
IF OLD. District IS NULL OR OLD.District= . .
THEN
SET NEW.District='Unknown';
END IF :
END;

A. Option A
B. Option C
C. Option D
D. Option B
正解：C

質問 7：

SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC

A. Option A
B. Option C
C. Option D
D. Option B
正解：C
解説: (Topexam メンバーにのみ表示されます)