Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 51:

  Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

  A. An undo segment may be used by multiple transactions simultaneously

  B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

  C. Undo segments have a minimum of three extents

  D. Undo segments can extend when a transaction fills the last extent of the undo segment

  E. A single transaction may use multiple undo segments simultaneously

  F. Undo segments must be stored in a BIGFILE tablespace

  G. Undo segments must be stored in a SMALLFILE tablespace

  Correct Answer: ABD

• Question 52:

  Which two statements are true about INTERVAL data types? (Choose two.)

  A. INTERVAL DAY TO SECOND columns support fractions of seconds.

  B. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

  C. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

  D. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

  E. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

  F. INTERVAL YEAR TO MONTH support yearly intervals.

  Correct Answer: AF

• Question 53:

  Which two queries execute successfully? (Choose two.)

  A. SELECT NULLIF(NULL, 100) FROM DUAL;

  B. SELECT NULLIF(100, 'A') FROM DUAL;

  C. SELECT COALESCE(100, 'A') FROM DUAL;

  D. SELECT COALESCE(100, NULL, 200) FROM DUAL;

  E. SELECT NULLIF(100, 100) FROM DUAL;

  Correct Answer: DE

• Question 54:

  You need to calculate the number of days from 1st January 2019 until today.

  Dates are stored in the default format of DD-MON-RR.

  Which two queries give the required output? (Choose two.)

  A. SELECT TO_CHAR(SYSDATE,`DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;

  B. SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;

  C. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

  D. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;

  E. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;

  Correct Answer: CE

• Question 55:

  While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.

  Which two statements are true?

  A. DBA_DATA_FILES displays the original name for the data files.

  B. V$DATAFILE displays the new names for the data files.

  C. DBA_DATA _FILES displays both the new name and the old name for the data files.

  D. DBA_DATA_FILES displays the new name for the data files.

  E. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

  Correct Answer: AC

• Question 56:

  Which three statements are true about Deferred Segment Creation in Oracle databases?

  A. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

  B. Sessions may dynamically switch back and forth from deferred to immediate segment creation.

  C. It Is the default behavior for tables and indexes.

  D. It is supported for SYS-owned tables contained in locally managed tablespaces.

  E. Indexes inherit the deferred or immediate segment creation attribute from their parent table

  Correct Answer: BCE

• Question 57:

  Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

  A. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

  B. UNDO_RETENTION specifies how long all types of UNDO are retained.

  C. Unexpired UNDO is always retained.

  D. Active UNDO is always retained.

  E. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

  Correct Answer: CD

  By definition, undo extents that still have to overlive the retention period are unexpired. So, when undo_retention is set and retention is guaranteed, unexpired undo is always retained.

  As opposed to the case in which retention is noguarantee, where also unexpired extents can be overwritten IF and when needed.

  In this particolar case, so, I would say C-D are the correct answers.

• Question 58:

  Examine this command:

  SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

  Which two statements are true?

  A. The high-water mark (HWM) of ORDERS is adjusted.

  B. Only queries are allowed on ORDERS while the shrink is executing.

  C. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

  D. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

  E. Dependent indexes become UNUSABLE.

  F. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

  Correct Answer: CD

• Question 59:

  Which statement is true about the INTERSECT operator used in compound queries?

  A. Multiple INTERSECT operators are not possible in the same SQL statement

  B. It processes NULLs in the selected columns

  C. INTERSECT is of lower precedence than UNION or UNION ALL

  D. It ignores NULLs

  Correct Answer: B

  SET operators all have the same priority in Oracle Database. NULL values are processed with set operators

• Question 60:

  Which statement is true about aggregate functions?

  A. Aggregate functions can be nested to any number of levels

  B. The AVG function implicitly converts NULLS to zero

  C. Aggregate functions can be used in any clause of a SELECT statement

  D. The MAX and MIN functions can be used on columns with character data types

  Correct Answer: D