Online Access Free 1Z1-082 Exam Questions

Examine the description of the product_details table:

Which two statements are true?

• A.PRODUCT _price contains the value zero by default if no value is assigned to it.
• B.PRODUCT_NAKE cannot contain duplicate values.
• C.EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
• D.PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
• E.EXPIRY_ DATE cannot be used in arithmetic expressions.
• F.PRODUCT _ic can be assigned the PRIMARY KEY constraint.

What two are benefits of Data Pump? (Choose two.)

• A.It can restart failed export jobs.
• B.It represents database metadata information as DDL statements in the dump file.
• C.It can execute in parallel.
• D.It can export data into sequential media, such as tapes.
• E.It makes use of client system resources.

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 DATE('JUL 10 2018', *MON DD YYYY')
• C.WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
• D.WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• E.WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018',
  'Mon DD YYYY'))

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

• A.qty_sold = `0554982' uses implicit conversion
• B.qty_sold BETWEEN `101' AND '110' : uses implicit conversion
• C.invoie_date > '01-02-2019' : uses implicit conversion
• D.invoice_date = '15-march-2019' : uses implicit conversion
• E.CONCAT (qty_sold, invoice_date) : requires explicit conversion

Which three statements are true about using SQL*Plus?

• A.It can run scripts entered at the SQL prompt.
• B.It has its own commands that are separate from any SQL statements.
• C.It can run Recovery Manager (RMAN) commands.
• D.It has both command-line and graphical user interfaces (GUI).
• E.It can run scripts passed to it by a shell script.
• F.It must be downloaded from the Oracle Technology Network (OTN).