Free Oracle 1Z0-908 Practice Test & Real Exam Questions

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

Exam Questions: 142
Updated On: Jun 16, 2026

Question #1

Which two queries are examples of successful SQL injection attacks? (Choose two.)

A. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';

B. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

C. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

E. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--';

F. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';

Discussion 0

Correct Answer: B,F Vote an answer

Question #2

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. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

D. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

E. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Discussion 0

Correct Answer: C,D Vote an answer

Question #3

There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

B. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

C. A manual intervention to force group members to be only the working two instances is required.

D. The cluster will shut down to preserve data consistency.

E. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

Discussion 0

Correct Answer: A,D Vote an answer

Question #4

Which three are characteristics of a newly created role? (Choose three.)

A. It is created as a locked account.

B. It can be renamed using the RENAME ROLE statement.

C. It is stored in the mysql.role table.

D. It can be dropped using the DROP ROLE statement.

E. It can be protected with a password.

F. It can be granted to user accounts.

Discussion 0

Correct Answer: D,E,F Vote an answer

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

Question #5

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%';

B. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

D. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

Discussion 0

Correct Answer: A Vote an answer

Question #6

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

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

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

C. automatic locking of user accounts who break your firewall

D. provides stateless firewall access to TCP/3306

E. modifying SQL statement dynamically with substitutions

Discussion 0

Correct Answer: A,B Vote an answer

Question #7

Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is at the metadata object level.

B. The lock is a shared lock.

C. The lock is at the table object level.

D. The lock is an intentional lock.

E. The lock is an exclusive lock.

F. The lock is a row-level lock.

Discussion 0

Correct Answer: E,F Vote an answer

Question #8

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 mysql_config_editor to create an encrypted file.

B. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

C. Use mysql_secure_installation to encrypt stored login credentials.

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

Discussion 0

Correct Answer: A Vote an answer

Question #9

You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

A. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.

B. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.

C. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

E. Replication will work.

Discussion 0

Correct Answer: B Vote an answer

Question #10

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

A. on slave: --replicate-ignore-db=example

B. on master: --replicate-ignore-db=example

C. on slave: --binlog-ignore-db=example

D. on master: --binlog-ignore-db=example

E. on slave: --replicate-wild-ignore=example.%

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1Z0-908 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-908 exam.