1z0-908 Practice Test

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

Question 41

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

  1. The country table is accessed as the first table, and then joined to the city table.
  2. It takes more than 8 milliseconds to sort the rows.
  3. The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.
  4. 35 rows from the city table are included in the result.
  5. The query returns exactly 125 rows.

Question 42

Examine this command, which executes successfully: mysqlpump -–user=root --password > full_backup.sql Which two databases will be excluded from this dump? (Choose two.)

  1. information_schema
  2. world
  3. employee
  4. sys
  5. mysql

Question 43

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 the SSL/TLS connection to MySQL?

  1. REQUIRED
  2. VERIFY_CA
  3. VERIFY_IDENTITY
  4. PREFERRED
  5. DISABLED

Question 44

You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

  1. general query log
  2. audit log
  3. slow query log
  4. binary log
  5. error log

Question 45

Which two statements are true about using backups of the binary log? (Choose two.)

  1. Multiple binary logs can be used to restore data.
  2. Multiple binary logs can be applied in parallel for faster data restoration.
  3. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
  4. Binary logs can always be used to unapply unwanted schema changes.
  5. They allow for point-in-time recovery of the data.