READ Free Dumps For Oracle- 1z0-023
| Question ID 8777 | How can you declare the national character set and the database character set?
|
| Option A | By creating the database
|
| Option B | By installing the Oracle software
|
| Option C | By setting the initialization parameter CHARACTER_SET
|
| Option D | By setting the environment variable DB_CHARACTER_SET
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. You can set the national character set and the database character set only by creating the database, you cannot change them later. Only one way to change national character set and the database character set: to recreate database. Incorrect Answers: B: You cannot declare these parameters just by installing the Oracle software. C: CHARACTERSET parameter exists in CREATE DATABASE command, there is no CHARACTER_SET parameter in initSID.ora file. D: CHARACTERSET parameter exists in CREATE DATABASE command, you cannot set the national character set and the database character set by using DB_CHARACTER_SET environment variable. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 543-545 Chapter 11: Data Loads and National Language Support
| Question ID 8778 | Which statement about an Oracle instance is true?
|
| Option A | An Oracle instance can access multiple databases at one time only.
|
| Option B | An Oracle instance has a minimum of three background processes.
|
| Option C | An Oracle instance consists of the shared pool and the redo log files.
|
| Option D | The memory allocated by an Oracle instance is shareable by the database processes.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. Database processes can share the memory allocated by an Oracle instance. Incorrect Answers: A: An Oracle database instance can access one database, not multiple databases, at one time only. B: An Oracle instance has a minimum of 5 background processes: SMON, PMON, DBWR, LGWR, CKRT. C: An Oracle instance consists of the shared pool memory structure, but not the redo log files. They are not memory structures. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 256-259 Chapter 6: basics of the Oracle Database Architecture