| 1: | Where would you look for your database's national character set? A. V$NLS_PARAMETERS B. V$NLS_VALID_VALUES C. V$PARAMETERS D. V$VALID_VALUES
|
| A1: | Answer A is correct; V$NLS_PARAMETERS will give you your national character set. Answer B is incorrect; V$NLS_VALID_VALUES will give you all the valid values that you can have for your national character set but not the current value. Answer C is incorrect; V$PARAMETERS will not provide you with information on your NLS parameters. Answer D is incorrect because V$VALID_VALUES is not an Oracle 9i data dictionary view. |
| 2: | Where would you look for the list of all valid values for the database's NLS parameters? A. V$NLS_PARAMETERS B. V$NLS_VALID_VALUES C. V$PARAMETERS D. V$VALID_VALUES
|
| A2: | Answer B is correct; V$NLS_VALID_VALUES provides all the valid values for a given parameter. Answer A is incorrect; V$NLS_PARAMETERS gives you your NLS parameters and their current values. Answer C is incorrect; V$PRAMETERS does not provide information on your NLS parameters. Answer D is incorrect because V$VALID_VALUES is not an Oracle 9i data dictionary view. |
| 3: | What parameter would you alter to be able to override the default currency of the English pound by the euro at the same time? |
| A3: | Answer C is correct; you can use NLS_DUAL_CURRENCY to override the default currency for the given territory. Answer A is incorrect; NLS_ISO_CURRENCY is the ISO currency symbol for the territory. Answer B is incorrect; NLS_CURRENCY is the default local currency symbol for a particular territory. Answer D is incorrect; NLS_MONETARY_CHARACTERS specifies the group separator for monetary expressions for the territory. |
| 4: | Which sort method provides more sorting flexibility with respect to multiple languages? A. Binary sorting B. Multilingual sorting C. Monolingual sorting D. Linguistic sorting
|
| A4: | Answer B is correct; multilingual sorting is the most efficient for sorts involving multiple languages. Answer A is incorrect; binary, the default sort mechanism, is the least efficient for sorts including multiple languages. Answer C is incorrect; monolingual sorting sorts in two passes and is less efficient for multiple languages than the multilingual sort method. Answer D is incorrect; linguistic sorting isn't a sort method. |
| 5: | What two new Unicode character encoding sets did Oracle introduce in 9i? |
| A5: | Answer B is correct; AL16UTF16 and AL32UTF8 are Oracle 9i's new character set encoding schemes. Answer A is incorrect because these were encoding schemes in Oracle 8i. Answers C and D are incorrect because they are not valid encoding sets. |
| 6: | Which is not a reason to use Unicode character encoding schemes in your database? A. To make it easier to write application code B. To achieve better data distribution C. To see performance gains D. To be able to use multilingual sorts
|
| A6: | Answer D is correct; multilingual sorts are not directly connected to using a Unicode character set. Answers A, B, and C are incorrect because they are all reasons to use a Unicode character scheme. |
| 7: | Which is an advantage to using fixed-width character sets in your database? A. Performance gains B. Easier application coding C. Use of multilingual sorts D. To be able to store characters in exactly the number of bytes they take up
|
| A7: | Answer A is correct; there are performance gains to be seen with either single-byte character sets or fixed-width multibyte character sets because Oracle knows ahead of time exactly how many bytes each character will take up. Answer B is incorrect; there is no real difference in coding applications based on how many bytes a character takes up. Answer C is incorrect; there are no connections between sorts and the number of bytes that characters take up. Answer D is incorrect; it is a reason that you might consider variable-width character sets. |
| 8: | Which is an advantage of using variable-width character sets in your database? A. Performance gains B. Easier application coding C. Use of multilingual sorts D. To be able to store characters in exactly the number of bytes they take up
|
| A8: | Answer D is correct. If space is an issue, you might find benefit in storing data in variable-width character sets. Answer A is incorrect; variable-width character sets cause somewhat of a performance hit to the database because Oracle is unsure how many bytes each and every character will consume. Answer B is incorrect; there is no real difference in coding applications based on how many bytes a character takes up. Answer C is incorrect; there are no connections between sorts and the number of bytes that characters take up. |
| 9: | Which is a valid Oracle 9i pair of Unicode character encoding sets? |
| A9: | Answer B is correct; the only answer that provides a correct pair of Unicode character encoding sets is B. |
| 10: | In Windows, how can you temporarily override the default value set for the NLS_LANG environment variable? A. With the ALTER SYSTEM command B. With the ALTER SESSION command C. Manually edit the Registry D. At the command prompt
|
| A10: | Answer D is correct; you can override the value for NLS_LANG on Windows at the command prompt. Answers A and B are incorrect; you can't simply set the values in SQL*PLUS. Answer C is incorrect; you shouldn't edit the Registry to temporarily change a parameter value. |
