Is this exam completely free?

Examcademy offers a free preview for every exam, covering around 20% of the total questions. Full access is available with a paid upgrade.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! Examcademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our mock exams are built and reviewed with the help of AI and community contributions, staying aligned with real-world exam objectives.

1z0-908Free trial

By oracle

Verified

25Q per page

Question 1

Examine this statement, which executes successfully:

$Image 1$

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

A: ALTER TABLE world.city ADD SPATIAL INDEX (Name);
B: ALTER TABLE world.city ADD SPATIAL INDEX (Population);
C: ALTER TABLE world.city ADD INDEX (Population);
D: ALTER TABLE world.city ADD INDEX (Name);
E: ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
F: ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

—

Question 2

You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

A: installing and configuring the Connection Control plugin
B: avoiding concatenation of SQL statements and user-supplied values in an application
C: using stored procedures for any database access
D: using PREPARED STATEMENTS

—

Question 3

Which three requirements must be enabled for group replication? (Choose three.)

A: slave updates logging
B: semi-sync replication plugin
C: primary key or primary key equivalent on every table
D: binary log checksum
E: binary log ROW format
F: binary log MIXED format
G: replication filters

—

Question 4

Which three are types of InnoDB tablespaces? (Choose three.)

A: redo tablespaces
B: encryption tablespaces
C: schema tablespaces
D: data tablespaces
E: undo tablespaces
F: temporary table tablespaces

—

Question 5

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

A: No committed transactions are lost.
B: 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.
C: 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.
D: Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
E: Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
F: A small amount of committed transactions may be lost in case they were committed just before the disk failure.

—

Question 6

The 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?

A: The minimum value increases to 3000 and the maximum value increases to 4000.
B: Only the minimum connection value is increased to 3000.
C: The minimum connection value is changed to 2000.
D: An error is returned.

—

Question 7

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

A: UPDATE world.country SET Name='all';
B: UPDATE world.country SET Name='one' LIMIT 1;
C: UPDATE world.country SET Name='new' WHERE Name='old';
D: UPDATE world.country SET Name=CONCAT('New ',Name);
E: UPDATE world.country SET Name='first' ORDER BY Name LIMIT

—

Question 8

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

A: It supports backing up only table structures.
B: It can perform hot or warm backups.
C: It creates logical backups.
D: It supports the creation of incremental backups.
E: It supports backup of a remote MySQL system.
F: It supports restoring to a remote MySQL system.

—

Question 9

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

A: Each slave thread is responsible for updating a specific database.
B: Cross-database constraints can cause database inconsistency.
C: Increasing slave_parallel_workers will improve high availability.
D: Setting slave_preserve_commit_order to on will improve data consistency.
E: Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
F: Setting transaction_allow_batching to on will improve data consistency.

—

Question 10

Examine this command and output:

Which statement is true?

A: Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
B: Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
C: Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
D: Firewall_access_granted is the number of connections granted from whitelisted hosts.

—

Question 11

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

A: ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
B: ALTER TABLE t1 ENCRYPTION='Y';
C: ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
D: ALTER TABLE t1 SET TDE = 'ON';

—

Question 12

Examine this command, which executes successfully:

Which statement is true?

A: Only files for MySQL or Its built-in storage engines are backed
B: Only non-encrypted files are backed up.
C: The backup includes only data files and their metadata.
D: Only InnoDB data and log files are backed up.
E: Only tables stored in their own tablespaces are backed up.

—

Question 13

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

A: MySQL server was not started due to a problem while executing process 2732.
B: MySQL server continued to start up even though another process existed.
C: systemd found the mysqld service disabled and failed to start it.
D: systemd waited for 30 seconds before timing out and start up failed.
E: systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

—

Question 14

How can mysql_multi be configured to allow MySQL instances to use the same port number?

A: The instances use different user accounts unique to each instance.
B: The instances listen on different IP addresses.
C: The instances use different socket names.
D: The instances have appropriate net masks set.

—

Question 15

What does the slave I/O thread do?

A: connects to the master and requests it to send updates recorded in its binary logs
B: monitors and schedules I/O calls to the subsystem for the relay logs
C: acquires a lock on the binary log for reading each event to be sent to the slave
D: reads the relay log and executes the events contained in them

—

Question 16

You have an installation of MySQL 8 on Oracle Linux.
Consider the outputs:

Which statement is true about disk temporary tables for this installation?

A: Only internal temporary tables from the optimizer will be created in tmpdir.
B: Temporary tables will use the InnoDB temporary tablespace located in datadir.
C: Temporary tables are created in tmpdir only if configured to use MyISAM.
D: Temporary tables are created in tmpdir only after they reach tmp_tabie_size.
E: Temporary tables will use the InnoDB temporary tablespace located in /tmp.

—

Question 17

Which three are requirements for a secure MySQL Server environment? (Choose three.)

A: Restrict the number of OS users that have access at the OS level.
B: Ensure appropriate file system privileges for OS users and groups.
C: Minimize the number of non-MySQL Server-related processes running on the server host.
D: Encrypt the file system to avoid needing exact file-system permissions.
E: Keep the entire software stack on one OS host.
F: Run MySQL server as the root user to prevent incorrect sudo settings.

—

Question 18

Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?

A: It will force the load of the audit plugin even in case of errors at server start.
B: It causes the audit log to be created if it does not exist.
C: It prevents the audit plugin from being removed from the running server.
D: It prevents the audit log from being removed or rotated.

—

Question 19

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A: The redo logs are backed up first, then the transaction and archive tables.
B: The redo logs are backed up only if there are changes showing for the transactions tables.
C: The redo logs are not backed up at all.
D: The archive tables are backed up first, then the transaction tables and redo logs.
E: The transaction tables are backed up first, then the archive tables and redo logs.

—

Question 20

You issue this command:

SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

A: It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.
B: It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.
C: It is the time between the I/O thread receiving details of the master’s last transaction and the time it was written to the relay log on the slave.
D: It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

—

Question 21

All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)

A: SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
B: Configuring SSL group communication also configures SSL distributed recovery.
C: An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
D: SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
E: If only some InnoDB Cluster members are enabled for SSL group communication, and --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
F: SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

—

Question 22

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

A: They take roughly twice as long as logical backups.
B: They allow direct copying of table rows with operating system copy commands.
C: They work best for transaction storage engines that can perform their own recovery when restored.
D: The backup window is almost zero from the perspective of the application.
E: They do not back up views, stored procedures, or configuration files.
F: There is a slight performance cost while the snapshot is active.
G: They do not use additional disk space.

—

Question 23

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?

A: mysqlbinlog --stop-position=500324 binlog.000036 | mysql
B: mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
C: mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
D: mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

—

Question 24

Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

A: Connection 24 experiences a lock wait timeout.
B: Connection 25 experiences a lock wait timeout.
C: A deadlock occurs immediately.
D: All statements execute without error.
E: A deadlock occurs after innodb_lock_wait_timeout seconds.

—

Question 25

You want to dump all databases with names that start with "db".
Which command will achieve this?

A: mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
B: mysqlpump > all_db_backup.sql
C: mysqlpump --include-databases=db --result-file=all_db_backup.sql
D: mysqlpump --include-databases=db% --result-file=all_db_backup.sql

—

Page 1 of 6 • Questions 1-25 of 142

1 2 3 4 5

→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!