← Back to exam page

1z0-909 – MySQL 8.0 Database Developer

Loading demo links...

Showing 1–3 of 10 questions

Question 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

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".
Question 2

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

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.
Question 3

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

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 '';