Want to pass your Oracle Database Administration I 1Z0-082 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
E. A block will always be eligible for inserts if the row is short enough to fit into the block
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type
DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day
on the week.
Which query can be used?
A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;
B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;
C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
A. Data block headers contain their own Data Block Address (DBA)
B. A table row piece can be chained across several database blocks
C. Multiple row pieces from the same row may be stored in different database blocks
D. Multiple row pieces from the same row may be stored in the same block
E. Data block free space is always contiguous in the middle of the block
F. Index block free space is always contiguous in the middle of the block