Oracle 1z0-882日本語 問題集

質問 1：

A. Index
B. Trigger
C. Stored procedure
D. Table
E. Column
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：

CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;



DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):

A. (201,Pluto)
B. (101,Pluto)
C. (300,Pluto)
D. (200.pluto)
正解：A

質問 3：

SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'

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

質問 4：

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

質問 5：

Start with "p"
End with "_"

A. SELECT code FROM operations WHERE code LIKE "p_%_%;_"ESCAPE "/";
B. SELECT code FROM operations WHERE code LIKE "p_\%\_";
C. SELECT code FROM operations WHERE code LIKE "p%_\_";
D. SELECT code FROM operations WHERE code LIKE "p%%_";
E. SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';
正解：B,C

質問 6：

CREATE TABLE t1 ___________world
A. FROM
B. COPY
C. USING
D. LIKE
正解：D

質問 7：

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