← Back to exam page

1z0-908 – MySQL 8.0 Database Administrator

Loading demo links...

Showing 4–6 of 10 questions

Question 4

A user wants to connect without entering his or her username and password on the Linux command prompt.

Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    $HOME/.my.cnf file
  • ○

    $MYSQL_HOME/my.cnf file
  • ○

    DATADIR/mysqld-auto.cnf file
  • ○

    $HOME/.mylogin.cnf file
  • ○

    $HOME/.mysql/auth/login file
  • ○

    /etc/my.cnf file
  • ○

    $HOME/.mysqlrc file
Question 5

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Users could overwrite configuration files.
  • ○

    Data files could be deleted.
  • ○

    SQL injections could be used to insert bad data into the database.
  • ○

    MySQL binaries could be damaged, deleted, or altered.
  • ○

    Extra startup time would be required for the MySQL server to reset the privileges.
Question 6

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.

You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.

Which command will complete the recovery?

Select an option, then click Submit answer.

  • ○

    mysqlbinlog --stop-position=500324 binlog.000036 | mysql
  • ○

    mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
  • ○

    mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
  • ○

    mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql