Oracle 1z0-883 Dumps
Exam: MySQL 5.6 Database Administrator
|1z0-883 Premium VCE File|
|1z0-883.vce - Exam-Labs Verified - Instant Download
Get Latest & Verified 1z0-883 Exam Questions with 30-Days Free Updates
100 Questions & Answers
Oracle 1z0-883 Exam Tutorial
Question No : 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 No : 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.
D. The servers SQL mode, when globally set on a slave server, applies to events sent from the master.
Question No : 3
MySQL is installed on a Linux server and has the following configuration:
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 No : 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 No : 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 No : 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
A. -- quick
B. -- skip-buffer
C. -- single-transaction
D. -- tab
Question No : 7
Which three methods will show the storage engine for the Country table?
A. SHOW CREATE TABLE Country;
B. SHOW ENGINE Country STATUS;
D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= Country;
E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= Country;
Question No : 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?
C. FLUSH PRIVILEGES;
D. FLUSH HOST CACHE;
Question No : 9
You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?
B. Shell> service mysql safe_exit
C. Shell> /etc/init.d/mysql stop
E. Mysql> STOP PROCESS mysqld;
F. Shell> net stop mysql
G. Shell> nmc mysql shutdown
Question No : 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 No : 11
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage
A. Mysql Enterprise Backup
D. File system snapshots
Question No : 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.
Question No : 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.
Question No : 14
Which hardware storage option, when set up with redundant disks, offers the least stability,
availability, and reliability for Mysql data?
A. RAID 5
C. SAN (Storage Area Network)
D. NFS (Networked File System)
Question No : 15
Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = Jacksonville AND CountryCode
= USA \G
******************************** 1. row ********************************
Ref: const, const
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.
Question No : 16
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
You do not notice the spelling error in binrylog_format and restart your production server.
How does the MySQL server behave with incorrectly spelled options?
A. Mysqld uses internal configuration versioning and reverts to the previous configuration.
B. When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.
C. The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.
D. Mysqld prints to the error log about an unknown variable, and then exits.
Question No : 17
Which two events will cause a slave server to create a new relay log file?
A. Starting of the I/O thread
B. Execution of the FLUSH LOGS statement
C. Starting of the SQL thread
D. Reaching the slave_pendign _jobs_size_max limit
E. Execution of FULSH TABLES WITH READ LOCK
Question No : 18
In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?
A. Disk usage when storing data
B. Syntax when writing queries involving JOINS
C. Comparing the encoded data with similar columns on other tables
D. Memory usage when working with the data
E. Character set mapping index hash size
Question No : 19
Which two statements are true about InnoDB auto-increment locking?
A. The auto-increment lock can be a table-level lock.
B. InnoDB never uses table-level locks.
C. Some settings for innodb_autoinc_lock_mode can help reduce locking.
D. InnoDB always protects auto-increment updates with a table-level lock.
E. InnoDB does not use locks to enforce auto-increment uniqueness.
Question No : 20
You have been notified that the apps . reports table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup
contains all the tables from the instance, and the apps . reports table must be restored
without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?
A. Restore the backup to another databases instance and obtain a copy of the reports table individually.
1z0-883 Training Products
1z0-883 Premium File
- 100 Questions & Answers
- Instant Download