READ Free Dumps For Oracle- 1z0-023
| Question ID 8803 | What does the command 'ALTER DATABASE . . . RENAME DATAFILE' do?
|
| Option A | It copies a data file.
|
| Option B | It updates the control file.
|
| Option C | It copies a data file and updates the control file.
|
| Option D | It copies a data file, deletes the obsolete file, and updates the control file.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Command 'ALTER DATABASE ...RENAME DATAFILE' just updates the control files; the command dose not actually rename datafiles on your operation system. Incorrect Answers: A: This command does not copy file physically. C: It updates the control file only, without copying a data file actually. D: This command does not copy a data file and not delete the obsolete file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 342-343 Chapter 7: Managing the Physical Database Structure
| Question ID 8804 | What distinguishes temporary tablespace from non-temporary tablespace?
|
| Option A | Temporary tablespace cannot be used for sorts.
|
| Option B | Temporary tablespace can hold data dictionary information.
|
| Option C | Temporary tablespace cannot hold permanent schema objects.
|
| Option D | Temporary tablespace can be used when the buffer cache is full.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Temporary tablespace cannot hold permanent objects by definition. Incorrect Answers: A: Temporary tablespace is used exactly for sorts, which cannot be done in memory. B: Temporary tablespace cannot hold any permanent objects. Data dictionary information usually is stored in SYSTEM tablespace. D: Temporary tablespace have nothing to do with buffer cache, it is used for sorts. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 344-345 Chapter 7: Managing the Physical Database Structure