1z0-908 Practice Test

1z0-908 Practice Test practice questions, page 8 of 9, with answer review and explanations.

Question 36

Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

  1. TCP
  2. SOCKET
  3. PIPE
  4. DIRECT
  5. IPv6
  6. FILE
  7. IPv4
  8. MEMORY

Question 37

Examine this command and output: Which two statements are true? (Choose two.)

  1. The lock is at the metadata object level.
  2. The lock is a shared lock.
  3. The lock is an intentional lock.
  4. The lock is at the table object level.
  5. The lock is a row-level lock.
  6. The lock is an exclusive lock.

Question 38

Which three statements are true about MySQL replication? (Choose three.)

  1. Replication can use only TCP/IP connections.
  2. Any instance can have multiple slaves, but it can have only one master.
  3. Each instance in a replication topology must have a unique server ID.
  4. Binary logs contain only transactions originating from a single MySQL instance.
  5. Each slave must have its own MySQL user for replication.
  6. Binary logging must be enabled on the master in order to replicate to other instances.
  7. A replication user must have the SELECT privilege for all tables that need to be replicated.

Question 39

Which two statements are true about the mysql_config_editor program? (Choose two.)

  1. It manages the configuration of the MySQL Firewall feature.
  2. It manages the configuration of client programs.
  3. It can move datadir to a new location.
  4. It manages the configuration of user privileges for accessing the server.
  5. It will use [client] options by default unless you provide --login-path.
  6. It can be used to create and edit SSL certificates and log locations.
  7. It provides an interface to change my.cnf files.

Question 40

Examine this command, which executes successfully: shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)

  1. It executes flush tables with read lock.
  2. It enforces consistent backups for all storage engines.
  3. The backup created is a consistent data dump.
  4. This option uses the READ COMMITTED transaction isolation mode.
  5. It is a cold backup.