1z0-053.actuatest.9-16-2012
.pdfQUESTION 352
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?
A.PLSQL_BLOCK
B.JAVA_STORED_PROCEDURE
C.STORED_PROCEDURE
D.EXECUTABLE
E.None of the above are invalid settings.
Answer: B
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 353
Which of the following Scheduler elements encourage object reuse? (Choose all that apply.) Oracle 1z0-053 Exam
A.Schedule objects
B.Program arguments
C.Job classes
D.Job arguments
E.All of the above
Answer: ABD
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 354
What is the danger associated with stopping a running job by using the STOP_JOB procedure?
A.The job will need to be reenabled before it will execute again.
B.The job may hold locks on objects referenced within it.
C.All jobs within the job group will also be stopped.
D.The job may leave data in an inconsistent state.
E.There is no danger in using the STOP_JOB procedure.
Answer: D
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 355
For More Info Visit www.logicsmeet.com
If a job references a schedule that has been disabled, what will be the result?
A.The job will be automatically disabled.
B.The job will never execute.
C.The job will attempt to execute but will fail.
D.The job will inherit the DEFAULT_SCHEDULE schedule.
E.A schedule object cannot be disabled.
Answer: E
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 356
When a job exceeds the date specified in its END_DATE attribute, which of the following will Oracle 1z0-053 Exam
happen? (Choose all that apply.)
A.The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
B.The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
C.The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.
D.All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.
E.The STATE column of the job table will be set to COMPLETED for the job.
Answer: ABE
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 357
Which of the following is true about job chains?
A.They consist of one or more Scheduler programs.
B.They are used to implement dependency scheduling.
C.They are used to implement time-based scheduling.
D.They are used to implement event-based scheduling.
E.None of the above.
Answer: B
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 358
If two windows overlap, which window attribute will determine whether one should be chosen over the other?
For More Info Visit www.logicsmeet.com
A.WINDOW_PRIORITY
B.PRIORITY
C.PRIORITY_LEVEL
D.WINDOW_PRIORITY_LEVEL
E.OVERLAP_RULE
Answer: A
Section: (none)
Explanation/Reference:
Explanation:
Oracle 1z0-053 Exam
QUESTION 359
Globalization support is implemented through the textand character-processing functions provided by which Oracle feature?
A.RSTLNE
B.NLSRTL
C.LISTENER
D.NLSSORT
E.Linguistic sorts
Answer: B
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 360
What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)
A.NLS_LANGUAGE
B.NLS_SORT
C.NLS_CALENDAR
D.NLS_CHARACTERSET
E.NLS_TERRITORY
Answer: ADE
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 361
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)
For More Info Visit www.logicsmeet.com
A.A must contain all of the characters defined in B.
B.A must be Unicode.
C.The encoded values in A must match the encoded values in B for all characters defined in B.
D.A must be a multibyte character set. Oracle 1z0-053 Exam
E.The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.
Answer: AC
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 362
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 363
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 364
Which of the following datatypes store time-zone information in the database? Oracle 1z0-053 Exam
A. TIMESTAMP
For More Info Visit www.logicsmeet.com
B.DATE
C.TIMESTAMP WITH TIME ZONE
D.TIMESTAMP WITH LOCAL TIME ZONE
E.DATETIME
Answer: C
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 365
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 366
NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle's order of precedence:
A.Default setting
B.Client environment variable
C.Explicit ALTER SESSION statement
D.Inside SQL function
E.Server initialization parameter
F.b, d, e, a, c
G.e, a, b, c, d
H.d, c, b, e, a
I.a, b, d, c, e
Oracle 1z0-053 Exam
J.d, c, b, a, e
Answer: C
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 367
For More Info Visit www.logicsmeet.com
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 368
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 369
Automatic data conversion will occur if which of the following happens? Oracle 1z0-053 Exam
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
Section: (none)
Explanation/Reference:
Explanation:
For More Info Visit www.logicsmeet.com
QUESTION 370
Which of the following NLS_SORT parameter values would result in case-insensitive and accentinsensitive 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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 371
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 372
Oracle 1z0-053 Exam
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 373
Which is not a valid locale definition file type?
For More Info Visit www.logicsmeet.com
A.Language
B.Linguistic sort
C.Calendar
D.Territory
E.Character set
Answer: C
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 374
How many different calendars does Oracle 11g support?
A.22
B.7
C.6
D.15
E.2
Answer: B
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 375
Oracle 1z0-053 Exam
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 376
Case-insensitive sorts are always accent insensitive by default.
A.True
B.False
For More Info Visit www.logicsmeet.com
Answer: B
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 377
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
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 378
Which of the following is not a valid linguistic sort element? Oracle 1z0-053 Exam
A.Accent expansion
B.Canonical equivalence
C.Reverse secondary sorting
D.Ignorable characters
E.Character rearrangement
Answer: A
Section: (none)
Explanation/Reference:
Explanation:
QUESTION 379
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
Section: (none)
Explanation/Reference:
Explanation:
For More Info Visit www.logicsmeet.com
QUESTION 380
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
Section: (none)
Explanation/Reference:
Explanation:
Oracle 1z0-053 Exam
QUESTION 381
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?
For More Info Visit www.logicsmeet.com