Oracle Oracle Certifications 1Z0-883 Questions & Answers

• Question 61:

  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...

  Correct Answer: B

• Question 62:

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

  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

  Correct Answer: ABE

• Question 63:

  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

  Correct Answer: CDE

• Question 64:

  Which statement is true about FLUSH LOGS command?

  A. It requires the RELOAD, FILE, and DROP privileges.

  B. It closes and reopens all log files.

  C. It closes and sends binary log files to slave servers.

  D. It flushes dirty pages in the buffer pool to the REDO logs.

  Correct Answer: B

• Question 65:

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

  A. Always stop the server prior to the backup.

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

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

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

  E. Make a copy of the binary log and tablespace files.

  Correct Answer: BD

• Question 66:

  You want to start monitoring statistics on the distribution of storage engines that are being used and the

  average sizes of tables in the various databases.

  Some details are as follows:

  The Mysql instance has 400 databases.

  Each database on an average consists of 25-50 tables.

  You use the query:

  SELECT TABLE_SCHEMA, ‘ENGINE’, COUNT (*), SUM (data_length) total_size

  FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‘BASE TABLE’ GROUP BY TABLE_SCHEMA, ‘ENGINE’ ;

  Why is this query slow to execute?

  A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.

  B. Collecting information requires various disk-level operations and is time consuming.

  C. Aggregating details from various storage engine caches for the final output is time consuming.

  D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.

  Correct Answer: B

• Question 67:

  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

  Correct Answer: AB

• Question 68:

  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,

  Correct Answer: BDG

• Question 69:

  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

  Correct Answer: EF

• Question 70:

  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)

  Correct Answer: C