This preview shows page 1. Sign up to view the full content.
Unformatted text preview: A. The user will not have a home directory.
B. The user peter will be created using the TEMP tablespace as the default.
C. The user peter will be created using the SYSTEM tablespace as the default.
D.the code will produce an error message; the user peter will not be created.
Answer C is correct. Tablespace management is a crucial task in Oracle. The DEFAULT
TABLESPACE names the location where the user's database objects are created by default. This
clause plays an important role in protecting the integrity of the SYSTEM tablespace. If no
DEFAULT TABLESPACE is named for a user, objects that the user creates may be placed in
the SYSTEM tablespace. Recall that SYSTEM contains many database objects, such as the data
dictionary and the SYSTEM rollback segment, that are critical to database use. Users should not
be allowed to create their database objects in the SYSTEM tablespace.
Actualtests.com - The Power of Knowing 1Z0-023
A: There is no home directory for users in Oracle....
View Full Document
- Fall '09