Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR? A. All objects in the database B. Tables owned by SYS and SYSTEM C. Data dictionary tables D. NCHAR columns E. CHAR columns Show Answer
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for theSQL SELECT statement? A. NLS_LANG B. NLS_COMP C. NLS_SORT D. None of the above Explanation:Neither NLS_SORT nor NLS_COMP cannot change sorting from BINARY to LINGUISTIC. Because theNLS_SORT depends on NLS_COMP, if they are different, the sorting method […]
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitivebinary sorts? A. NLS_SORT = BINARY B. NLS_SORT = BINARY_AI C. NLS_SORT = BINARY_CI D. NLS_SORT = BINARY_AI_CI E. Binary sorts are case insensitive and accent insensitive by default. Show Answer
Automatic data conversion will occur if which of the following happens? A. The client and server have different NLS_LANGUAGE settings. B. 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. C. The client and server are in different time […]
In a database with the database character set of US7ASCII and a national character set of UTF-8, whichdatatypes would be capable of storing Unicode data by default? A. VARCHAR2 B. CHAR C. NVARCHAR2 D. CLOB E. LONG Show Answer
What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_M A. 1 is a monolingual sort. B. 2 is a monolingual sort. C. 1 is case insensitive. D. Both 1 and 2 are case insensitive. E. Case sensitivity is unknown. Show Answer
NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowestaccording to Oracles order of precedence:a: Default settingb: Client environment variablec: Explicit ALTER SESSION statementd: Inside SQL functione: Server initialization parameter A. b, d, e, a, c B. e, a, b, c, d C. d, c, b, […]
Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.) A. ASCII B. ANSI C. BINARY D. MONOLINGUAL E. MULTILINGUAL Explanation: NLS_COMP specifies the collation behavior of the database session.Values:BINARYNormally, comparisons in the WHERE clause and in PL/SQL blocks is binary unless you specify the NLSSORTfunction.LINGUISTICComparisons for all SQL operations […]
Which of the following datatypes store time-zone information in the database? A. TIMESTAMP B. DATE C. TIMESTAMP WITH TIME ZONE D. TIMESTAMP WITH LOCAL TIME ZONE E. DATETIME Show Answer
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, andNLS_CHARACTERSET parameters? A. V$VALID_NLS_VALUES B. NLS_VALID_VALUES C. NLS_VALUE_OPTIONS D. V$NLS_VALUE_OPTIONS E. V$NLS_VALID_VALUES Show Answer