Oracle 053 351-427 译文版

 

QUESTION NO:357(Jesse)

Automatic dataconversion will occur if which of the following happens?

下面哪种情况发生时，将导致自动数据类型转化？

A. The client and server have different NLS_LANGUAGEsettings.客户端和服务器有不同的nls_language设置

B. The client and server character setsare not the same, and the database character set is not a strict superset ofthe 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.

 

QUESTION NO:358?????(Jesse)

下列nls_sort参数值将导致大小写迟钝和口音迟钝二进制排序？

B. NLS_SORT = BINARY_AI

 

QUESTION NO:359

哪个NLS参数可以用于去改变默认oracle sort方法从binary到linguistic为SQL  SELECT语句？

A. NLS_LANG

B. NLS_COMP

C. NLS_SORT

D. None of the above

 

QUESTION NO:360

通过设置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

 

Semantics语义学

 

QUESTION NO:361

哪个不是有效地本地文件类型

A. Language

B. Linguistic sort

C. Calendar历法

D. Territory

E. Character set

 

QUESTION NO:362

How many differentcalendars does Oracle 11g support?11g支持多少不同的历法

B. 7

 

QUESTION NO:363

Which NLS parameterdirectly governs统治，管理 linguistic searches搜寻?

哪一个NLS参数直接管理语言搜索？

A. NLS_SEARCH_L

B. NLS_SORT

C. NLS_SEARCH

D. NLS_SORT_L

E. None of the above

 

QUESTION NO:364

True or false?Case-insensitive sorts are always accent insensitive by default.

默认的，大小写迟钝排序总是重音迟钝的？

A. True

B. False

 

QUESTION NO:365

What is the name of thefile that identifies the set of available locale definitions?识别有效的地点定义集的文件名？

A. locale.def

B. lxdef.ora

C. lx1boot.nlb

D. lx1boot.ora

 

E. lang.def

 

QUESTION NO:366

Which of the followingis not a valid linguistic sort element?

下面哪个不是有效的语言排序元素？

A. Accent expansion重音扩展物

B. Canonical equivalence权威均等

C. Reverse secondary sorting逆向第二排序

D. Ignorable characters可忽视的特征

E. Character rearrangement字符重组

 

QUESTION NO:367

Identify the two directsources from where SQL plans can be loaded into the SQL plan baselines.

识别2个直接源（SQL计划可以导入到SQL计划基线中）

(Choose two.)

A. Cursor cache

B. Stored outline

C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots

 

QUESTION NO:368

 (Choose two.)哪两句关于工作负载捕获和回放操作时正确的？

 

A. The clients must be created manually on the test machinesto perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginningworkload replay to enable a clean state for workload replay.

C. Restart the database in RESTRICTEDmode before beginning workload capture to enable a clean state for capturingthe workload.重启数据库到限制模式（开始工作负载捕获之前，为捕获工作负载启用一个干净的状态）

D. The application state of the capturesystem must be identical to the application state of the replay system when theworkload replay begins.捕获系统的应用程序状态与回放系统的应用程序状态（回放开始之前）必须是统一的

 

QUESTION NO:369

View the Exhibitexhibit1 to examine the series of SQL commands.

View the Exhibitexhibit2 to examine the plans available in the SQL plan baseline.

 The baseline in the first row of the Exhibitis created when OPTIMIZER_MODE was set to FIRST_ROWS.

Which statement is trueif the SQL query in exhibit1 is executed again when the value of

OPTIMIZER_MODE is set toFIRST_ROWS?

A. The optimizer uses a new plan because none of the plansin the exhibit2 are fixed plans.

 

B. The optimizer uses the plan in thesecond row of the exhibit2 because it is an accepted plan.

C. The optimizer uses the plan in the first row of theexhibit2 because it is the latest generated plan.

D. The optimizer uses the plan in the first row of theexhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

 

QUESTION NO:370

Which statementdescribes the effect of table redefinition on the triggers attached to thetable?

A. All triggers on the table remain valid.

B. All triggers on the table areinvalidated and are automatically revalidated with the next DML execution onthe table.

C. All triggers on the table are invalidated and aremanually revalidated with the next DML execution on the table.

D. Only triggers that are affected by the changes to thestructure of the table are invalidated and automatically revalidated with thenext DML execution on the table.

 

QUESTION NO:371

(Choose all that apply.)user_data是一个非加密的表空间 （包含一系列有数据的表）。你想转换所有已经存在的数据到user_data表空间中，新的数据按照加密格式进入。你使用那种方式来完成这个任务?

A. Use Data Pump to transfer theexisting data to a new encrypted tablespace.使用data pump去传输已经存在的数据到一个新的加密表空间。

B. Use ALTER TABLE..MOVE to transferthe existing data to a new encrypted tablespace.  使用later table…move传输已经存在的数据到一个新的加密的表空间中

C. Use CREATE TABLE AS SELECT totransfer the existing data to a new encrypted tablespace. 使用createtable as select 传输已经存在的数据到新的加密表空间中

D. Enable row movement for each table to be encrypted andthen use ALTER TABLESPACE to encrypt the tablespace.启用行移动为每表去加密，使用alter tablespace加密表空间

E. Encrypt the USER_DATA tablespace using the ALTERTABLESPACE statement so that all the data in the tablespace is automaticallyencrypted.

 

QUESTION NO:372

Evaluate the followingblock of code:

BEGIN

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (

acl => 'mycompany-com-permissions.xml',

principal => 'ACCT_MGR',

is_grant => TRUE,

privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (

acl => 'mycompany-com-permissions.xml',

host => '*.mycompany.com');

END;

What is the outcome ofthe above code?上面代码的结果是：

A. It produces an error because a fully qualified host nameneeds to be specified.

B. It produces an error because the range of portsassociated with the hosts has not been specified.

C. It creates an access control list(ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.它创建一个ACL（用户ACCT_MGR获得CONNECT和RESOLVE权限）

D. It creates an access control list (ACL) with the userACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

 

QUESTION NO:373

哪个步骤是强制去启用direct NFS.

1. Mount all required file systems using the kernel NFSdriver.使用kernel NFS驱动 Mount所需要的文件系统

2. Create an oranfstab file containingthe attributes for each NFS server to be accessed using Direct NFS.

3. Replace the ODM library libodm11.so_stub with libodm11.so.替代odm库文件

A. 2 and 3

B. 1 and 3

C. 1 and 2

D. 1, 2 and 3

 

QUESTION NO:374

(Choose all that apply.)在11g中的容错可诊断性基础架构中的问题和事件内容描述正确的是：

 

A. The problem key is the same as the incident number.

B. Every problem has a problem key,which is a text string that describes the problem.每个问题都有自己的问题key（是文本字符串用来描述问题）

C. The database makes an entry intothe alert log file when problems and incidents occur.（当问题和事件发生时，数据库将一条