READ Free Dumps For Oracle- 1z0-023
| Question ID 8900 | Which statement about a tablespace is true?
|
| Option A | A tablespace can be read-only.
|
| Option B | A tablespace must contain at least one segment.
|
| Option C | A tablespace can belong to more than one database.
|
| Option D | A read-only tablespace cannot be switched to read-write status.
|
| Option E | Any tablespace can be taken offline while the database is running.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. A tablespace can be read-only. Incorrect Answers: B: A tablespace must contain at least one extent, not segment. C: A tablespace cannot belong to more than one database. D: A read-only tablespace can be switched to read-write mode. E: SYSTEM tablespace cannot be taken offline while the database is running. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 337-339 Chapter 7: Managing the Physical Database Structure
| Question ID 8901 | What are possible ways to specify NLS parameters? (Choose two)
|
| Option A | During installation.
|
| Option B | As environment variables.
|
| Option C | As initialization parameters.
|
| Option D | During connection to the database.
|
| Option E | During the creation of the control file.
|
| Correct Answer | BC |
Explanation Explanation/Reference: Explanation: Answers B and C are correct. NLS parameters can be specified as initialization parameters on the server and as environmental variables on the client. Incorrect Answers: A: NLS parameters cannot be specified during installation. D: NLS parameters cannot be specified during connection to the database. They can be changed for session level immediately after connection. E: NLS parameters cannot be specified during the creation of the control file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 543-545 Chapter 11: Data Loads and National Language Support