Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 621:

  Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary 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.

  Correct Answer: B

• Question 622:

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

  A. NLS_LANG

  B. NLS_COMP

  C. NLS_SORT

  D. None of the above

  Correct Answer: D

  Neither NLS_SORT nor NLS_COMP cannot change sorting from BINARY to LINGUISTIC. Because the NLS_SORT depends on NLS_COMP, if they are different, the sorting method will always be BINARY. (Refer to NLS_SORT) The exact operators and query clauses that obey the NLS_SORT parameter depend on the value of the NLS_COMP parameter. If an operator or clause does not obey the NLS_SORT value, as determined by NLS_COMP, the collation used is BINARY. The BINARY comparison is faster and uses less resources than any linguistic comparison but for text in a natural language, it does not provide ordering expected by users. The value of NLS_SORT affects execution plans of queries. Because a standard index cannot be used as a source of values sorted in a linguistic order, an explicit sort operation must usually be performed instead of an index range scan. A functional index on the NLSSORT function may be defined to provide values sorted in a linguistic order and reintroduce the index range scan to the execution plan.

  NLS_COMP specifies the collation behavior of the database session.

• Question 623:

  NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:

  a: Default setting

  b: Client environment variable

  c: Explicit ALTER SESSION statement

  d: Inside SQL function

  e:

  Server initialization parameter

  A.

  b, d, e, a, c

  B.

  e, a, b, c, d

  C.

  d, c, b, e, a

  D.

  a, b, d, c, e

  E.

  d, c, b, a, e

  Correct Answer: C

  

• Question 624:

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

  1.

  GERMAN

  2.

  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.

  Correct Answer: A

• Question 625:

  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?

  A. VARCHAR2

  B. CHAR

  C. NVARCHAR2

  D. CLOB

  E. LONG

  Correct Answer: C

• Question 626:

  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 zones.

  D. The client requests automatic data conversion.

  E. The AUTO_CONVERT initialization parameter is set to TRUE.

  Correct Answer: B

• Question 627:

  Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_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

  Correct Answer: E

• Question 628:

  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

  Correct Answer: C

• Question 629:

  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

  Correct Answer: BC

  

  NLS_COMP specifies the collation behavior of the database session.

  Values:

  BINARY

  Normally, comparisons in the WHERE clause and in PL/SQL blocks is binary unless you specify the NLSSORT function.

  LINGUISTIC

  Comparisons for all SQL operations in the WHERE clause and in PL/SQL blocks should use the linguistic sort specified in the NLS_SORT parameter. To improve the performance, you can also define a linguistic index on the column for which

  you want linguistic comparisons.

  ANSI

  A setting of ANSI is for backwards compatibility; in general, you should set NLS_COMP to LINGUISTIC

• Question 630:

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

  A. RSTLNE

  B. NLSRTL

  C. LISTENER

  D. NLSSORT

  E. Linguistic sorts

  Correct Answer: B

  NLSRTL: NLS Runtime Type Library.