1Z0-908 Practice Exam — Free Oracle Certification Prep

Join Us Among the Stars

Sign Up & unlock 100% of Exam Questions

Log in / Sign up

No Strings Attached!

195Practice Questions

3Study Modes

Free

TopicSort

Question 1

Backup and Recovery

A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

A ibtmp1
B undo_001
C ib_buffer_pool
D ibdata1
E mysql.ibd
F ib_logfile0

Question 3

Performance

Question 4

Backup and Recovery

Question 5

Performance

Question 6

Installation and Configuration

Question 7

Performance

Question 8

Architecture

Question 9

Installation and Configuration

Question 10

Installation and Configuration

Question 12

Backup and Recovery

Question 13

Database Design

Question 14

Performance

Question 15

Backup and Recovery

Question 16

Performance

Question 17

Backup and Recovery

Question 18

Architecture

Question 19

Installation and Configuration

Question 20

Database Design

Question 21

Backup and Recovery

Question 22

Database Security

Question 23

Database Security

Question 24

Backup and Recovery

Question 25

Architecture

Question 26

Backup and Recovery

Question 27

Installation and Configuration

Page 1 of 8 • Questions 1-25 of 195

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Which condition is true about the use of the hash join algorithm?

A No index can be used for the join.
B The query must access no more than two tables.
C The smallest of the tables in the join must fit in memory as set by join_buffer_size.
D At least one of the tables in the join must have a hash index.

Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

A The slave relay logs should be deleted; then execute START SLAVE;
B The relay logs from the master should be used to replace the corrupted relay logs.
C The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
D The slave needs to be restored from backup.

Examine this query and its output:

Question Image

Which two statements are true? (Choose two.)

A The root user had the largest number of modified rows for a SELECT statement.
B User bob had the largest total time waiting for locks.
C The root user had the largest single wait time.
D The app user had the highest total number of rows read from storage engines.
E User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

Your my.cnf file contains these settings:

Question Image

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

A min_examined_row_limit=5000
B long_query_time=5log_throttle_queries_not_using_indexes=5
C log_throttle_queries_not_using_indexes=5min_examined_ row_limit=5000
D long_query_time=5
E long_query_time=5min_examined_row_limit=5000
F log_throttle_queries_not_using_indexes=5

Question 7

Performance

Question 8

Architecture

Question 9

Installation and Configuration

Question 10

Installation and Configuration

Question 12

Backup and Recovery

Question 13

Database Design

Question 14

Performance

Question 15

Backup and Recovery

Question 16

Performance

Question 17

Backup and Recovery

Question 18

Architecture

Question 19

Installation and Configuration

Question 20

Database Design

Question 21

Backup and Recovery

Question 22

Database Security

Question 23

Database Security

Question 24

Backup and Recovery

Question 25

Architecture

Question 26

Backup and Recovery

Question 27

Installation and Configuration

Examine this output:

Question Image

Which change should optimize the number of buffer pool instances for this workload?

A Increase the number of buffer pool instances to 16.
B Increase the number of buffer pool instances to 32.
C Decrease the number of buffer pool instances to 1.
D Increase the number of buffer pool instances to 12.
E Decrease the number of buffer pool instances to 4.

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

A Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
B Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
C Logical upgrades are much faster because they do not require restarting the mysqld process.
D Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
E Physical upgrades are much faster because they do not require restarting the mysqld process.
F Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Question Image

Which option will allow this client to connect to MySQL Server?

A [mysqld]default_authentication_plugin=sha256_password
B ALTER USER user -IDENTIFIED WITH mysql_native_passwordBY 'password';
C [mysqld]default_authentication_plugin=caching_sha2_password
D ALTER USER user -IDENTIFIED WITH caching_sha2_passwordBY 'password';
E ALTER USER user -IDENTIFIED WITH sha256_password -BY 'password';
F [mysqld]default_authentication_plugin=mysql_native_password

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

A --shared-memory-base-name=world
B --protocol=UDP
C --protocol=pipe
D --password
E --user=admin
F --host=192.0.2.1

Examine this partial output for InnoDB Cluster status:

Question Image

Which statement explains the state of the instance deployed on host2?

A It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')
B It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')
C It has been removed from the cluster by using the command STOP GROUP_REPLICATION;
D It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()
E It has been expelled from the cluster because of a transaction error.

Which three sets of item information are visible in the mysql system database? (Choose three.)

A help topics
B performance monitoring information
C plugins
D information about table structures
E audit log events
F rollback segments

Examine this statement, which executes successfully:

Question Image

Now examine this query:

Question Image

You must add an index that can reduce the number of rows processed by the query.
Which two statements can do this? (Choose two.)

A ALTER TABLE employees -ADD INDEX (birth_date DESC);
B ALTER TABLE employees -ADD INDEX ((MONTH(birth_date)));
C ALTER TABLE employees -ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL,ADD INDEX (birth_month);
D ALTER TABLE employees -ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL,ADD INDEX (birth_month);
E ALTER TABLE employees -ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));
F ALTER TABLE employees -ADD INDEX (birth_date);

You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

Question Image

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?

A RESET MASTER;SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
B SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
C RESET SLAVE;SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
D RESET MASTER;SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
E RESET SLAVE;SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Which statement is true about InnoDB persistent index statistics?

A Updating index statistics is an I/O expensive operation.
B Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
F Tables are scanned and index statistics recalculated when an instance is restarted.

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

A It reconfigures InnoDB Cluster if the cluster was stopped.
B It performs InnoDB Cluster instances rolling restart.
C It only starts all InnoDB Cluster instances.
D It is not mandatory that all instances are running and reachable before running the command.
E It stops and restarts all InnoDB Cluster instances and initializes the metadata.
F It only stops and restarts all InnoDB Cluster instances.

Which two statements are true about MySQL server multi-source replication? (Choose two.)

A It is not compatible with auto-positioning.
B It needs to be re-instanced after a crash to maintain consistency.
C It uses only time-based replication conflict resolution.
D It relies on relay_log_recovery for resilient operations.
E It does not attempt to detect or resolve replication conflicts.
F It must use GTID replication.

Which command enables rule-based MySQL Auditing capabilities?

A shell> mysql < audit_log_filter_linux_install.sql
B shell> mysqld --initialize --log-raw=audit.log
C mysql> INSTALL PLUGIN audit_log;
D mysql> INSTALL COMPONENT audit_log;

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

A performance metrics
B table definitions
C access control lists
D view definitions
E server runtime configuration
F server configuration rollback

You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running
Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A Stop all instances except the primary read/write master instance and run the restore.
B Remove the @@GLOBAL.gtid_purged statement from the dump file.
C Create the backup by using the --set-gtid-purged=OFF option.
D Remove the group replication plugin from each instance before restoring.
E Remove the @@GLOBAL.gtid_executed statement from the dump file.
F Restore using the --set-gtid-purged=OFF option.

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
B Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
C Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
D TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

A Use the AES_ENCRYPT() MySQL function on the option file.
B Use mysql_secure_installation to encrypt stored login credentials.
C Use a text editor to create a new defaults file and encrypt it from Linux prompt.
D Use mysql_config_editor to create an encrypted file.

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

A ibbackup files
B *.CSM files
C *.sdi files
D *.ibd files
E ib_logfile* files

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

A MySQL writes SDI to the binary log for distributed backups.
B MySQL keeps InnoDB metadata changes in .sdi files in datadir.
C The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
D MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
E MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Which two are characteristics of snapshot-based backups? (Choose two.)

A Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
B There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
C The frozen file system can be cloned to another virtual machine immediately into active service.
D A separate physical copy must be made before releasing the snapshot backup.
E Snapshot backups can be used only in virtual machines.

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

A Run MySQL Server docker containers.
B Use systemd with different settings for each instance.
C Use system tools to lock each instance to its own CPU.
D Start mysqld or mysqld_safe using different option files for each instance.
E Run mysqld with --datadir defined for each instance.
F Use resource groups to lock different instances on separate CPUs.

Join Us Among the Stars

1Z0-908Preview

About the 1Z0-908 Exam

Mode Selection

Question 1

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 7

Question 8

Question 9

Question 10

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27