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

• Question 1:

  A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0

  What happens when you execute an UPDATE statement without a WHERE clause?

  A. Results in an error

  B. Updates every row in the specified table(s)

  C. Results in - -safe-updates being enabled automatically

  D. Causes a syntax error

  Correct Answer: A

• Question 2:

  Assume the user has just connected to the MySQL server. What is the result of the query SELECT @ a?

  A. An error that @ a is undefined

  B. A single NULL

  C. An empty string

  D. The value of GLOBAL variable @ a

  Correct Answer: D

• Question 3:

  You want to use the SHA -256 Authentication plugin with Connector/J. Which two parameter settings achieve this?

  A. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jd bc

  B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin

  C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

  D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin

  Correct Answer: A

• Question 4:

  Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage;

  

  SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

  

  You add an index on the Isofficial column. Which two statement are true?

  A. The optimizer will choose the index when Isofficial='T' is in the WHERE clause.

  B. The optimizer will choose the index when Isofficial='F' is in the WHERE clause.

  C. The optimizer will not choose the index on the Isofficial column.

  D. The speed of INSERT statements to this table will be improved.

  E. The speed of INSERT statements to this table will be reduced.

  F. The speed of INSERT statements to this table will be unchanged.

  Correct Answer: CE

• Question 5:

  Inspect the SELECT query:

  Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11';

  

  2 rows in set (0.00 sec) Which action will optimize the query?

  A. Add an index to the employees. emp _no column.

  B. Add the keyword STRAIGHT_JOIN.

  C. Add an index on the to_ date column.

  D. Add the FORCE INDEX (PRIMARY) optimizer hint for the employees table.

  Correct Answer: C

• Question 6:

  You have two lists of values to correlate.

  

  Which query lists all names in colors1 and how many total matches are there in colors2?

  A. SELECT colors1 .name.count (colors2.name) FROM colors1. Colors2 WHERE Colors1. Name = (SELECT DISTINCT name FROM colors2 WHERE colors1.name=colors2.name) GROUP BY colorse1.name,

  B. SELECT colors1.name, count(colorse2. Name) FROM colorse1 .name =colors2.name WHERE colors1. Name =colors2.name GROUP BY colors1.name,

  C. SELECT colors1. Name count (colors2.name) FROM colors1 INNER JOIN colors2 on colors1. Name =colors2. Name GROUP BY colors1 .name;

  D. SELECT colors1.name, count (colors2.name) FROM JOIN colors2 on colors1 .name =colors2.name GROUP BY colors1.name;

  E. SELECT colors1.name, count (colors2.name) FROM colors1 RIGHT JOIN colors1 on colors1 .name =colors2.name GROUP BY colors1.name;

  Correct Answer: D

• Question 7:

  Which three statement types can be prepared?

  A. LOAD DATA INFILE

  B. CREATE TABLE

  C. CREATE VIEW

  D. ALTER VIEW

  E. CALL

  Correct Answer: AB

• Question 8:

  The friends table has the columns and contents as shown: Mysql> SELECT * FROM friends;

  

  This statement was executed: SELECT AVG (age) FROM friends What value is returned?

  A. NULL

  B. 10

  C. 20

  D. 0

  Correct Answer: A

• Question 9:

  Consider a table my_table , with contents shown:

  

  You execute:

  SELECT a b, b a FROM my_table WHERE a < s ORDER BY b;

  What does this statement return?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 10:

  You want to query the VARCHAR column ` code' values that match:

  Start with "p"

  End with "_"

  Contain more than 3 characters

  Assume that sql_mode is blank.

  Which two queries select only those rows?

  A.

  SELECT code FROM operations WHERE code LIKE "pandand_";

  B.

  SELECT code FROM operations WHERE code LIKE " 'and'and_' "ESCAPE " ` '';

  C.

  SELECT code FROM operations WHERE code LIKE "pand_\_";

  D.

  SELECT code FROM operations WHERE code LIKE "p_\and\_";

  E.

  SELECT code FROM operations WHERE code LIKE "p_7_and;_"ESCAPE "/";

  Correct Answer: CE