Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (371-380)

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

Answer: E

QUESTION 372
Which is not a valid locale definition file type?

A.    Language
B.    Linguistic sort
C.    Calendar
D.    Territory
E.    Character set

Answer: C
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch13custlocale.htm#NLSPG558

QUESTION 373
How many different calendars does Oracle 11g support?

A.    22
B.    7
C.    6
D.    15
E.    2

Answer: B
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215

QUESTION 374
Which NLS parameter directly governs linguistic searches?

A.    NLS_SEARCH_L
B.    NLS_SORT
C.    NLS_SEARCH
D.    NLS_SORT_L
E.    None of the above

Answer: B

QUESTION 375
Case-insensitive sorts are always accent insensitive by default.

A.    True
B.    False

Answer: B

QUESTION 376
What is the name of the file that identifies the set of available locale definitions?

A.    locale.def
B.    lxdef.ora
C.    lx1boot.nlb
D.    lx1boot.ora
E.    lang.def

Answer: C

QUESTION 377
Which of the following is not a valid linguistic sort element?

A.    Accent expansion
B.    Canonical equivalence
C.    Reverse secondary sorting
D.    Ignorable characters
E.    Character rearrangement

Answer: A
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276

QUESTION 378
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

A.    Cursor cache
B.    Stored outline
C.    SQL Tuning Set
D.    Automatic Workload Repository (AWR) snapshots

Answer: AC

QUESTION 379
Which two statements about workload capture and replay operations are true? (Choose two.)

A.    The clients must be created manually on the test machines to perform more realistic testing.
B.    Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state
for workload replay.
C.    Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state
for capturing the workload.
D.    The application state of the capture system must be identical to the application state of the replay system
when the workload replay begins.

Answer: CD

QUESTION 380
View the Exhibit exhibit1 to examine the series of SQL commands.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

image

A.    The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
B.    The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
C.    The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
D.    The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to
FIRST_ROW during its creation.

Answer: B

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

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

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back