READ Free Dumps For Oracle- 1z0-023
| Question ID 8815 | You are responsible for managing disk space used for large sort operations. You are willing to allocate this space as needed and not de-allocate until the database is shutdown. You would like to reduce contention on data dictionary tables when this space is allocated. Where possible, you would like to avoid the overhead of generating rollback information when this space is allocated. What kind of tablespace is appropriate?
|
| Option A | A locally-managed temporary tablespace.
|
| Option B | A locally-managed permanent tablespace.
|
| Option C | A dictionary-managed temporary tablespace.
|
| Option D | A dictionary-managed permanent tablespace.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. You need to use temporary tablespace for large sort operations. If you also want to reduce contention on data dictionary tables, you need to use locally managed tablespace. Incorrect Answers: B: For sort you need temporary tablespace, not permanent. C: To reduce contention on data dictionary tables, you need to use locally managed tablespace, not dictionarymanaged tablespace. D: To reduce contention on data dictionary tables and for large sort operations, you need to use locally managed tablespace temporary tablespace, not dictionary-managed permanent tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics
| Question ID 8816 | Which two statements about tempfiles are true? (Choose two)
|
| Option A | Media recovery does not recover tempfiles.
|
| Option B | Tempfiles can contain permanent segments.
|
| Option C | Tempfiles are always set to LOGGING mode.
|
| Option D | Tempfiles are used for all types of temporary tablespaces.
|
| Option E | You cannot create a tempfile with an ALTER DATABASE command.
|
| Option F | BACKUP CONTROLFILE generates commands to recreate lost tempfiles.
|
| Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A, E are correct. Tempfiles are used temporary, so no information is stored in redo logs about them. Media recovery will not recover tempfiles. A tempfile can not be created explicitly with ALTER DATABASE command. Incorrect Answers: B: Tempfiles cannot contain permanent segments. C: Tempfiles does not produce any entries for redo logs, they are always in NOLOGGING mode. D: Tempfiles are used not for all types of temporary tablespaces. F: BACKUP CONTROLFILE does not generate any command to recreate lost tempfile. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics