Free Oracle 1Z1-082 Exam Dumps Questions & Answers

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

• A.  TIMESTAMP WITH TIMEZONE
• B.  TIMESTAMP WITH LOCAL TIMEZONE
• C.  INTERVAL YEAR TO MONTH
• D.  INTERVAL DAY TO SECOND
• E.  TIMESTAMP

The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

• A.  WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
• B.  WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• C.  WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
• D.  WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018',
  'Mon DD YYYY'))
• E.  WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

Which three are true about the Oracle Optimizer? (Choose three.)

• A.  It can optimize only SELECT statements.
• B.  It updates stale object statistics in the Data Dictionary.
• C.  It will only generate SQL Plan Directives specific to a given SQL statement.
• D.  It can re-optimize execution plans after previous executions detect suboptimal plans.
• E.  It determines the optimal table join order and method.
• F.  It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

Which three failures do not require intervention for recovery? (Choose three.)

• A.  media failure
• B.  statement failure
• C.  network interface card (NIC) failure
• D.  transaction failure
• E.  user process failure

Which statement is true about aggregate functions?

• A.  The AVG function implicitly converts NULLS to zero
• B.  Aggregate functions can be nested to any number of levels
• C.  The MAX and MIN functions can be used on columns with character data types
• D.  Aggregate functions can be used in any clause of a SELECT statement