READ Free Dumps For Oracle- 1z0-023
| Question ID 8775 | Which two conventions are defined by the initialization parameter NLS_LANGUAGE? (Choose two)
|
| Option A | Default data format.
|
| Option B | Local currency symbol.
|
| Option C | ISO week number calculation.
|
| Option D | Default sorting sequence of character data.
|
| Option E | Language used for day and month names and their abbreviations.
|
| Correct Answer | DE |
Explanation Explanation/Reference: Explanation: Answers D, E are correct. NLS_LANGUAGE parameter indicates the language for error messages, the names of days and months, the symbols for 12-hours time of day and calendar era; this parameter also defines the sort mechanism Oracle will use. Incorrect Answers: A: NLS_DATE_FORMAT parameter identifies a new date format. B: NLS_CURRENCY parameter identifies a new currency symbol. C: NLS_LANGUAGE does not identifies ISO week number calculation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 545 Chapter 11: Data Loads and National Language Support
| Question ID 8776 | Which data dictionary view displays the database character set?
|
| Option A | V$DATABASE
|
| Option B | DBA_CHARACTER_SET
|
| Option C | NLS_DATABASE_PARAMETERS
|
| Option D | NLS_DATABASE_CHARACTERSET
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. NLS_DATABASE_PARAMETERS data dictionary view displays the database character set of Oracle database. Incorrect Answers: A: V$DATABASE view displays information about database, but not about the database character set. B: DBA_CHARACTER_SET view does not exist. D: NLS_DATABASE_CHARACTERSET view does not exist. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 547 Chapter 11: Data Loads and National Language Support