Free 1z0-909 – MySQL 8.0 Database Developer Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Change DATE () to DAY ().

• ○

  Change "O'Hagen" to 'o\'Hagen'.

• ○

  Change date () to CURRENT_TIMESTAMP () .

• ○

  Change " NULL " to NULL.

• ○

  Change " NULL " to ' NULL ' .

• ○

  Change "O'Hagen" to "O\'Hagen".

Select all that apply, then click Submit answer.

• ○

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

• ○

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

• ○

  Buffered queries are enabled by default.

• ○

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

• ○

  Results are sent to the calling PHP process for buffering.

• ○

  Buffered queries must be explicitly enabled using mysqliuseresult.

• ○

  Large results can have a negative impact on performance.

Select all that apply, then click Submit answer.

• ○

  SET @a = ''; EXECUTE prep USING @a;

• ○

  DEALLOCATE PREPARE prep?

• ○

  DROP PROCEDURE prep;

• ○

  SET @prep = NULL;

• ○

  DROP PREPARE prep;

• ○

  PREPARE prep FROM '';

Select all that apply, then click Submit answer.

• ○

  Disable TLS/SSL authentication.

• ○

  Place this in the root directory of your shell account:
  [mysqld] require__secure_transport=OFF

• ○

  Use blank RSA or SSL certificates.

• ○

  Upgrade the connector to a version that supports caching_sha2_password.

• ○

  Change the user account to use mysql_native_password.

Select all that apply, then click Submit answer.

• ○

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

• ○

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

• ○

  Session 1 does not block Session 2.

• ○

  Statements in Session 2 are committed.

• ○

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

• ○

  Session 2 does not start a transaction.

Select an option, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D

Select an option, then click Submit answer.

• ○

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

• ○

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

• ○

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

• ○

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

• ○

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

• ○

  It displays similar diagnostics results as get diagnostics.

Select an option, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D

Select an option, then click Submit answer.

• ○

  0

• ○

  ERROR: 1267 (HYOOO): Illegal mix of collations

• ○

  -1

• ○

  NULL

• ○

  1

Select an option, then click Submit answer.

• ○

  Inserting COMMIT; SET @m :=: before line 4

• ○

  user who creates the procedure needing the create and execute privileges

• ○

  user who creates the procedure needing the create routine privilege

• ○

  inserting USE ; before line 3

• ○

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