Question No. 1

Examine this command, which executes successfully:

$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path

Which activity is performed?

AMySQL Router is configured based on the information in files in directory_path.

BMySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

CMySQL Router is restarted.

DMySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Show Answer

Correct Answer: B

Question No. 2

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

Which method would fail to do this?

Ainstalling and configuring the Connection Control plugin

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

Cusing stored procedures for any database access

Dusing PREPARED STATEMENTS

Show Answer

Correct Answer: C

Question No. 3

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

Abuying more RAM

Bmonitoring OS resources for patterns

Cadding circular replication nodes for increased DML capability

Dbuying more CPU

Ebuying more disk

Fbasing expected growth on an average of the last 3 years

Gconsulting the application team about any future projects and use

Hupgrading to the latest application version

Show Answer

Correct Answer: B, F, G

Question No. 4

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

AAll databases are backed up to the output file.

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

CAll binary logs are deleted from the master.

DAll binary logs are backed up and then deleted.

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

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

Show Answer

Correct Answer: C, E

Question No. 5

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

A/usr/mysql

B/usr/bin

C/etc/my.cnf

D/var/lib/mysql

E/usr

Show Answer

Correct Answer: B

Free Oracle 1Z0-908 Exam Actual Questions

The questions for 1Z0-908 were last updated On Nov 17, 2024