1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-908
  5. MySQL 8.0 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions
Questions # 21:

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account? (Choose two.)

Options:
A.

ALTER USER baduser@hostname PASSWORD DISABLED;

B.

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

C.

ALTER USER baduser@hostname ACCOUNT LOCK;

D.

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

E.

ALTER USER baduser@hostname DEFAULT ROLE NONE;

Questions # 22:

A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation.

Which three features are available with this installation method? (Choose three.)

Options:
A.

MySQL Replication monitoring

B.

network-related information and network characteristics

C.

MySQL Query Analysis data

D.

CPU utilization

E.

security-related advisor warnings

F.

operating system memory utilization

G.

disk usage and disk characteristics including disk advisors warnings

Questions # 23:

You have configured MySQL Enterprise Monitor to monitor your MySQL server.

Which four features are available? (Choose four.)

Options:
A.

starting and stopping the MySQL instance

B.

tracing import and export with mysqidump

C.

deploying the MySQL agent on supported target operating system

D.

creating e-mail alerts and SNMP traps for MySQL warnings

E.

monitoring the availability of the MySQL instance

F.

analyzing executed MySQL queries

G.

monitoring of NDB Cluster API nodes

Questions # 24:

Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

Options:
A.

DESCRIBE manufacturing.parts;

B.

SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’ AND TABLE_NAME=’parts’;

C.

SHOW INDEXES FROM manufacturing.parts;

D.

SELECT * FROM information_schema.COLUMN_STATISTICS;

E.

EXPLAIN SELECT INDEXES FROM manufacturing.parts;

Questions # 25:

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

Questions # 26:

Which three actions are effective in capacity planning? (Choose three.)

Options:
A.

buying more RAM

B.

monitoring OS resources for patterns

C.

adding circular replication nodes for increased DML capability

D.

buying more CPU

E.

buying more disk

F.

basing expected growth on an average of the last 3 years

G.

consulting the application team about any future projects and use

Questions # 27:

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Options:
A.

recording the order in which queries are issued

B.

audit of all queries

C.

point-in-time recovery

D.

replication

E.

logging the duration and locks for all queries

Questions # 28:

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.

Which command will back up the databases in parallel?

Options:
A.

mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

B.

mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

C.

mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

D.

mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

Questions # 29:

Examine this query:

Question # 29

What information does this query provide?

Options:
A.

total memory used across all connections associated with the user on connection number 10

B.

total memory used by the first 10 connections

C.

total memory used by thread number 10

D.

total memory used across all connections associated with the user on thread number 10

E.

total memory used by connection number 10

F.

total memory used by the first 10 threads

Questions # 30:

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:

Question # 30

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

Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions