Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 611:

  View the Exhibits exhibit1 and exhibit2.

  Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than

  the process in exhibit2.

  What is the reason for this?

  lightweight-job-1 (exhibit):

  

  lightweight-job-2 (exhibit):

  

  A. It updates several tables in the SYSTEM tablespace instead of creating new tables.

  B. It creates jobs temporarily in memory only.

  C. It creates less metadata for the jobs.

  D. It writes the job metadata to disk in compressed format.

  Correct Answer: C

  The difference between two blocks of code is the "JOB_STYLE". The lightweight job creates less metadata for the jobs.

• Question 612:

  The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)

  A. Date format

  B. Decimal character

  C. Group separator

  D. First day of the month

  E. None of the above

  F. All of the above

  Correct Answer: ABC

  Parameter type String

  Syntax NLS_TERRITORY = territory

  Default value Operating system-dependent

  Modifiable ALTER SESSION

  Range of values Any valid territory name

  Basic Yes

  NLS_TERRITORY specifies the name of the territory whose conventions are to be followed for day and week numbering.

  This parameter also establishes the default date format, the default decimal character and group separator, and the default ISO and local currency symbols.

  For information on these settings, see "NLS_DATE_FORMAT", "NLS_NUMERIC_CHARACTERS", "NLS_CURRENCY", and "NLS_ISO_CURRENCY".

• Question 613:

  Which two statements are true with respect to the maintenance window? (Choose two.)

  A. A DBA can enable or disable an individual task in all maintenance windows.

  B. A DBA cannot change the duration of the maintenance window after it is created.

  C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.

  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

  Correct Answer: AD

• Question 614:

  Which is not a valid locale definition file type?

  A. Language

  B. Linguistic sort

  C. Calendar

  D. Territory

  E. Character set

  Correct Answer: C

• Question 615:

  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

  Correct Answer: B

• Question 616:

  Case-insensitive sorts are always accent insensitive by default.

  A. True

  B. False

  Correct Answer: B

• Question 617:

  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

  Correct Answer: C

• Question 618:

  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

  Correct Answer: A

• Question 619:

  The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?

  A. Languages for server messages

  B. Day and month names and abbreviations

  C. Symbols to represent a.m., p.m., AD, and BC

  D. Affirmative and negative response strings (YES, NO)

  E. None of the above

  F. All of the above

  Correct Answer: F

  Parameter type String Syntax NLS_LANGUAGE = language Default value Operating system-dependent, derived from the NLS_LANG environment variable Modifiable ALTER SESSION Range of values Any valid language name Basic Yes

  NLS_LANGUAGE specifies the default language of the database. This language is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. This parameter also determines the default values of the parameters NLS_DATE_LANGUAGE and NLS_SORT.

• Question 620:

  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

  Correct Answer: E