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

問題1

Mysql> SELECT * FROM friends;

SELECT AVG (age) FROM friends

A. NULL

B. 10

C. 20

D. 0

正確答案: C

說明：（僅 Fast2test 成員可見）

問題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. (300,Pluto)

C. (200.pluto)

D. (101,Pluto)

正確答案: A

問題3

A. SELECT first_name, last _name FROM people WHERE age LIKE '2'

B. SELECT first _name, last_name FROM people LIMIT 1, 2

C. SELECT 1,2 FROM people GROUP BY last_name

D. SELECT 1, 2 FROM people WHERE last _name ='smith'

E. SELECT DISTINCT last_name, first_name FROM people

正確答案: B,C

問題4

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: B

問題5

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

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: B

問題6

DESCRIBE CountryLanguage;

SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

A. Option D

B. Option F

C. Option B

D. Option C

E. Option E

F. Option A

正確答案: D,E

問題7

Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';

2 rows in set (0.00 sec)

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: C

問題8

A. SHOW WARNINGS

B. GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;
SELECT @errno, @msg;

C. SHOW GLOBAL STATUS LIKE 'Diagnostics'

D. SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題9

A. SELECT Name FROM country LIMIT 100-50

B. SELECT Name FROM country LIMIT @limitcount

C. SELECT Name FROM country LIMIT RAND ()

D. SELECT Name FROM country LIMIT 100,50

E. SELECT Name FROM country LIMIT 35

正確答案: D,E

問題10

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

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

聯系我們

站內鏈接

最新更新