Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

You want to log only the changes made to the database objects and data on the MySQL system.

Which log will do this by default?

A.

general query log

B.

audit log

C.

slow query log

D.

binary log

E.

error log

Examine this command and output:

Which statement is true?

A.

Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B.

Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C.

Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D.

Firewall_access_granted is the number of connections granted from whitelisted hosts.

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

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

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;

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

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

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Which two statements are true? (Choose two.)

A.

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions

will free up disk space.

B.

Executing ALTER TABLE transactions will enable you to free up disk space.

C.

Truncating the sales and leads table will free up disk space.

D.

Truncating the transactions table will free up the most disk space.

E.

The transactions table was created with innodb_file_per_table=OFF.

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

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.

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

What statement is true about the start attempt?

A.

MySQL server was not started due to a problem while executing process 2732.

B.

MySQL server continued to start up even though another process existed.

C.

systemd found the mysqld service disabled and failed to start it.

D.

systemd waited for 30 seconds before timing out and start up failed.

E.

systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

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.