Oracle 1z0-883 today updated questions - Verified by Oracle Experts

MySQL 5.6 Database Administrator Questions and Answers

Question 1

A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:

Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') '

Skip_Counter: 0

Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8

Auto _Position: 1

You execute a “SHOW CREATE TABLE mytable” on the slave:

CREATE TABLE ‘mytable’ (

‘ID’ int(11) NOT NULL DEFAULT ‘0’,

‘name’ char(10) DEFAULT NULL,

PRIMARY KEY (‘ID’)

)

The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.

Which statement should be used?

Options:

SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

SET GTID_NEXT=”CONSISTENCY”;

BEGIN; COMMIT;

SET GTID_NEXT=” AUTOMATIC’;

SET GLOBAL enforce_gtid_consistency=ON

SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;

SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;

BEGIN; COMMIT;

SET GTID_NEXT=”AUTOMATIC”;

Question 2

A general purpose MySQL instance is configured with the following options:

-- log-slow-queries

-- long-query-time=,0001

-- log-slow-admin-queries

-- general-log

-- log-bin

-- binlog-format=STATEMENT

-- innodb-flush-log-at-trx-commit=1

Which three statements are true?

Options:

The General Query Log records more data than the Binary Log.

The binary Log records more data than the General Query Log.

The Slow Query Log records more data than the General Query Log.

The General Query Log records more data than the Slow Query Log.

The Slow Query Log records more data than the Binary Log.

The Binary Log records more data than the Slow Query Log.

Question 3

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:

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

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

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

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

Question 4

The validate_password plugin is loaded and displays the following settings in global variables:

Mysql> SHOW VARIABLES LIKE ‘validate_password%’;

When attempting to set your password, you get the following error:

Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

What is the cause of the error?

Options:

The password is eight characters long, but needs to exceed validate_password_length to be valid.

All of the MEDIUM password policy requirements have not been honored.

The password matches a substring Hover as a dictionary word.

The password does not match the validate_passoword_number_count requirement.

There is no dictionary file defined, so password validation cannot work as expected.

Question 5

Which two are correct steps in taking a binary backup of MyISAM tables?

Options:

Always stop the server prior to the backup.

Stop the server or lock the tables prior to the backup.

Stop the server or lock the databases prior to the backup.

Make a copy of the .frm, .myd, and the .myi files.

Make a copy of the binary log and tablespace files.

Question 6

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:

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

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

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

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

Question 7

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.

Which two will optimize the security of this setup?

Options:

Disabling connections from named pipes or socket files (depending on the operating system of the server)

Running the server with – skip-networking specified

Limiting logins to originate from the application server or the server’s subnet

Starting the server with – bind- address=0.0.0.0 specified

Installing Mysql on the application server, and running the database and application on the same server

Enabling and using SSL for connections to the Mysql database

Question 8

Consider the Mysql Enterprise Audit plugin.

A CSV file called data.csv has 100 rows of data.

The stored procedure prepare_db ( ) has 10 auditable statements.

You run the following statements in the mydb database:

Mysql> CALL prepare_db ( );

Mysql> LOAD DATA INFILE ‘/tmp/data.cav’ INTO TABLE mytable;

Mysql> SHOW TABLES;

How many events are added to the audit log as a result of the preceding statements?

Options:

102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.

3; only the top-level statements are logged.

111; top-level statements and all lower-level statements are logged.

12; only top-level statements and stored procedure events are logged.

Question 9

Which two statements are true about InnoDB auto-increment locking?

Options:

The auto-increment lock can be a table-level lock.

InnoDB never uses table-level locks.

Some settings for innodb_autoinc_lock_mode can help reduce locking.

InnoDB always protects auto-increment updates with a table-level lock.

InnoDB does not use locks to enforce auto-increment uniqueness.

Question 10

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

Options:

Mysql Enterprise Backup

Mysqldump with – binary-data option

Mysqlhotcopy

File system snapshots

Mysqldumpslow

Question 11

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

Options:

It is provided by means of IP- level disk replication.

It is shared-nothing architecture.

It implements High Availability by using the .NET Connector’s load balancing capabilities.

It relies on the shared disk architecture being visible to both servers.

Question 12

Your developers have created table to store some of their program’s data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.

An example of the start of one row of data:

‘GREEN01020495888331993-12-10/2…’

What should you do to improve the overall performance?

Options:

Convert the column to TEXT and add a fulltext index to the table.

Create multiple prefix indexes of differing lengths.

Convert their column to BINARY.

Redesign the table so that the most commonly searched for string patterns are in their own columns.

Question 13

What are three facts about backups with mysqldump?

Options:

Can back up a remote database server

Allow a consistent backup to be taken

Are always faster to restore than binary backups

Are able to back up specific items within a database

Create automatically compressed backups

Will lock all storage engines for duration of backup

Question 14

Which two statements describe the behavior of the server’s SQL mode?

Options:

The server’s SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.

The server’s SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

The server’s SQL mode can be changed at the session level with a SET SESSION sql_mode=”new_value” command.

The server’s SQL mode, when globally set on a slave server, applies to events sent from the master.

Question 15

Which two capabilities are granted with the SUPER privilege?

Options:

Allowing a client to kill other client connections

Allowing a client to shut down the server

Allowing change of the server runtime configuration

Allowing client accounts to take over the account of another user

Load More 1z0-883 Questions

Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-883 MySQL 5.6 Database Administrator Exam Practice Test

MySQL 5.6 Database Administrator Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation: