Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-908 Oracle MySQL 8.0 Database Administrator Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-908 MySQL 8.0 Database Administrator certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-908 Premium Access     Download Demo    
Page: 2 / 3
Total 141 questions

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A.

REQUIRED

B.

VERIFY_CA

C.

VERIFY_IDENTITY

D.

PREFERRED

E.

DISABLED

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

G.

stored procedure definitions

You are using an existing server with a new configuration. MySQL Server fails to start.

Examine this snapshot of the error log:

Which action would allow the server to start?

A.

Remove ib_logfile0 and ib_logfile1 files from the file system.

B.

Execute mysqladmin flush-logs.

C.

First run mysqld --initialize to refresh the Size of ib_logfile.

D.

Create a new ib_logfile0 file of size 26214400.

t is a non-empty InnoDB table.

Examine these statements, which are executed in one session:

BEGIN;

SELECT * FROM t FOR UPDATE;

Which is true?

A.

If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

B.

If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

C.

mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

D.

If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

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.

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

Examine this query and its output:

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.

A user wants to connect without entering his or her username and password on the Linux command prompt.

Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)

A.

$HOME/.my.cnf file

B.

$MYSQL_HOME/my.cnf file

C.

DATADIR/mysqld-auto.cnf file

D.

$HOME/.mylogin.cnf file

E.

$HOME/.mysql/auth/login file

F.

/etc/my.cnf file

G.

$HOME/.mysqlrc file

Examine these commands and output:

Which connection ID is holding the metadata lock?

A.

20

B.

24

C.

21

D.

25

E.

22

F.

6

Examine this statement, which executes successfully:

Now examine this 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);

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.

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

A.

Enable GTID by executing this on the master and the slave:

SET GLOBAL GTID_ENABLED=on;

B.

Execute this on the slave to enable GTID:

START SLAVE IO_THREAD WITH GTID;

C.

Restart MySQL (master and slave) with these options enabled:

--gtid_mode=ON

--log-bin

--log-slave-updates

--enforce-gtid-consistency

D.

Execute this on the slave to enable GTID:

RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

E.

On the slave, alter the MySQL master connection setting with:

ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F.

On the slave, alter the MySQL master connection setting with:

CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

A.

This file is for storing MySQL Server configuration options in ISON format.

B.

This file is for logging purposes only and is never processed.

C.

It is read and processed at the beginning of startup configuration.

D.

It is read and processed at the end of startup configuration.

E.

It is always updated with changes to system variables.

F.

This file is for storing MySQL server_uuid values only.

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A.

dba.configureInstance()

B.

cluster.setPrimaryInstance()

C.

dba.configureLocalInstance()

D.

cluster.forceQuorumUsingPartitionOf()

E.

cluster.addInstance()

F.

dba.createCluster()

G.

dba.checkInstanceConfiguration()

Examine this statement, which executes successfully:

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);

A valid raw backup of the shop.customers MyISAM table was taken.

You must restore the table. You begin with these steps:

1.Confirm that secure_file_priv=’/var/tmp’

2.mysql> DROP TABLE shop.customers;

3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/

Which two actions are required to complete the restore? (Choose two.)

A.

shell> cp /backup/customers.sdi /var/tmp

B.

shell> cp /backup/customers.sdi /var/lib/mysql/shop/

C.

mysql> SOURCE ‘/var/tmp/customers.sdi’

D.

mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

E.

shell> cp /backup/customers.frm /var/lib/mysql/shop/

F.

mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

G.

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

A.

Set validate-user-plugins=caching_sha2_password in the configuration file.

B.

Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

C.

Add default_authentication_plugin=mysql_native_password in the configuration file.

D.

Add default_authentication_plugin=sha256_password in the configuration file.

Which three statements are true about MySQL replication? (Choose three.)

A.

Replication can use only TCP/IP connections.

B.

Any instance can have multiple slaves, but it can have only one master.

C.

Each instance in a replication topology must have a unique server ID.

D.

Binary logs contain only transactions originating from a single MySQL instance.

E.

Each slave must have its own MySQL user for replication.

F.

Binary logging must be enabled on the master in order to replicate to other instances.

G.

A replication user must have the SELECT privilege for all tables that need to be replicated.

You want to check the values of the sort_buffer_size session variables of all existing connections.

Which performance_schema table can you query?

A.

user_variables_by_thread

B.

global_variables

C.

variables_by_thread

D.

session_variables

Examine this statement and output:

You must try to reduce query execution time.

Which two queries should you focus on? (Choose two.)

A.

QN = 3

B.

QN = 5

C.

QN = 1

D.

QN = 4

E.

QN = 2

Oracle 1z0-908 Premium Access     Download Demo    
Page: 2 / 3
Total 141 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved