← Back to exam page

1z0-909 – MySQL 8.0 Database Developer

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Which statement is true about the show errors command?

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

The variables c and d are declared as integer types.

Examine these initialization statements with placeholder value , which execute successfully:

Now, examine this loop which executes successfully:

Which loop results in the same value of d for all valid values of ?

A)

B)

C)

D)

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
Question 9

Examine these statements:

SET collation_connection=utf8mb4_0900_as_cs;

SELECT STRCMPCAlice', UCASE ('Alice* )) ;

What is displayed?

Select an option, then click Submit answer.

  • ○

    0
  • ○

    ERROR: 1267 (HYOOO): Illegal mix of collations
  • ○

    -1
  • ○

    NULL
  • ○

    1