← Back to exam page

1z0-909 – MySQL 8.0 Database Developer

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Your program which uses a MySQL connector receives this error:

Client does not support authentication protocol request by server

The account running the program uses caching_sha2_password.

Which two resolve this conflict?

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

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?

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

The continent column in the country table contains no null values.

Examine this output:

A)

B)

C)

D)

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D