1z1-909無料問題集「Oracle MySQL 8.0 Database Developer」

質問 1

Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date

（A）Change "O'Hagen" to 'o\'Hagen'.

（B）Change " NULL " to NULL.

（C）Change " NULL " to ' NULL ' .

（D）Change DATE () to DAY ().

（E）Change date () to CURRENT_TIMESTAMP () .

（F）Change "O'Hagen" to "O\'Hagen".

正解：B、D 解答を投票する

質問 2

Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

（A）SELECT 'Car' LIKE 'Ca?' INTO @r;

（B）SELECT 'Car' RLIKE 'Ca?' INTO @r;

（C）SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

（D）SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

正解：B 解答を投票する

質問 3

What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?

（A）mysqli can access databases from other vendors.

（B）mysqli supports object oriented programming.

（C）mysqli supports non blocking, asynchronous queries.

（D）mysqli includes X DevAPI functions.

正解：B 解答を投票する

質問 4

Examine the output:

Which explain command will obtain the output?

（A）EXPLAIN PARTITIONS

（B）EXPLAIN PORMAT=JSON

（C）EXPLAIN PORMAT^TRADITIONAL

（D）EXPLAIN ANALYZE

（E）EXPLAIN FORMAT=TREE

正解：B 解答を投票する

質問 5

Which statement is true about the show errors command?

（A）It displays similar diagnostics results as get diagnostics.

（B）It displays the total number of errors, warnings, and notes since the server last restarted.

（C）It displays errors messages only, since the start time of the current session.

（D）It displays errors messages only, since the server last restarted.

（E）It cannot display information for more than max_errot_count server system variable setting.

（F）It displays the total number of errors, warnings, and notes since the beginning of the current session.

正解：F 解答を投票する

質問 6

Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

（A）

（B）

（C）

（D）

（E）

正解：A、E 解答を投票する

質問 7

Examine this statement and output:

What causes the error?

（A）The database server process does not have sufficient privilege.

（B）The set local_infile option has not been enabled.

（C）The database client process does not have sufficient privilege.

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

（E）The engine is disabled.

（F）The database user does not have sufficient privilege.

正解：A 解答を投票する

1z1-909 無料問題集「Oracle MySQL 8.0 Database Developer」

弊社を連絡する

関連リンク

トップ試験