What three elements of globalization can be explicitly defined using the NLS_LANG environment variable?
NLS_LANGUAGE
NLS_SORT
NLS_CALENDAR
NLS_CHARACTERSET
NLS_TERRITORY
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.)
A must be Unicode.
The encoded values in A must match the encoded values in B for all characters defined in B.
A must be a multi-byte character set.
The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)
WHERE clause
ORDER BY clause
BETWEEN clause
NLSSORT function
NLS_SORT function
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?
V$VALID_NLS_VALUES
NLS_VALID_VALUES
NLS_VALUE_OPTIONS
V$NLS_VALUE_OPTIONS
V$NLS_VALID_VALUES
Which of the following datatypes store time zone information in the database?
TIMESTAMP
DATE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
DATETIME
Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)
ASCII
ANSI
BINARY
MONOLINGUAL
MULTILINGUAL
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:
Default setting
Client environment variable
Explicit ALTER SESSION statement
Inside SQL function
Server initialization parameter
2, 4, 5, 1, 3
5, 1, 2, 3, 4
4, 3, 2, 5, 1
1, 2, 4, 3, 5
4, 3, 2, 1, 5
What can you determine about the following linguistic sorts based only on their names?
GERMAN
FRENCH_M
Select all the true statements:
1 is a monolingual sort.
2 is a monolingual sort.
1 is case-insensitive.
Both 1 and 2 are case-insensitive.
Case-sensitivity is unknown.
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?
VARCHAR2
CHAR
NVARCHAR2
CLOB
LONG
Automatic data conversion will occur if
The client and server have different NLS_LANGUAGE settings.
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.
The client and server are in different time zones.
The client requests automatic data conversion.
The AUTO_CONVERT initialization parameter is set to TRUE.
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
NLS_SORT = BINARY
NLS_SORT = BINARY_AI
NLS_SORT = BINARY_CI
NLS_SORT = BINARY_AI_CI
Binary sorts are case and accent-insensitive by default.
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?
NLS_LANG
NLS_SORT
NLS_COMP
NLS_SORT
None of the above
Which of the following would be affected by setting NLS_LEN6TH_SEMANTICS=CHAR?
All objects in the database
Tables owned by SYS and SYSTEM
Data dictionary tables
NCHAR columns
CHAR columns
Which is not a valid locale definition file type?
Language
Linguistic sort
Calendar
Territory
Character set
How many different calendars does Oracle 10g support?
22
7
6
15
2
Which NLS parameter directly governs linguistic searches?
NLS_SEARCH_L
NLS_SORT
NLS_SEARCH
NLS_SORT_L
None of the above
Case-insensitive sorts are always accent-insensitive by default.
True
False
What is the name of the file that identifies the set of available locale definitions?
locale.def
lxdef.ora
lx1boot.nlb
lx1boot.ora
lang.def
Which of the following is not a valid linguistic sort element?
Accent expansion
Canonical equivalence
Reverse secondary sorting
Ignorable characters
Character rearrangement