Online Access Free 1Z0-082 Exam Questions

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

• A.user process failure
• B.a user error such as dropping the wrong table
• C.statement failure
• D.network interface card (NIC) failure
• E.media failure

Examine this command:

Which two statements are true?

• A.It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
• B.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• C.The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
• D.Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
• E.Tables with one or more extents in this data file may be queried during the execution of this command.

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.ROW STORE COMPRESS ADVANCED
• B.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• C.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• D.COLUMN STORE COMPRESS FOR QUERY LOW
• E.ROW STORE COMPRESS BASIC

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months.
Which where clause can be used?

• A.WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
• B.WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
• C.WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
• D.WHERE TO_XUMBER(start_date - SYSDATE) <= 25

Which three object types support deferred segment creation? (Choose three.)

• A.index organized tables
• B.partitioned tables
• C.external tables
• D.temporary tables
• E.clustered tables
• F.heap organized tables