Limited Time Discount Offer
30% Off - Ends in 02:00:00

X

Oracle 1z0-883 Dumps

verified by experts

  • Verified by experts

1z0-883 Premium File

  • 100 Questions & Answers

$39.99

$27.99
Oracle
MySQL 5.6 Database Administrator
Oracle
MySQL 5.6 Database Administrator

Files

File Name
Views
Size
Downloads

62

367.5 KB

43

Files

Views

62

Size

367.5 KB

Downloads

43

Questions & Answers for Oracle 1z0-883

Showing 1-15 of 100 Questions

Question #1

What are three facts about backups with mysqldump?

A. Can back up a remote database server

B. Allow a consistent backup to be taken

C. Are always faster to restore than binary backups

D. Are able to back up specific items within a database

E. Create automatically compressed backups

F. Will lock all storage engines for duration of backup

Question #2

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

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

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

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

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

Explanation: A: Modes affect the SQL syntax MySQL supports and the data validation
checks it performs. This makes it easier to use MySQL in different environments and to use
MySQL together with other database servers.
C: To change the SQL mode at runtime, set the global or session sql_mode system
variable using a SET statement:
SET GLOBAL sql_mode = 'modes';
SET SESSION sql_mode = 'modes';
Note: The MySQL server can operate in different SQL modes, and can apply these modes
differently for different clients, depending on the value of the sql_mode system variable.
DBAs can set the global SQL mode to match site server operating requirements, and each
application can set its session SQL mode to its own requirements.
Reference: 5.1.7 Server SQL Modes

Question #3

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the root user, change the datadir location by executing:
Shell> cp R /var/lib/mysql/data/mysql/
Shell> chown R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the mysql user?

A. MySQL cannot be run as the root user.

B. MySQL requires correct file ownership while remaining secure.

C. MySQL needs to be run as the root user, but file cannot be owned by it.

D. The mysqld process requires all permissions within datadir to be the same.

Question #4

Identify a performance impact when using the Performance Schema.

A. There is no impact on performance.

B. There is an overhead for querying the Performance Schema but not for having it enabled.

C. There is a constant overhead regardless of settings and workload.

D. The overhead depends on the settings of the Performance Schema.

Question #5

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that
contains the MySQL data directory.
Why is it important to remove snapshots after completing a RAW backup in this way?

A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.

B. The snapshot size will continue to grow as changes to the volume are made.

C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.

D. The system keeps a copy of changes in memory and can cause an out of memory event.

Question #6

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set
of rows?

A. -- quick

B. -- skip-buffer

C. -- single-transaction

D. -- tab

Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

Question #7

Which three methods will show the storage engine for the Country table?

A. SHOW CREATE TABLE Country;

B. SHOW ENGINE Country STATUS;

C. SHOW TABLE STATUS LIKE ‘Country’;

D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= Country;

E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= Country;

Question #8

You are creating a new server with the same accounts as an existing server. You do this by
importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)
Mysql> show grants for admin@%;
ERROR 1141 (42000): There is no such grant defined for user admin on host %
Which command will fix this issue?

A. CREATE USER ‘admin’ @’%’;

B. GRANT USAGE ON *.* TO ‘admin’@’%’;

C. FLUSH PRIVILEGES;

D. FLUSH HOST CACHE;

E. UPDATE mysql.user SET Create_user_priv = ‘Y’ WHERE user= ‘admin’;

Reference: http://lists.mysql.com/mysql/218268

Question #9

You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?

A. Shell> pkill –u mysql mysqld_safe

B. Shell> service mysql safe_exit

C. Shell> /etc/init.d/mysql stop

D. Shell> mysqladmin –u root –p shutdown

E. Mysql> STOP PROCESS mysqld;

F. Shell> net stop mysql

G. Shell> nmc mysql shutdown

Question #10

An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE %connect%;

8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT TO bob@%, example.com WITH MAX_USER_CONNECTIONS 0;
GRANT TO key@%, example.com WITH MAX_USER_CONNECTIONS 1;
GRANT TO joe@%, example.com WITH MAX_USER_CONNECTIONS 50;
What is a valid explanation for why one of the users is unable to connect to the database?

A. Bob has max_user_connections set to zero, which blocks all his connections

B. Joe has exceeded the max_user_connections global limit.

C. All users are blocked because max_user_connections is accumulated over the host account information.

D. Kay is already connected elsewhere and attempting to log in again.

E. Connect_timeout is too small to allow a connection to occur.

Question #11

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

A. Mysql Enterprise Backup

B. Mysqldump with – binary-data option

C. Mysqlhotcopy

D. File system snapshots

E. Mysqldumpslow

Reference: http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html

Question #12

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?

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

B. 3; only the top-level statements are logged.

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

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

Reference: http://dev.mysql.com/doc/mysql-security-excerpt/5.5/en/audit-log-plugin-
logging-control.html

Question #13

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard
Replication using master-slave replication.
Which two statements are correct?

A. Both technologies use the TCP/IP stack as their primary transmission medium.

B. DRBD uses shared-disk technology.

C. Both technologies guarantee an identical copy of data on the secondary node.

D. Only MySQL can maintain a time-delayed copy of data on the secondary node.

Explanation: A:
* Replication cannot use Unix socket files. You must be able to connect to the master
MySQL server using TCP/IP.
D: Time Delayed replication is however something quite helpful for some environments.
Though DRBD also could be extended to support one if needed.
Not B: DRBD (Distributed Replication Block Device), one of the leading solutions for
MySQL HA (High Availability), offering users:
/ An end-to-end, integrated stack of mature and proven open source technologies, fully
supported by Oracle;
/ Automatic failover and recovery for service continuity;
/ Mirroring, via synchronous replication, to ensure failover between nodes without the risk
of losing committed transactions;
/ Building of HA clusters from commodity hardware, without the requirement for shared-
storage.

Question #14

Which hardware storage option, when set up with redundant disks, offers the least stability,
availability, and reliability for Mysql data?

A. RAID 5

B. iSCSI

C. SAN (Storage Area Network)

D. NFS (Networked File System)

Question #15

Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = Jacksonville AND CountryCode
= USA \G
******************************** 1. row ********************************
Id: 1
Select_type: SIMPLE
Table: City
Type: ref
Possible_keys: name_country_index
Key: name_country_index
Ref: const, const
Rows: 1
Extra: Using where
Which statement best describes the meaning of the value for the key_len column?

A. It shows the total size of the index row.

B. It shows how many columns in the index are examined.

C. It shows the number of characters indexed in the key.

D. It shows how many bytes will be used from each index row.

×