Download MySQL 8.0 Database Administrator.1Z0-908.ExamTopics.2026-07-12.218q.tqb

Vendor: Oracle
Exam Code: 1Z0-908
Exam Name: MySQL 8.0 Database Administrator
Date: Jul 12, 2026
File Size: 7 MB
Download Exam

How to open TQB files?

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator

Demo Questions

Question 1
Your current system has users with accounts used for development on a MySQL Server host.
The development team requests access without passwords, but this violates company policy.
Which plugin would allow access without passwords while still remaining secure?
  1. connection control plugin
  2. PAM authentication plugin
  3. native LDAP authentication plugin
  4. socket authentication plugin
  5. MySQL firewall plugin
Correct answer: D
Question 2
You must safeguard your applications from SQL injection attack vectors.
Which action must you take?
  1. Encrypt data before transmission to the MySQL server.
  2. Escape characters with special meanings, such as quotes.
  3. Keep a maximum of three user accounts in the mysql.user table.
  4. Compress string data for faster transmission to the server.
Correct answer: B
Question 3
Which are two of the components of MySQL InnoDB Cluster that help to achieve database high availability? (Choose two.)
  1. MySQL Router to ensure that client requests are load balanced and routed to the correct servers
  2. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI
  3. MySQL Enterprise Backup to keep data consistent and always ready to be used
  4. MySQL Semi-Sync replication plugin is used to provide cluster consistency
  5. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication
Correct answer: A, B
Question 4
You are attempting to start your mysqld.
Examine this log output:
Which two things must you check? (Choose two.)
  1. for the possibility that the files are locked by another process
  2. that the TLS/SSL certificates are still valid
  3. for the presence of the missing files in other locations
  4. the configuration file for correct datadir setting
  5. that the user attempting to connect to the database is using the correct username and password
  6. that you are using the correct version of MySQL
Correct answer: C, D
Question 5
Examine the full path name of the backup image from MySQL Enterprise Backup with the --compress option:
/backup/full/mybackup/myimage.img
mysqlbackup.cnf contains this data:
[mysqlbackup]
backup-dir=/backup/full/myrestore
backup-image=/backup/full/mybackup/myimage.img
uncompress
You must perform a database restore to a new machine.
Which command can provision the new database in datadir as /data/MEB?
Correct answer: C
Question 6
You must configure multi-source replication with GTIDs enabled.
You use mysqldump to create the slave.
Which two statements are true? (Choose two.)
  1. You must restore each dump file and execute RESET MASTER on the slave.
  2. You must restore each dump sequentially with the exact included gtid_purged statement.
  3. You must execute multiple CHANGE MASTER statements to create replication channels.
  4. You must always have all or no channels active to maintain a consistent gtid_purged.
  5. You must execute a single CHANGE MASTER statement to create the replication channels.
  6. You must apply the gtid_purged values manually on the slave to start replication.
Correct answer: B, C
Question 7
User `fwuser`@`localhost` is registered with the MySQL Enterprise Firewall and has been granted privileges for the SAKILA database.
Examine these commands that you executed and the results:
You then execute this command:
mysql> CALL mysql.sp_set_firewall_mode('fwuser@localhost', 'RESET');
Which two are true? (Choose two.)
  1. The mysql.firewall_users table is truncated.
  2. The fwuser@localhost account mode is set to OFF.
  3. The firewall resets all options to default values.
  4. The fwuser@1ocalhost account mode is set to DETECTING.
  5. The information_schema.MYSQL_FIREWALl_WHITELIST table is truncated.
  6. The whitelist of the fwuser@localhost account is truncated.
  7. The fwuser@localhost account is removed from the mysql.user table.
Correct answer: B, F
Question 8
Examine this statement, which executes successfully:
Now examine this query:
You want to add one or more indexes that minimize the work done by the query.
Which statement accomplishes this?
Correct answer: B
Question 9
You want to install and configure MySQL on Linux server with tarball binaries in the /app/mysq1/ directory, where the bin directory is found at /app/mysql/bin and the data directory at /app/data.
Which two parameters are required to configure the MySQL instance? (Choose two.)
  1. The configuration basedir=/app/mysql is needed.
  2. The configuration log-bin=/app/data is needed.
  3. The configuration datadir=/app/data is needed.
  4. The configuration datadir=/app/mysql/data is needed.
  5. The configuration innodb_log_group_home_dir=/datadir is needed.
  6. The configuration basedir=/app/mysql/bin is needed.
Correct answer: A, C
Question 10
Examine this statement which executes successfully in database test:
CREATE TABLE `city` (
`ID` int NOT NULL AUTO_INCREMENT,
`Name` char(35) NOT NULL DEFAULT '',
`CountryCode` char(3) NOT NULL DEFAULT '',
`District` char(20) NOT NULL DEFAULT '',
`Population` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `CountryCode` (`CountryCode`)
) ENGINE=InnoDB TABLESPACE=innodb_file_per_table;
What is the content of the test folder in the data directory?
  1. city.ibd and city.sdi
  2. city.ibd
  3. city.MYD, city.MYI, and city.sdi
  4. city.ibd and city.frm
  5. city.ibd, city.frm, and city.sdi
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!