10.7. Review Questions

  1. Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?

    1. RSTLNE

    2. NLSRTL

    3. LISTENER

    4. NLSSORT

    5. Linguistic sorts

  2. What three elements of globalization can be explicitly defined using the NLS_LANG environment variable?

    1. NLS_LANGUAGE

    2. NLS_SORT

    3. NLS_CALENDAR

    4. NLS_CHARACTERSET

    5. NLS_TERRITORY

  3. Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

    1. A must contain all of the characters defined in B.

    2. A must be Unicode.

    3. The encoded values in A must match the encoded values in B for all characters defined in B.

    4. A must be a multi-byte character set.

    5. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

  4. The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

    1. WHERE clause

    2. ORDER BY clause

    3. BETWEEN clause

    4. NLSSORT function

    5. NLS_SORT function

  5. Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

    1. V$VALID_NLS_VALUES

    2. NLS_VALID_VALUES

    3. NLS_VALUE_OPTIONS

    4. V$NLS_VALUE_OPTIONS

    5. V$NLS_VALID_VALUES

  6. Which of the following datatypes store time zone information in the database?

    1. TIMESTAMP

    2. DATE

    3. TIMESTAMP WITH TIME ZONE

    4. TIMESTAMP WITH LOCAL TIME ZONE

    5. DATETIME

  7. Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)

    1. ASCII

    2. ANSI

    3. BINARY

    4. MONOLINGUAL

    5. MULTILINGUAL

  8. NLS parameters can be set using the five methods listed below. Put the methods in order from highest to lowest according to Oracle's order of precedence:

    1. Default setting

    2. Client environment variable

    3. Explicit ALTER SESSION statement

    4. Inside SQL function

    5. Server initialization parameter

    1. 2, 4, 5, 1, 3

    2. 5, 1, 2, 3, 4

    3. 4, 3, 2, 5, 1

    4. 1, 2, 4, 3, 5

    5. 4, 3, 2, 1, 5

  9. What can you determine about the following linguistic sorts based only on their names?

    1. GERMAN

    2. FRENCH_M

    Select all the true statements:

    1. 1 is a monolingual sort.

    2. 2 is a monolingual sort.

    3. 1 is case-insensitive.

    4. Both 1 and 2 are case-insensitive.

    5. Case-sensitivity is unknown.

  10. In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

    1. VARCHAR2

    2. CHAR

    3. NVARCHAR2

    4. CLOB

    5. LONG

  11. Automatic data conversion will occur if

    1. The client and server have different NLS_LANGUAGE settings.

    2. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

    3. The client and server are in different time zones.

    4. The client requests automatic data conversion.

    5. The AUTO_CONVERT initialization parameter is set to TRUE.

  12. Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?

    1. NLS_SORT = BINARY

    2. NLS_SORT = BINARY_AI

    3. NLS_SORT = BINARY_CI

    4. NLS_SORT = BINARY_AI_CI

    5. Binary sorts are case and accent-insensitive by default.

  13. Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?

    1. NLS_LANG

    2. NLS_SORT

    3. NLS_COMP

    4. NLS_SORT

    5. None of the above

  14. Which of the following would be affected by setting NLS_LEN6TH_SEMANTICS=CHAR?

    1. All objects in the database

    2. Tables owned by SYS and SYSTEM

    3. Data dictionary tables

    4. NCHAR columns

    5. CHAR columns

  15. Which is not a valid locale definition file type?

    1. Language

    2. Linguistic sort

    3. Calendar

    4. Territory

    5. Character set

  16. How many different calendars does Oracle 10g support?

    1. 22

    2. 7

    3. 6

    4. 15

    5. 2

  17. Which NLS parameter directly governs linguistic searches?

    1. NLS_SEARCH_L

    2. NLS_SORT

    3. NLS_SEARCH

    4. NLS_SORT_L

    5. None of the above

  18. Case-insensitive sorts are always accent-insensitive by default.

    1. True

    2. False

  19. What is the name of the file that identifies the set of available locale definitions?

    1. locale.def

    2. lxdef.ora

    3. lx1boot.nlb

    4. lx1boot.ora

    5. lang.def

  20. Which of the following is not a valid linguistic sort element?

    1. Accent expansion

    2. Canonical equivalence

    3. Reverse secondary sorting

    4. Ignorable characters

    5. Character rearrangement

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset