最新的Oracle 1z0-882日本語免費考試真題

問題1

Mysq1> ALTER TABLE employees ADD FOREIGN KEY (Department_ID) REFERENCES departments (Department_ID);

A. SHOW ENGINE INNODB STATUS

B. SELECT FROM information_schema.INNODB_SYS_FOREIGN

C. SHOW ERRORS

D. Error 1215

正確答案: A

說明：（僅 Fast2test 成員可見）

問題2

CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;
REPEAT
FETCH cur INTO va1;
IF NOT done THEN
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;
END
CALL sum_t1();

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: D

問題3

A. CREATE DATABASE _

B. CREATE DATABASE 12

C. CREATE DATABASE $test

D. CREATE DATABASE 1$

E. CREATE DATABASE $

正確答案: C

問題4

A. CREATE TABLE

B. CREATE VIEW

C. ALTER VIEW

D. CALL

E. LOAD DATA INFILE

正確答案: A,B,D

說明：（僅 Fast2test 成員可見）

問題5

'

A. OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql

B. DataSet, MySqlDataAdapter, MySql Command Builder

C. MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results

D. DecoupODBCConn, DecoupMyScjlruiiimanrt, DecoupMySqlRetum

正確答案: B

說明：（僅 Fast2test 成員可見）

問題6

mysql >DESCRIBE country;

mysql> DESCRIBE countrylanguage;

A. SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND Name IN (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
AND Language ='German'
)

B. SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND EXISTS (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
And Language= 'German'
)

C. SELECT Code AS c, Name
FROM Country
WHERE Continent = ' Europe'
AND EXIST ANY (
SELECT Language, CountryCode
FROM CountryLanguage
WHERE CountryCode =Code
AND Language = 'German'
)

D. SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND (
SELECT *
FROM CountryLanguage
WHERE CountryCode =Code
AND Language ='German'
)

正確答案: B

問題7

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: B

問題8

A. Jdbc :mysqli://localhost/test?user=xxx&password=xxx

B. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx

C. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx

D. Jdbc:mysq1://localhost/test?user =xxx&password=xxx

E. Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx

正確答案: B,C,D

問題9

CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: A

問題10

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: A

說明：（僅 Fast2test 成員可見）

最新的Oracle Certified Professional, MySQL 5.6 Developer (1z0-882日本語版) - 1z0-882日本語免費考試真題

聯系我們

站內鏈接

最新更新