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

質問 1

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 解答を投票する

質問 2

Examine this statement that execute successfully in an interactive session:

The user running this session now goes to lunch for an hour.
Now, examine these statements executed independently in separate sessions while Session 0 is still active:

How many of them will complete while Session 0 is still active?

（A）3

（B）5

（C）1

（D）4

（E）2

（F）0

正解：C 解答を投票する

質問 3

Which two are true about MySQL Document Store?

（A）It depends heavily on strictly typed data.

（B）It can store documents greater than 4 GB.

（C）It allows one to bypass the SQL layer of the server.

（D）There is no access to relational tables.

（E）It helps to store data items in a schema-less key-value store.

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

質問 4

Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

（A）An error occurs and the create table statement fails.

（B）The server will create the table using the default storage engine.

（C）The server will create the table but report an error when the first attempt to insert a row is performed.

（D）The server will create the table but it will be unusable until the specified storage engine is available.

正解：A 解答を投票する

質問 5

Examine this statement:

（A）Inserting COMMIT; SET @m :=: before line 4

（B）user who creates the procedure needing the create and execute privileges

（C）user who creates the procedure needing the create routine privilege

（D）inserting USE <database >; before line 3

（E）Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement

正解：E 解答を投票する

質問 6

Which two are true about MySQL connectors?

（A）Connector/ODBC is available on Unix, Windows, and MacOS X.

（B）Connector/J is based on Connector/C.

（C）Connector/Python is released in precompiled binary and source code.

（D）Connector/NET runs on the Windows platform only.

（E）Connectors must be installed on both the client and server hosts.

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

質問 7

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 and executed but fails. The system will log an error.

（B）The event is scheduled but 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 not scheduled and will no longer execute. The system will log an error.

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験