Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Dumpsbuddy Logo
  1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-883
  5. MySQL 5.6 Database Administrator Questions and Answers
Note! Oracle has retired the 1z0-883 Exam Contact us through Live Chat or email us for more information.

1z0-883 MySQL 5.6 Database Administrator Questions and Answers

Questions 4

Consider the MySQL Enterprise Audit plugin.

On attempting to start the MySQL service after a crash, notice the following error:

[ERROR] Plugin ‘audit_log’ init function returned error.

In the audit log file, you notice the final entry:

…

TIMESTAMP=”2013-07-09T02:12:35”

NAME=”Connect”

CONNECTION_ID=”98”

STATUS=”0”

USER=”Kate”

PRIV_USER=”kate”

OS_LOGIN=””

HOST=”localhost”

DB=””/>

What action should you take to fix the error and allow the service to start?

Options:

A.

Re-install the audit plugin.

B.

Execute the command FLUSH LOGS.

C.

Execute the command SET GLOBAL audit_log_fiush= ON.

D.

Move or rename the existing audit.log file.

Buy Now
Questions 5

Consider the Mysql Enterprise Audit plugin.

Which statement is true when you identify a connection event that has used external authentication?

Options:

A.

The attribute “STATUS” is set to the string EXTERNAL_AUTH.

B.

The attribute “PRIV_USER” contains the username.

C.

The event type that is given in the attribute “NAME” is EXTERNAL_AUTH.

D.

There is no differentiation between native and external authentication events.

E.

External authentication is managed through external auditing logs.

F.

The “PROXY_PRIV” user shows a username if external authentication is used.

Buy Now
Questions 6

What are three actions performed by the mysql_secure_installation tool?

Options:

A.

It prompts you to set the root user account password.

B.

It checks whether file permissions are appropriate within datadir.

C.

It asks to remove the test database, which is generated at installation time.

D.

It can delete any anonymous accounts.

E.

It verifies that all users are configuration with the longer password hash.

Buy Now
Questions 7

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be ”rolled forward” to provide all the latest data.

The SHOW SLAVE STATUS indicates the following values:

RELAY_LOG_FILE = hostname-relay-bin.00004

RELAY_LOG_POS = 1383

Which command set would make the slave current?

Options:

A.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

B.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = ‘hostname-relay-bin.00004’ , RELAY_LOG_POS = 1383;

C.

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

D.

STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;

Buy Now
Questions 8

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl’

What is the cause of the error?

Options:

A.

The --- ssl level was not specified.

B.

The server was not started with the – enable--ssl-plugin option.

C.

-- ssl is not a valid server option.

D.

The mysqld binary was not compiled with SSL support.

E.

The server’s SSL certificate was invalid.

Buy Now
Questions 9

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:

$ pidof mysqld

3132

$tail - n2 /var/lib.mysql/hostname.err

2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.

Version: ‘5.6.13-enterprise-commercial-advaced’ socket: ‘/tmp/mysql.sock’ port;

3306 Mysql Enterprise Server – Advanced Edition (Commercial)

You attempt to log in as the root user with the following command:

$mysql –u root

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Which statement is true about this scenario?

Options:

A.

The RPM installation script sets a default password of password for new installations.

B.

The local root user must log in with a blank password initially: mysql –u root –p.

C.

New security measures mean that the mysql_secure_installation script must be run first on all new installations.

D.

The mysql_install_bd post-installation script used – random-password.

Buy Now
Questions 10

A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event.

The server is configured with:

You have identified that the DELETE statement to skip has the Global Transaction Identifier (GTID) ‘dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with:

Mysqlbinlog – exclude-gtides=’ dbbe07da-fe25-11e2-b6c7-0800274aa49e:5’ binlog.00000.2 | mysql

However all events were skipped instead of just the one deleting the wrong row.

What is the reason for this?

Options:

A.

Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs.

B.

The server keeps track of which GTIDs have already been executed and skips those.

C.

Enforce_gtid_consistency is set to ON.

D.

Gtid_mode must be set to AUTO during point in time recoveries.

Buy Now
Questions 11

When backing up a replication slave, which three should also be backed up in addition to data?

Options:

A.

The master.info and relay.info files

B.

The relay log files

C.

The relay index file

D.

Mysql.slave_master_info table

E.

Mysql.slave_relay_log_info table

F.

Mysql.slave_worker_info table

Buy Now
Questions 12

Which two statements are true regarding partitioning in Mysql?

Options:

A.

Tables with BLOB and TEXT columns cannot be partitioned.

B.

Partitioning allows easier management of smaller data sets for certain queries.

C.

Partitioning allows different columns to be stored in separate files.

D.

The partitioning expression is an integer or function that returns an integer value or NULL value.

E.

Partitioning is only available for those storage engines that implements it natively.

Buy Now
Questions 13

You are using the performance Schema to investigate replication on a slave:

Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime

 FROM performance_schema.events_waits_summary_by_thread_by_event_name

 INNER JOIN performance_schema_threads USING (THREAD_ID)

 WHERE threads .NAME LIKE ‘thread/sql/slave\-%’

 GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output?

Options:

A.

At most two schemas are being updated concurrently.

B.

The server needs more cores to use all slave threads.

C.

The slave cannot process the relay log fast enough to use all threads.

D.

The slave is configured with slave_parallel_workers = 4.

Buy Now
Questions 14

Which three data components are needed for point-in-time recovery?

Options:

A.

The error log

B.

The backup log

C.

The general query log

D.

Binary logs

E.

The data backup

F.

Configuration files

Buy Now
Questions 15

You use—login-path to access a MySQL server on a Linux installation.

Which statement is true about the – login-path option that is created by using mysql_config_editor?

Options:

A.

All system users have access to the MySQL server via—login path local.

B.

__login-path can be used only for MySQL servers running on a local machine.

C.

__login-path allows you to provide login credentials without passing clear text passwords on the command line.

D.

When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.

Buy Now
Exam Code: 1z0-883
Exam Name: MySQL 5.6 Database Administrator
Last Update: Sep 8, 2024
Questions: 100