Free Oracle 1z1-882 Exam Dumps Questions & Answers

Your application is running slow.
Which two features provide information that help to identify problems?

• A.The slow query log
• B.The performance schema
• C.The MYSQL error log
• D.The GET DIAGNOSTICS statement

You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?

• A.SELECT * FROM tableA JOIN tableB
• B.SELECT & FROM tableA STRAIGHT JOIN tableB
• C.SELECT * FROM table tableB
• D.SELECT * FROM tableA NATURAL JOIN tableB
• E.SELECT * FROM table A INNER JOIN tableB

Which statement correctly demonstrates using a subquery as a scalar expression?

• A.SELECT (
  SELECT SUM (population)
  FROM Country
  SELECT SUM (population)
  FROM Country
  WHERE Code ='CAN'
  )
• B.SELECT
  (SELECT SUM (population)
  FROM Country
  WHERE Code ='USA'
  FROM country
  WHERE Code= 'CAN'
  )
• C.(SELECT SUM (population)
  FROM Country
  WHERE Code ="USA'
• D.SELECT SUM (population)
  FROM Country
  WHERE Code ="USA"
  + (SELECT SUM (population)
  FROM Country
  WHERE Code =.'CAN'
  )

Which statement is true about the difference between HASH and BTREE INDEXES?

• A.HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.
• B.HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.
• C.HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can also be used for range
  searches (>or<).
• D.HASH indexes are much faster than BTREE indexes but can only be used for a single column.

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 "p%%_";
• B.SELECT code FROM operations WHERE code LIKE "p_\%\_";
• C.SELECT code FROM operations WHERE code LIKE "p_%_%;_"ESCAPE "/";
• D.SELECT code FROM operations WHERE code LIKE "p%_\_";
• E.SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';