Oracle Oracle Certifications 1Z0-883 Questions & Answers

• Question 51:

  Following a server crash, the automatic recovery of InnoDB fails.

  How would you begin to manually repair the InnoDB tables?

  A. Start the server with the innodb_force_recovery option set to a non-zero value.

  B. Start the server as usual, and then execute the REPAIR TABLE command.

  C. Start the server as usual, and then execute the CHECK TABLE command.

  D. Start the server with the innodb_recover_options option set to FORCE.

  Correct Answer: A

• Question 52:

  What are three methods to reduce Mysql server exposure to remote connections?

  A. Setting -- skip-networking when remote connections are not required

  B. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

  C. Setting specific GRANT privilege to limit remote authentication

  D. Setting mysql_secure_configuration to enable paranoid mode

  E. Using SSL when transporting data over remote networks

  Correct Answer: BCD

• Question 53:

  The following commands are available in the Linux binary distributions of Mysql:

  Mysqld

  Mysqld_safe

  Mysql.server

  What is the correct description of each of these commands?

  A. Mysqld is the server. Mysqld_safe is a shell script that invokes mysqld. Mysql.server is a wrapper for mysql_safe.

  B. Mysqld is a shell script that starts mysql.server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is the server.

  C. Mysqld is the server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is a wrapper for mysqld_safe.

  D. Mysql, mysqld.safe, and mysql.server reside in different locations but are all symlinked to the same script.

  Correct Answer: B

• Question 54:

  Which three statements describe how the strict SQL mode provides added security?

  A. It rejects statements that try to insert out-of-range values

  B. It rejects invalid dates.

  C. It limits the operations that the server can perform.

  D. It rejects queries that produce out-of-range values.

  E. It rejects dates with zero day or month values.

  Correct Answer: CDE

• Question 55:

  You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:

  ERROR 2059 (HY000): Authentication plugin `mysql_clear_password' connot be loaded: plugin not enabled

  What would you run to fix the issue?

  A. The mysql client with the ignore-password-hashing option

  B. The mysql_secure_installation script to update server security settings

  C. The mysql client with the enable-cleartext-plugin option

  D. The mysql_upgrade script

  E. The install plugin command for the mysql_cleartext_password plugin

  Correct Answer: C

• Question 56:

  You want a record of all queries that are not using indexes. How would you achieve this?

  A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

  B. By enabling the Error Log because not using indexes is an error

  C. By enabling the Slow Query Log and using the log-queries-not-using-indexes option

  D. By enabling the Error Log and using the log-queries-not-using-indexes option

  Correct Answer: C

• Question 57:

  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?

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

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

  C. The password matches a substring Hover as a dictionary word.

  D. The password does not match the validate_passoword_number_count requirement.

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

  Correct Answer: B

• Question 58:

  Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.

  This requires the following config file options:

  Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1

  However, this configuration is expected to introduce disk I/O overhead.

  What three changes will reduce disk I/O overheads?

  A. Use of soft links for database directories on the same physical disk

  B. Use of separate directories on the same physical disk for log files and data files

  C. Placement of InnoDB log files and datadir on separate physical disks

  D. Allocation of RAM to the buffer pool such that more of the data can fit in RAM

  E. Use of delay_key_write=ON for batch index update

  Correct Answer: CDE

• Question 59:

  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

  Correct Answer: AB

• Question 60:

  Consider the following table:

  REATE TABLE ‘game’ (

  ‘id’ int (10) unsigned NOT NULL AUTO_INCREMENT,

  ‘keyword’ varchar (45) DEFAULT NULL,

  ‘date’ datetime NOT NULL,

  PRIMARY KEY (‘id’ , ‘date’),

  UNIQUE KEY ‘keyword_idx’ (‘keyword’ , ‘date’)

  ) ENGINE=InnoDB DEFAULT CHARSET=latin1

  PARTITION BY RANGE (TO_DAYS (date) ) (

  PARTITION g201301 VALUES LESS THAN (TO_DAYS (‘2013-01-01 00:00:00’) ),

  PARTITION g201302 VALUES LESS THAN (TO_DAYS (‘2013-02-01 00:00:00’) ),

  PARTITION g201303 VALUES LESS THAN (TO_DAYS (‘2013-03-01 00:00:00’) ),

  PARTITION g201304 VALUES LESS THAN (TO_DAYS (‘2013-04-01 00:00:00’) ),

  PARTITION gMORES VALUES LESS THAN (MAXVALUE) );

  Which method should used to add a new g201305 partition to the table?

  A. ALTER TABLE games REORGANIZE PARTITION (gMORES) INTO g01305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

  B. ALTER TABLE games ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') );

  C. ALTER TABLE games COALESCE PARTITION (gMORES) INTO g01305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

  D. ALTER TABLE games SPLIT PARTITION (gMORES) INTO g201305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

  E. ALTHER TABLE games DROP PATITION gMORES, ADD PARTITION g201305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

  Correct Answer: B