최신 1z0-882 무료덤프 - Oracle Certified Professional, MySQL 5.6 Developer

문제1

Consider the my_table table with two integer columns, a and b, and the contents as shown;
Mysql > SELECT a, b FROM my_table;

1 row in set result of this query?
SELECT a-b
FROM my_table;

A. 4

B. An error message

C. 0

D. 2

정답: C

문제2

You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?

A. MyISAM or InnoDB data files

B. Comma-delimited data

C. Tab-delimited data

D. SQL commands

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?

A. A single result set with two columns containing the names from country codes USA and JPN.

B. No result set is returned and an error message is given.

C. A single result set with one column that contains the names of cities from country codes USA and JPN.

D. Two result sets each containing a single column with the names of cities from country codes USA and JPN.

정답: B

문제4

Consider the table structure shown by this output:
Mysql> desc city:

5 rows in set (0.00 sec)
You execute this statement:
SELECT -,-, city. * FROM city LIMIT 1
What is returned?

A. One row with 5 columns

B. One row with 10 columns

C. An error message

D. One row with 15 columns

정답: C

문제5

Assume that none of the databases exist.
Which statement results in an error?

A. CREATE DATABASE $

B. CREATE DATABASE $test

C. CREATE DATABASE 1$

D. CREATE DATABASE 12

E. CREATE DATABASE _

정답: B

문제6

As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?

A. The examinee_id column should be designated as PRIMARY KEY.

B. A NOT NULL qualifier should be added to examinee_id.

C. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).

D. A NOT NULL qualifier should be moved from exam-id to examinee-id.

정답: B

문제7

Which two statements provide the definition for a view named view1 in the test database?

A. SELECT VIEW_DEFINITION_SCHEMA.VIEWS
FROM INFORMATION _SCHEMA.VIEWS
WHERE TABLE_NAME="view1"
AND TABLE_SCHEMA = "test"

B. SHOW CREATE VIEW view1 FROM test

C. SHOW CREATE VIEW test-view1

D. SELECT DEFINITION
FROM INFORMATION_SCHEMA.VIEWS
WHERE NAME = "test"

E. SHOW DEFINITION FOR test.view

정답: A,C

문제8

Which two Functions can be used in a C program to retrieve information about warning?

A. mysql_warning_count

B. mysql_info

C. mysql_error

D. mysql_errno

정답: A,B

설명: (DumpTOP 회원만 볼 수 있음)

문제9

You wish to create a trigger on the 'city' table that will check the value of the 'District' field before any INSERT. The
trigger needs to change it to" Unknown" for an empty string or NULL.
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;
Does the CREATE TRIGGER statement accomplish this goal?

A. No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT....

B. Yes; the trigger works correctly.

C. No; the OLD keyword cannot be used in an INSERT trigger.

D. No; FOR EACH ROW is invalid syntax.

정답: C

문제10

Consider the content of the class and student tables:
Class

Which three queries produce the same result?

A. SELECT *
FROM class
INNER JOIN student
ON class.class_id=student.class_id

B. SELECT *
FROM student
RIGHT JOIN class
ON class.class_id=student.class_id

C. SELECT *
FROM JOIN student
LEFT JOIN student
ON class. Class.class_id=student.class_id

D. SELECT *
FROM class
INNER JOIN student
WHERE NOT ISNULL (student.class_id)

E. SELECT *
FROM JOIN student
On class .class_id=student.class_id
WHERE NOT ISNULL (student.class_id)

정답: B,C,E

최신 1z0-882 무료덤프 - Oracle Certified Professional, MySQL 5.6 Developer

우리와 연락하기

유용한 링크

최신 업데이트