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

質問 1

Examine this statement and output:

You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?

（A）product->''$.varieties [4]. origin[1];;

（B）product->varieties[3]. origin[0]''

（C）''$.varieties[4]. origin[1]''

（D）''$.varieties [3]. origin[0]''

正解：A 解答を投票する

質問 2

Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?

（A）The trigger activates after any row in the table has been updated.

（B）The trigger activates after any row has been inserted into the table.

（C）The trigger body set causes trigger activation.

（D）Execution of an insert statement causes the trigger to activate.

正解：D 解答を投票する

質問 3

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

（A）DROP PREPARE prep;

（B）SET @prep = NULL;

（C）SET @a = ''; EXECUTE prep USING @a;

（D）PREPARE prep FROM '';

（E）DEALLOCATE PREPARE prep?

（F）DROP PROCEDURE prep;

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

質問 4

Examine this statement and output:

Which will provide the same level of detail when the error is encountered within a stored routine?

（A）

（B）

（C）

（D）

正解：A 解答を投票する

質問 5

Examine the content of the employee table:

Now examine this PHP script:

Finally examine this desired output:

（A）$options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;

（B）$options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;

（C）$options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;

（D）$options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;

正解：C 解答を投票する

質問 6

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

質問 7

Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?

（A）Session 1 does not block Session 2.

（B）Session 2 takes an exclusive lock on all the rows in the band table.

（C）Session 1 takes a shared lock on all the rows in the band table.

（D）Statements in Session 2 are committed.

（E）Session 2 does not start a transaction.

（F）Session 1 must commit before the update in Session 2 can complete.

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

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

弊社を連絡する

関連リンク

トップ試験