Free 1z1-908 Questions for Oracle MySQL 8.0 Database Administrator 1z1-908 Exam as PDF & Practice Test Engine

Exam Code/Number: 1z1-908
Exam Name/Title: MySQL 8.0 Database Administrator
Certification Provider: Oracle
Corresponding Certification: MySQL Database Administration

Exam Questions: 142
Updated On: Sep 08, 2026

Question #1

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

A. replication filters

B. semi-sync replication plugin

C. slave updates logging

D. primary key or primary key equivalent on every table

E. binary log checksum

F. binary log MIXED format

G. binary log ROW format

Discussion 0

Correct Answer: B,D,F Vote an answer

Question #2

Which two are features of MySQL Enterprise Firewall? (Choose two.)

A. modifying SQL statement dynamically with substitutions

B. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

C. blocking of potential threats by configuring pre-approved whitelists

D. provides stateless firewall access to TCP/3306

E. automatic locking of user accounts who break your firewall

Discussion 0

Correct Answer: B,C Vote an answer

Question #3

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

A. time zone information and definitions

B. performance monitoring information

C. plugins

D. audit log events

E. help topics

F. rollback segments

G. information about table structures

Discussion 0

Correct Answer: C,E,F Vote an answer

Question #4

Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

A. ALTER USER 'joe'@'%' PASSWORD HISTORY 0

B. REVOKE USAGE ON *.* FROM 'joe'@'%'

C. ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

D. ALTER USER 'joe'@'%' SET password='*invalid*'

E. REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

F. ALTER USER 'joe'@'%' ACCOUNT LOCK

Discussion 0

Correct Answer: C,E Vote an answer

Question #5

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. --protocol=pipe

B. --port=3306

C. --socket=/tmp/mysql.sock

D. --shared-memory-base-name=world

E. --user=admin

F. --host=192.0.2.1

G. --protocol=UDP

H. --database=world

I. --password

Discussion 0

Correct Answer: A,D,F,I Vote an answer

Question #6

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

A. It creates a logical backup of all metadata, but contains no table data.

B. It returns an error because the mysqldump command should have been used.

C. It creates a logical backup of all MySQL user accounts.

D. It creates a logical backup of only the users database.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

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 a text editor to create a new defaults file and encrypt it from Linux prompt.

B. Use the AES_ENCRYPT() MySQL function on the option file.

C. Use mysql_secure_installation to encrypt stored login credentials.

D. Use mysql_config_editor to create an encrypted file.

Discussion 0

Correct Answer: D Vote an answer

Question #8

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

A. At least one of the tables in the join must have a hash index.

B. The smallest of the tables in the join must fit in memory as set by join_buffer_size.

C. The query must access no more than two tables.

D. No index can be used for the join.

Discussion 0

Correct Answer: C Vote an answer

Question #9

A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

A. You use the InnoDB storage engine and statements wait while data is inserted.

B. Your table accesses wait for the operating system level flush.

C. The Innodb Buffer pool is full.

D. You use the MyISAM storage engine for most common tables.

Discussion 0

Correct Answer: A Vote an answer

Free 1z1-908 Questions for Oracle MySQL 8.0 Database Administrator 1z1-908 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-908 Demo