최신 1z1-909 무료덤프 - Oracle MySQL 8.0 Database Developer

문제1

You must reclaim memory used by a prepared statement named prep. Which two achieve this?

A. DROP PROCEDURE prep;

B. SET @prep = NULL;

C. DEALLOCATE PREPARE prep?

D. SET @a = ''; EXECUTE prep USING @a;

E. PREPARE prep FROM '';

F. DROP PREPARE prep;

정답: A,B

문제2

Which select statement returns true?

A. SELECT NULL := NULL;

B. SELECT NULL <> NULL;

C. SELECT NULL <=> NULL;

D. SELECT NULL = NULL;

정답: C

문제3

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

A. Two transactions commit.

B. One row is inserted into band.

C. The transaction is rolled back to the savepoint.

D. No transaction commits.

E. No row is inserted into band.

정답: B,D

문제4

Which change will prevent negative ages to be inserted into the people table?

A. ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

B. DELIMITER //
CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;

C. DELIMITER //
CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;

D. ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

정답: D

문제5

Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?

A. Execution succeeds and allows the use of the index by the optimizer.

B. Execution succeeds with a warning.

C. An error is generated because the index prevents changes to the column.

D. An error is generated because srid o is an invalid identifier value.

정답: C

문제6

Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

A. Option D

B. Option C

C. Option B

D. Option A

정답: C

문제7

The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?

A.

B.

C.

D.

정답: D

최신 1z1-909 무료덤프 - Oracle MySQL 8.0 Database Developer

우리와 연락하기

유용한 링크

최신 업데이트