Oracle 1Z0-908 MySQL 8.0 Database Administrator Exam Exam Practice Test Questions

• Question 1

  Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

  • Sort_buffer_size
  • Key_buffer_size
  • Table_open_cache
  • Read_buffer_size
  • Innodb_buffer_pool_size
  • Tmp_table_size

  Show Answer Answer: A, B, F Next

• Question 2

  Which three are characteristics of a newly created role? (Choose three.)

  • It can be dropped using the DROP ROLE statement.
  • It is stored in the mysql.role table.
  • It is created as a locked account.
  • It can be renamed using the RENAME ROLE statement.
  • It can be granted to user accounts.
  • It can be protected with a password.

  Show Answer Answer: A, E, F Next

• Question 3

  A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.Which three features are available with this installation method? (Choose three.)

  • MySQL Replication monitoring
  • Network-related information and network characteristics
  • MySQL Query Analysis data
  • CPU utilization
  • Security-related advisor warnings
  • Operating system memory utilization
  • Disk usage and disk characteristics including disk advisors warnings

  Show Answer Answer: C, E, G Next

• 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.)

  • $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

  Show Answer Answer: B, C, F Next

• Question 5

  Examine this MySQL client command to connect to a remote database:mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish theSSL/TLS connection to MySQL?

  • REQUIRED
  • VERIFY_CA
  • VERIFY_IDENTITY
  • PREFERRED
  • DISABLED

  Show Answer Answer: A Next