[2026] Oracle MySQL 8.0 Database Developer - 1Z0-909 무료 시험 문제

문제1

Examine the structure of the emp table:

Examine the structure of the emp_vu1 view based on the emp table:

Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;
What is true about executing the statement?

A. It inserts a row in the emp table.

B. It returns an error because an insert operation is not allowed on views.

C. It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.

D. It inserts a row in the view only.

정답: A

문제2

Which two differences exist between the timestamp and date time data types?

A. timestamp converts the value based on the session time zone.

B. timestamp has larger range of values.

C. timestamp uses less storage space.

D. timestamp stores the interval between two dates.

E. timestamp stores more decimal points in seconds

정답: A,C

문제3

Which two are true about MySQL Document Store?

A. There is no access to relational tables.

B. It helps to store data items in a schema-less key-value store.

C. It depends heavily on strictly typed data.

D. It allows one to bypass the SQL layer of the server.

E. It can store documents greater than 4 GB.

정답: B,D

문제4

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

A. Results are sent to the calling PHP process for buffering.

B. Buffered queries are enabled by default.

C. Buffered queries should be used on large tables when the result size is unknown.

D. Additional queries on the same session are blocked until the result set is released.

E. Results are sent from the server to the browser for buffering.

F. Buffered queries must be explicitly enabled using mysqliuseresult.

G. Large results can have a negative impact on performance.

정답: C,F,G

문제5

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

A. DEALLOCATE PREPARE prep?

B. SET @prep = NULL;

C. DROP PREPARE prep;

D. DROP PROCEDURE prep;

E. PREPARE prep FROM '';

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

정답: B,D

문제6

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. An error is generated because the index prevents changes to the column.

B. Execution succeeds with a warning.

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

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

정답: A

문제7

Examine this statement which has executed successfully:

A. Execution performance can be improved by using like instead of RLIKE.

B. Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

C. The statement takes advantage of index description_idx.

D. Execution performance can be improved by adding an index on column description.

E. No index will improve statement performance.

정답: A

Oracle MySQL 8.0 Database Developer - 1Z0-909무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트