READ Free Dumps For Oracle- 1z0-023
| Question ID 8749 | Consider the following command to create the user 'peter'. CREATE USER peter IDENTIFIED by panTEMPORARY TABLESPACE temp PASSWORD EXPIRE; Since no default tablespace was specified, what will happen if this command executed?
|
| Option A | The user will not have a home directory.
|
| Option B | The user peter will be created using the TEMP tablespace as the default.
|
| Option C | The user peter will be created using the SYSTEM tablespace as the default.
|
| Option D | the code will produce an error message; the user peter will not be created.
|
| Correct Answer | C |
Explanation Explanation/Reference: 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. Incorrect Answers: A: There is no home directory for users in Oracle. B: The user peter will be created with SYSTEM tablespace as the default and TEMP tablespace as the temporary tablespace. D: The code above is correct, user peter will be successfully created. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 466 Chapter 10: Managing Database Use
| Question ID 8750 | An oracle user receives the following error: ORA-01555 SNAPSHOP TOO OLD What are two possible solutions? (Choose two)
|
| Option A | Increase the extent size of the rollback segments.
|
| Option B | Perform media recovery.
|
| Option C | Increase the number of rollback segments.
|
| Option D | Increase the size of the rollback segment tablespace.
|
| Option E | Increase he value of OPTIMAL storage parameter.
|
| Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A and E are correct. Recall that rollback segments allow transaction-level read consistency for all statements running on the database. A long-running query in one session that starts before a change on that data is committed by another session will see the data as it existed pre-commit. I Oracle can not provide a read-consistent view of data, the following error will ensure "ORA-01555 - snapshot too old (rollback segment too small)" error. The solution to this problem is to recreate the rollback segment with a higher minimum number of extents, larger extents, or a higher OPTIMAL rollback segment size. You cannot simply increase MAXEXTENTS to resolve this problem. Incorrect Answers: B: Media recovery does not need to be performed because there is no media failure when this error happened. C: Problem with this error can be fixed with a higher minimum number of extents for the rollback segment, not with a higher number of rollback segments. D: Problem with this error can be fixed with larger extents for the rollback segment, not with larger size of rollback segments tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 381 Chapter 8: Managing Database Objects