Oracle Updated 1z0-082 Exam Questions and Answers by natalie

SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

the first column in the first select of the compound query

the first varchab2 column in the first select of the compound query

the first number column in the first select of the compound query

the first number or varchar2 column in the last select of the compound query

the first column in the last select of the compound query

Data block headers contain their own Data Block Address (DBA)

A table row piece can be chained across several database blocks

Multiple row pieces from the same row may be stored in different database blocks

Multiple row pieces from the same row may be stored in the same block

Data block free space is always contiguous in the middle of the block

Index block free space is always contiguous in the middle of the block

DBA_DATA_FILES displays the original name for the data files.

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

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

DBA_DATA_FILES displays the new name for the data files.

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