Free Oracle 1Z1-082 Exam Dumps Questions & Answers

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.  COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• B.  COLUMN STORE COMPRESS FOR ARCHIVE LOW
• C.  COLUMN STORE COMPRESS FOR QUERY LOW
• D.  ROW STORE COMPRESS ADVANCED
• E.  ROW STORE COMPRESS BASIC

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

• A.  SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK
• B.  SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
• C.  SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• D.  SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• E.  SELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• F.  SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

Examine the description of the employees table:

Which query requires explicit data type conversion?

• A.  SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
• B.  SELECT join_date FROM employees WHERE join_date > '10-02-2018';
• C.  SELECT join_date I I ' ' II salary FROM employees;
• D.  SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

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

Which two are true about complete and incomplete recovery? (Choose two.)

• A.  Incomplete recovery is possible only when the database is open.
• B.  Uncommitted transactions will be rolled back after incomplete recovery completes.
• C.  Uncommitted transactions will be rolled back after complete recovery completes.
• D.  Only incremental backups can be used to roll forward the database while performing complete recovery.
• E.  The database must have FLASHBACK enabled in order to perform incomplete recovery.