Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Examstrust Logo
examstrust mcafee
  1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-908 - MySQL 8.0 Database Administrator

Oracle 1z0-908 MySQL 8.0 Database Administrator Exam Practice Test

Page: 1 / 14
Total 140 questions
Get 1z0-908 Full Access Download 1z0-908 PDF

MySQL 8.0 Database Administrator Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$43.75  $124.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$61.25  $174.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$38.5  $109.99
Add to Cart
Question 1

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

Options:

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

Question 2

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

Options:

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 3

The data in this instance is transient; no backup or replication will be required. It is currently under performing.

  • The database size is static and including indexes is 19G.
  • Total system memory is 32G.

After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.

Which three changes will provide the most benefit to the instance? (Choose three.)

Options:

A.

innodb_flush_log_at_trx_commit=1

B.

buffer_pool_size=24G

C.

innodb_log_file_size=1G

D.

sync_binlog=0

E.

innodb_doublewrite=0

F.

max_connections=10000

G.

innodb_undo_directory=/dev/shm

Question 4

Which two statements are true about raw binary backups? (Choose two.)

Options:

A.

They are converted to a highly compressible binary format.

B.

The data format is identical to how MySQL stores the data on disk.

C.

They are required to obtain FIPS security compliance.

D.

The resulting files are easily human readable.

E.

They are faster than logical backups because the process is a simple file or file system copy.

Question 5

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

Options:

A.

slave updates logging

B.

semi-sync replication plugin

C.

primary key or primary key equivalent on every table

D.

binary log checksum

E.

binary log ROW format

F.

binary log MIXED format

G.

replication filters

Question 6

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

Options:

A.

ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

B.

ALTER TABLE t1 ENCRYPTION='Y';

C.

ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

D.

ALTER TABLE t1 SET TDE = 'ON';

Question 7

Examine this command, which executes successfully:

Which statement is true?

Options:

A.

Only files for MySQL or Its built-in storage engines are backed

B.

Only non-encrypted files are backed up.

C.

The backup includes only data files and their metadata.

D.

Only InnoDB data and log files are backed up.

E.

Only tables stored in their own tablespaces are backed up.

Question 8

MySQL programs look for option files in standard locations.

Which method will show the option files and the order in which they are read?

Options:

A.

shell> mysqladmin --debug

B.

shell> mysql --print-defaults

C.

shell> mysqld --help --verbose

D.

mysql> SHOW GLOBAL VARIABLES;

Question 9

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

Options:

A.

The slave relay logs should be deleted; then execute START SLAVE;

B.

The relay logs from the master should be used to replace the corrupted relay logs.

C.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D.

The slave needs to be restored from backup.

Question 10

You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

Options:

A.

installing and configuring the Connection Control plugin

B.

avoiding concatenation of SQL statements and user-supplied values in an application

C.

using stored procedures for any database access

D.

using PREPARED STATEMENTS

Question 11

Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

Options:

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 12

A clean shutdown was performed with innodb_fast_shutdown=0.

While you were manipulating files, all files were accidentally deleted from the top-level data directory.

Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

Options:

A.

ibtmp1

B.

undo_001

C.

ib_buffer_pool

D.

ibdata1

E.

mysql.ibd

F.

ib_logfile0

Question 13

Which three are types of information stored in the MySQL data dictionary? (Choose three.)

Options:

A.

performance metrics

B.

InnoDB buffer pool LRU management data

C.

access control lists

D.

view definitions

E.

server runtime configuration

F.

server configuration rollback

G.

stored procedure definitions

Question 14

Examine these statements and output:

Which statement is true?

Options:

A.

The user is logged in with --user=accounting as an option.

B.

The user is authenticated as the anonymous proxy user ‘’@’%’.

C.

The user is authorized as the accounting@localhost user.

D.

The user is authorized as the rsmith@localhost user.

E.

The user failed to define a username and the connecting username defaulted to ‘’@’%’.

Question 15

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

Options:

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.

Question 16

Four nodes are configured to use circular replication.

Examine these configuration parameters for each node:

Which statement is true?

Options:

A.

Each slave thread is responsible for updating a specific database.

B.

Cross-database constraints can cause database inconsistency.

C.

Increasing slave_parallel_workers will improve high availability.

D.

Setting slave_preserve_commit_order to on will improve data consistency.

E.

Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

F.

Setting transaction_allow_batching to on will improve data consistency.

Question 17

Examine this list of MySQL data directory binary logs:

binlog.000001 binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

Options:

A.

All databases are backed up to the output file.

B.

All non-active binary logs are removed from the master.

C.

All binary logs are deleted from the master.

D.

All binary logs are backed up and then deleted.

E.

All databases, excluding master metadata, are backed up to the output file.

F.

All details regarding deleted logs and master metadata are captured in the output file.

Question 18

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

Options:

A.

MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

B.

Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

C.

Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

D.

TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Question 19

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

Options:

A.

It supports only non-blob datatypes.

B.

It does not support the transportable tablespaces feature.

C.

It supports all indexes transparently.

D.

It decrypts data for use in memory.

E.

It enforces encryption from disk to memory and over network transmission.

Question 20

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

Options:

A.

Increase the number of buffer pool instances to 16.

B.

Increase the number of buffer pool instances to 32.

C.

Decrease the number of buffer pool instances to 1.

D.

Increase the number of buffer pool instances to 12.

E.

Decrease the number of buffer pool instances to 4.

Question 21

Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)

Options:

A.

SHOW ENGINE INNODB STATUS;

B.

INFORMATION_SCHEMA.INNODB_METRICS

C.

SHOW TABLE STATUS;

D.

INFORMATION_SCHEMA.STATISTICS

E.

INFORMATION_SCHEMA.INNODB_TABLESTATS

F.

SHOW STATUS;

Load More 1z0-908 Questions
Page: 1 / 14
Total 140 questions
Get 1z0-908 Full Access Download 1z0-908 PDF