053第471题

原创 2015年07月09日 10:54:28

471.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



NLS_LENGTH_SEMANTICS

Property Description
Parameter type String
Syntax NLS_LENGTH_SEMANTICS = string

Example: NLS_LENGTH_SEMANTICS = 'CHAR'

Default value BYTE
Modifiable ALTER SESSION
Range of values BYTE | CHAR

The session-level value of NLS_LENGTH_SEMANTICS specifies the default length semantics to use for VARCHAR2 and CHAR table columns, user-defined object attributes, and PL/SQL variables in database objects created in the session. This default may be overridden by the explicit length semantics qualifiers BYTE and CHAR in column, attribute, and variable definitions.

The instance-level value of NLS_LENGTH_SEMANTICS provides a default for the session-level value if NLS_LENGTH_SEMANTICS it is not set explicitly by the database client through the NLS_LENGTH_SEMANTICS client environment variable (does not apply to JDBC Thin clients), or the ALTER SESSION SET NLS_LENGTH_SEMANTICSstatement.

NCHARNVARCHAR2CLOB, and NCLOB columns are always character-based.

Sessions logged in as SYS do not use the NLS_LENGTH_SEMANTICS parameter. They use BYTE length semantics for all created objects unless overridden by the explicit BYTE and CHAR qualifiers in object definitions (SQL DDL statements).

OCP-1Z0-053-V12.02-580题

580.What does the SCN represent? A. The system change number, which is a point in time relative to ...
  • rlhua
  • rlhua
  • 2013年09月22日 23:47
  • 3501

OCP-1Z0-053-200题-80题-657

QUESTION 80 The database is currently open and the temp03.dbf tempfile belonging to the default tem...
  • rlhua
  • rlhua
  • 2014年02月10日 10:47
  • 2841

OCP-1Z0-053-200题-135题-150

QUESTION 135 You have enabled backup optimization in RMAN. You issue the following RMAN command to ...
  • rlhua
  • rlhua
  • 2014年02月08日 21:36
  • 2677

OCP-1Z0-053-200题-108题-161

QUESTION 108 You are using a recovery catalog to maintain Recovery Manager (RMAN) backup informatio...
  • rlhua
  • rlhua
  • 2014年02月09日 10:57
  • 3459

053第502题

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has...
  • adeline_pan
  • adeline_pan
  • 2015年07月19日 11:19
  • 463

053第478题

478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. ...
  • adeline_pan
  • adeline_pan
  • 2015年07月18日 13:07
  • 621

053第521题

521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of t...
  • adeline_pan
  • adeline_pan
  • 2015年07月12日 13:05
  • 742

053第449题

449.Which of the following objects can be directly referenced by a window object? (Choose all that a...
  • adeline_pan
  • adeline_pan
  • 2015年07月16日 12:41
  • 531

053第170题

170.ASM supports all but which of the following file types? (Choose all that apply.) A. Database fi...
  • adeline_pan
  • adeline_pan
  • 2015年07月10日 11:04
  • 408

053 第561题

561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, ...
  • adeline_pan
  • adeline_pan
  • 2015年07月14日 10:35
  • 712
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:053第471题
举报原因:
原因补充:

(最多只允许输入30个字)