Oracle DBA Question $ Answers(Part 4)

1. Which tablespace is used as the temporary tablespace if TEMPORARY TABLESPACE is not specified for a user?

a. TEMP
b. DATA
c. SYSTEM
d. ROLLBACK

correct answer: c

2. User SCOTT creates an index with this statement: CREATE INDEX emp_indx on employee (empno). In which tablespace would be the index created?

a. SYSTEM tablespace
b. SCOTTS default tablespace
c. Tablespace with rollback segments
d. Same tablespace as the EMPLOYEE table.

correct answer: b

3. Which data dictionary view shows the available free space in a certain tablespace? (9-16)

A. DBA_EXTENTS
B. V$FREESPACE
C. DBA_FREE_SPACE
D. DBA_TABLESPACE
E. DBA_FREE_EXTENTS

correct answer: c

4. Which method increase the size of a tablespace?

A. Add a datafile to a tablespace.
B. Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
C. Use the ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
D. Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.

correct answer: a

5. What does the command ALTER DATABASE . . . RENAME DATAFILE do? (8-37) (Not proper description of the ans.)

A. It copies a data file.
B. It updates the control file.
C. It copies a data file and updates the control file.
D. It copies a data file, deletes the obsolete file, and updates the control file.

correct answer: b

6. Can you drop objects from a read-only tablespace?
A. No
B. Yes
C. Only when using the DBA role
D. Only when the tablespace is online

correct answer: b

7. SYSTEM TABLESPACE can be made off-line

a) Yes
b) No

correct answer: b


8. Datadictionary can span across multiple Tablespaces

a) TRUE
b) FALSE

correct answer: b

9. Multiple Tablespaces can share a single datafile

a) TRUE
b) FALSE

correct answer: b

10. All datafiles related to a Tablespace are removed when the Tablespace is dropped?

a) TRUE
b) FALSE

correct answer: b