Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (361-370)

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

A.    WHERE clause
B.    ORDER BY clause
C.    BETWEEN clause
D.    NLSSORT function
E.    NLS_SORT function

Answer: AD

QUESTION 362
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

Answer: E

QUESTION 363
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

Answer: C

QUESTION 364
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

Answer: BC

QUESTION 365
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

Answer: C

QUESTION 366
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.

Answer: A

QUESTION 367
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

Answer: C
Explanation:
NVARCHAR2 Data Type
The NVARCHAR2 data type is a Unicode-only data type. When you create a table with an NVARCHAR2 column, you supply the maximum number of characters it can hold. Oracle subsequently stores each value in the column exactly as you specify it, provided the value does not exceed the maximum length of the column.
The maximum length of the column is determined by the national character set definition. Width specifications of character data type NVARCHAR2 refer to the number of characters. The maximum column size allowed is 4000 bytes

QUESTION 368
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.

Answer: B

QUESTION 369
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.

Answer: B

QUESTION 370
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

Answer: D

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html