A the user will not have a home directory b the user

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: 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 Incorrect Answers: A: There is no home directory for users in Oracle....
View Full Document

Ask a homework question - tutors are online