Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 71:

  Review the definition of the phone_list view.

  CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= `root'@localhost' SQL SECURITY DEFINER VIEW `phone_list' AS SELECT

  e . id as id

  `e . first_name AS `first_name'

  `e . last_name AS `last_name'

  `coalesce ( ph1.phone_no, `--') AS `office_no'

  `coalesce (ph2 .phone_no, '--`) AS `cell_no'

  FROM employees e

  LEFT JOIN employee_phone ph1

  ON ph1.emp_id = e.id AND ph1.type = `office'

  LEFT JOIN employee_phone ph2

  ON ph2 .emp_id = e.id AND ph2 .type = `mobile'

  The tables employees and employee_phone are InnoDB tables; all columns are used in this view.

  The contents of the phone_list view are as follows:

  Mysql> select * from phone_list;

  

  1 row in set (0.00 sec)

  Which method can you use to change the cell_no value to `555-8888' for John Doe?

  A. DELETE FROM phone_list WHERE first_name= `John' and last_name= `Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES (`John' , `Doe' , `x1234' , `555-8888);
  B. INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, `555- 8888','mobile');
  C. UPDATE phone_list SET cell_name `555-8888' WHERE first_name= `John' and last_name= `Doe';
  D. UPDATE employee_phone SET phone_no= `555-8888' where emp_id=1;
  B. INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, `555- 8888','mobile');

• Question 72:

  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
  C. The mysql client with the enable-cleartext-plugin option

• Question 73:

  ROW-based replication has stopped working. You investigate the error log file and find the following entries:

  2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;

  Can't find record in `t1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in `t1'

  Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log `56_master- bin. 000003' position 684

  Why did you receive this error?

  A. The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
  B. The table definition on the slave -litters from the master.
  C. Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
  D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.
  D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.

• Question 74:

  Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?

  A. Mysql Replication
  B. Distributed Replicated Block Device (DRBD) and Mysql
  C. Windows Cluster and Mysql
  D. Solaris Cluster and Mysql
  E. Mysql NDB Cluster
  A. Mysql Replication
  C. Windows Cluster and Mysql
  D. Solaris Cluster and Mysql

• Question 75:

  You have forgotten the root user account password. You decide to reset the password and execute the following:

  Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start skip-grant tables

  Which additional argument makes this operation safer?

  A. --skip-networking, to prohibit access from remote locations
  B. --reset-grant-tables, to start the server with only the mysql database accessible
  C. --read-only,to set all data to read-only except for super users
  D. --old-passwords, to start Mysql to use the old password format while running without the grant tables
  B. --reset-grant-tables, to start the server with only the mysql database accessible

• Question 76:

  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.
  C. The event type that is given in the attribute "NAME" is EXTERNAL_AUTH.

• Question 77:

  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.
  A. The auto-increment lock can be a table-level lock.

• Question 78:

  What are three actions performed by the mysql_secure_installation tool?

  A. It prompts you to set the root user account password.
  B. It checks whether file permissions are appropriate within datadir.
  C. It asks to remove the test database, which is generated at installation time.
  D. It can delete any anonymous accounts.
  E. It verifies that all users are configuration with the longer password hash.
  A. It prompts you to set the root user account password.
  C. It asks to remove the test database, which is generated at installation time.
  D. It can delete any anonymous accounts.

• Question 79:

  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;
  A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

• Question 80:

  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 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.
  B. The local root user must log in with a blank password initially: mysql u root p.