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

문제1

Which two statements are true about AUTO_INCREMENT?

A. A table can have multiple AUTO_INCREMENT columns.

B. The decimal data type supports AUTO_INCREMENT.

C. A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

D. AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

E. An AUTO_INCREMENT column must be indexed.

정답: D,E

문제2

You must write a statement that combines the first_name and last_name columns from the employees table as "last_name, first_name." Which two statements will do this?

A. SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;

B. SELECT GROUP_CONCAT(last_name, first_name) FROM employees;

C. SELECT CONCAT(last name,', ',first_name) FROM employees;

D. SELECT last_name, ' , ',first_name FROM employees;

E. SELECT last_name + ', ' + first_name FROM employees;

정답: A,C

문제3

Which select statement returns true?

A. SELECT NULL := NULL;

B. SELECT NULL <> NULL;

C. SELECT NULL <=> NULL;

D. SELECT NULL = NULL;

정답: C

문제4

Examine this statement and output:

What causes the error?

A. The database client process does not have sufficient privilege.

B. The database user does not have sufficient privilege.

C. The database server process does not have sufficient privilege.

D. The database server is running in read-only mode.

E. The engine is disabled.

F. The set local_infile option has not been enabled.

정답: C

문제5

Examine this event's metadata:

Now examine this command:
DROP USER 'userl'e'localhost';
Which effect will the command have on the event?

A. The event is scheduled but will no longer execute. The system will log an error.

B. The event is not scheduled and will no longer execute. The system will log an error.

C. The event will be dropped without an error or warning.

D. The event is scheduled and executed but fails. The system will log an error.

정답: A

문제6

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

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

B. Buffered queries are enabled by default.

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

D. Buffered queries must be explicitly enabled using mysqliuseresult.

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

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

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

정답: A,C,D

문제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

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

우리와 연락하기

유용한 링크

최신 업데이트