1z0-908 — Free Practice Questions
10 free sample questions from a bank of 249, with the correct answers and explanations. No signup required — start practising right now.
1Examine this statement, which executes successfully: You want to improve the performance of this query: Which change enables the query to succeed while accessing fewer rows?
- ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- ALTER TABLE world.city ADD INDEX (Population);
- ALTER TABLE world.city ADD INDEX (Name);
- ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
Answer: C
2You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- installing and configuring the Connection Control plugin
- avoiding concatenation of SQL statements and user-supplied values in an application
- using stored procedures for any database access
- using PREPARED STATEMENTS
Answer: A
3Which three requirements must be enabled for group replication? (Choose three.)
- slave updates logging
- semi-sync replication plugin
- primary key or primary key equivalent on every table
- binary log checksum
- binary log ROW format
- binary log MIXED format
- replication filters
Answer:
4Which three are types of InnoDB tablespaces? (Choose three.)
- redo tablespaces
- encryption tablespaces
- schema tablespaces
- data tablespaces
- undo tablespaces
- temporary table tablespaces
Answer:
5You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)
- No committed transactions are lost.
- The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
- As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
- Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
- Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
- A small amount of committed transactions may be lost in case they were committed just before the disk failure.
Answer:
6The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?
- The minimum value increases to 3000 and the maximum value increases to 4000.
- Only the minimum connection value is increased to 3000.
- The minimum connection value is changed to 2000.
- An error is returned.
Answer: D
7Examine this statement and output: Which two SQL statements can jsmith execute? (Choose two.)
- UPDATE world.country SET Name='all';
- UPDATE world.country SET Name='one' LIMIT 1;
- UPDATE world.country SET Name='new' WHERE Name='old';
- UPDATE world.country SET Name=CONCAT('New ',Name);
- UPDATE world.country SET Name='first' ORDER BY Name LIMIT
Answer:
8Which two statements are true about MySQL Enterprise Backup? (Choose two.)
- It supports backing up only table structures.
- It can perform hot or warm backups.
- It creates logical backups.
- It supports the creation of incremental backups.
- It supports backup of a remote MySQL system.
- It supports restoring to a remote MySQL system.
Answer:
9Four nodes are configured to use circular replication.
Examine these configuration parameters for each node: Which statement is true?
- Each slave thread is responsible for updating a specific database.
- Cross-database constraints can cause database inconsistency.
- Increasing slave_parallel_workers will improve high availability.
- Setting slave_preserve_commit_order to on will improve data consistency.
- Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
- Setting transaction_allow_batching to on will improve data consistency.
Answer: D
10Examine this command and output: Which statement is true?
- Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
- Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
- Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
- Firewall_access_granted is the number of connections granted from whitelisted hosts.
Answer: C
Want the full bank of 249 questions for 1z0-908? See all practice exams.