Oracle Oracle Database Application Development 1Z0-883 Questions & Answers

• Question 81:

  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.

  Correct Answer: C

• Question 82:

  What are four capabilities of the mysql client program?

  A. Creating and dropping databases

  B. Creating, dropping, and modifying tables and indexes

  C. Shutting down the server by using the SHUTDOWN command

  D. Creating and administering users

  E. Displaying replication status information

  F. Initiating a binary backup of the database by using the START BACKUP command

  Correct Answer: BDEF

• Question 83:

  Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?

  A. Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.

  B. Check the command-line options provided for the Mysql Server and compare them with default values.

  C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.

  D. Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

  Correct Answer: CD

• Question 84:

  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

  3132

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

  Correct Answer: B

• Question 85:

  A Mysql Server has been running an existing application successfully for six months.

  The my.cnf is adjusted to contain the following additional configuration:

  [mysqld]

  Default-authentication-plugin=sha256_password

  The Mysql Server is restarted without error.

  What effect will the new configuration have in existing accounts?

  A. They will have their passwords updated on start-up to sha256_password format.

  B. They will have to change their password the next time they login to the server.

  C. They are not affected by this configuration change.

  D. They all connect via the secure sha256_password algorithm without any configuration change.

  Correct Answer: D

• Question 86:

  Consider the events_% tables in performance Schema.

  Which two methods will clear or reset the collected events in the tables?

  A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;

  B. Using the statement RESET PERFORMANCE CACHE;

  C. Using the statement FLUSH PERFORMANCE CACHE;

  D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current;

  E. Disabling and re-enabling all instruments

  F. Restarting Mysql

  Correct Answer: DE

• Question 87:

  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.

  Correct Answer: C

• Question 88:

  You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?

  A. Ensure that none of the attached slaves are using any of the binary logs you want to delete.

  B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

  C. Execute the PURGE BINARY LOGE NOT USED command.

  D. Remove all of the binary log files that have a modification date earlier than today.

  E. Edit the .index file to remove the files you want to delete.

  Correct Answer: BD

• Question 89:

  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.

  Correct Answer: AD

• Question 90:

  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.

  Correct Answer: B