Exit demo 1Z0-908 MySQL 8.0 Database Administrator PDF format · free preview

Oracle 1Z0-908 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-908.html

Question 1
Multiple choice

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 an intentional lock.

D.

The lock is at the table object level.

E.

The lock is a row-level lock.

F.

The lock is an exclusive lock.

Question 2
Single choice

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.

Question 3
Multiple choice

Examine this command, which executes successfully:

mysqlpump --user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

A.

information_schema

B.

world

C.

employee

D.

sys

E.

mysql

Question 4
Multiple choice

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.

G.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Question 5
Multiple choice

Which two statements are true about MySQL Installer? (Choose two.)

A.

It installs most Oracle MySQL products.

B.

It performs product upgrades.

C.

It provides only GUI-driven, interactive installations.

D.

Manual download of separate product packages is required before installing them through MySQL Installer.

E.

It provides a uniform installation wizard across multiple platforms.

Question 6
Multiple choice

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

Question 7
Multiple choice

Examine this command, which executes successfully:

cluster.addInstance(`<user>@<host>:<port>', {recoveryMethod: `clone'})

Which three statements are true? (Choose three.)

A.

The account used to perform this recovery needs the BACKUP_ADMIN privilege.

B.

A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

C.

InnoDB tablespaces outside the datadir are able to be cloned.

D.

It is always slower than {recoveryMethod: `incremental'}.

E.

A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

F.

InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Question 8
Single choice

How can mysql_multi be configured to allow MySQL instances to use the same port number?

A.

The instances use different user accounts unique to each instance.

B.

The instances listen on different IP addresses.

C.

The instances use different socket names.

D.

The instances have appropriate net masks set.

Question 9
Multiple choice

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

A.

MyISAM

B.

NDB

C.

MEMORY

D.

ARCHIVE

E.

InnoDB

Question 10
Single choice

Examine these statements, which execute successfully:

CREATE ROLE r_world_rd;

GRANT SELECT ON world.* TO r_world_rd;

CREATE USER john IDENTIFIED BY `P@ssw0rd';

GRANT r_world_rd TO john;

Examine these statements issued by user John:

What is the reason for the error?

A.

The statement was blocked by MySQL Firewall.

B.

John has not activated the role.

C.

John needs to reconnect to the database.

D.

The DBA needs to execute FLUSH PRIVILEGES.

Showing 10 of 140 questions · Unlock the full set