New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Oracle Exam 1Z0-053 Topic 1 Question 2 Discussion
Actual exam question for
Oracle's
1Z0-053 exam
Question #: 2
Topic #: 1
[All 1Z0-053 Questions]
Topic #: 1
Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)
Suggested Answer:
B, C
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
Currently there are no comments in this discussion, be the first to comment!