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

문제1

Which two statements are true about aggregate functions?

A. SUM () returns o if there are no rows to aggregate.

B. MIN () cannot use distinct when it executes as a Windows function.

C. COUNT (distinct) returns a count of the number of rows with different values including Null.

D. MAX () returns null if there are no rows to aggregate.

E. AVG () does not allow use of the distinct option.

정답: E

문제2

A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

A. socket is a reserved word in Java.

B. The socket can only be accessed from the local host.

C. The socket is not implemented in Connector/J driver.

D. Java treats the socket file as insecure.

E. The X Dev API protocol must be enabled to use sockets in Connector/J driver.

정답: C,D

문제3

Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

A. The virtual values in the name column must be accessed using functions.

B. The JSON datatype cannot be used in virtual columns.

C. The select requires json_unquoteo in the where clause.

D. The json_extract() function requires a length value that matches the field length in the schema.

E. Table statistics must be updated to generate values for the name column.

정답: B

문제4

Examine these statements which execute successfully:

Now, examine this query:

What is the result?

A. It inserts a row with an error.

B. It inserts a row with no error or warning.

C. It fails with an error.

D. It fails with a warning.

E. It inserts a row with a warning.

정답: B

문제5

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

문제6

Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

A. NULL

B. ERROR: 1267 (HYOOO): Illegal mix of collations

C. 1

D. -1

E. 0

정답: D

문제7

Examine the Test.php script which is numbered for clarity, and its output:

PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?

A. Replace line 2 with Slink = mysql.connect {"localhost: 3306n, "username", "pas "schema") ;

B. Install the PHP executable in the path used by the MySQL installation.

C. Replace line 2 With: Slink = mysql_xdevapi\getSession
("mysqlx://username:password@localhost:3306","schema");

D. Enable the mysqli extension in the php.ini file.

정답: D

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

우리와 연락하기

유용한 링크

최신 업데이트