Exam Code: 1Z0-883 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: MySQL 5.6 Database Administrator
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-883 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-883 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-883 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-883-exam-dumps.html
Q21. The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?
A. A primary key must exist for creation of a clustered index.
B. A primary key is used as a clustered index.
C. A clustered index is a grouping of indexes from different tables into a global index for faster searching.
D. If no indexes exist, a hidden clustered index is generated based on row IDs.
E. A clustered index provides direct access to a page containing row data.
F. The first unique index is always used as a clustered index and not a primary key.
G. A clustered index allows fulltext searching within InnoDB,
Answer: B,D,G
Reference: http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html
Q22. 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
$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?
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.
Answer: B
Q23. 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?
A. Disabling connections from named pipes or socket files (depending on the operating system of the server)
B. Running the server with – skip-networking specified
C. Limiting logins to originate from the application server or the server’s subnet
D. Starting the server with – bind- address=0.0.0.0 specified
E. Installing Mysql on the application server, and running the database and application on the same server
F. Enabling and using SSL for connections to the Mysql database
Answer: E,F
Q24. Which two statements are true regarding partitioning in Mysql?
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.
Answer: C,D
Q25. The ‘allplicationdb’ is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather the following information:
[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0
Three tables are stored in the innoDB shared tablespace and the details are as follows:
The table data_current has 1,000,000 rows.
The table data_reports has 1,500,000 rows.
The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 …
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.
Shell> mysqldump – u root – p applicationdb data_archive > /backup/data_archive.sql Mysql> DROP TABLE data_archive;
Which set of actions will allow you to free disk space back to the file system?
A. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back
to the file system:
Mysql> OPTIMIZE TABLE data_current, data_reports;
B. Set the server to use its own tablespace, and then alter the table so that data is moved
from the shared tablespace to its own:
Mysql> SET GLOBAL innodb_file_per_table=1;
Mysql> ALTER TABLE data_current ENGINE=InnoDB;
Mysql> ALTER TABLE data_repors ENGINE=InnoDB;
C. Take a backup, stop the server, remove the data files, and restore the backup:
Shell> mysqldump – u root –p applicationdb / > /backup/applicationdb.sql
Shell> /etc/init.d/mysql stop
Shell> cd /var/lib/mysql/
Shell> rm ibdata1 ib_logfile0 ib_logfile1
Shell> /etc/init.d/mysql start
Shell> mysql – u root – p applicationdb < /backup/applicationdb.sql
D. Enable compression on the table, causing InnoDB to release unused pages on disk to
the file system:
Mysql> SET GLOBLE innodb_file_per_table=1;
Mysql> SET GLOBLE innodb_file_format=Barramcuda;
Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
Mysql> ALTER TABLE data_history ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
Answer: D
Q26. Which two capabilities are granted with the SUPER privilege?
A. Allowing a client to kill other client connections
B. Allowing a client to shut down the server
C. Allowing change of the server runtime configuration
D. Allowing client accounts to take over the account of another user
Answer: A,B
Reference: http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html
Q27. User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A. UPDATE pets…
B. SELECT….FROM pets
C. INSERT INTO pets…
D. ALTER TABLE pets…
Answer: B
Q28. 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?
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;
Answer: A
Q29. You have a login-path named “adamlocal” that was created by using the
mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command: $ mysql_config_editor print –login-path=adamlocal What is the expected output of this command?
A. The command prints all parameters for the login-path. The password is printed in plain text.
B. The command prints all parameters for the login-path. The password is shown only when you provide the –password option.
C. The command prints all parameter for the login-path. The password is replaced with stars.
D. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
Answer: C
Q30. Consider the Mysql Enterprise Audit plugin.
Which statement is true when you identify a connection event that has used external authentication?
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.
Answer: C
