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.（当问题和事件发生时，数据库将一条entry写到alertlog 文件中）
D. The database sends an incident alertto the Oracle Enterprise Manager Database Home page.（数据库发送一个事件警告到OEM数据库home页面。）
E. Only the incident metadata and dumps are stored in theAutomatic Diagnostic Repository (ADR).
QUESTION NO:375
你正在管理11g库。你想执行一个users表空间的备份到tape驱动器。这个表空间有一个单个数据文件为300m。磁带驱动器每个为300mb。为了完成备份，你发起以下RMAN命令：
RMAN>BACKUP SECTION SIZE 300M TABLESPACEusers;
通过使用上面命令快速和高效的完成备份，什么配置应该设置？
A. The SBT channelmust be configured, with the MAXPIECESIZE set to 300 MB.
QUESTION NO:376
(Choose two.)当执行一个sql工作负载时，你选择只生成执行计划，没有收集执行统计。描述正确的2句：
A. It produces less accurate results ofthe comparison analysis.它产生少量精确的对比分析结果
B. It automatically calls the SQL Tuning Advisor forrecommendations.它自动调用sql调优建议器为推荐方案。
C. It shortens the time of executionand reduces the impact on system resources.它缩短了执行时间和降低了系统资源的影响
D. Only the changes in the execution plan, and notperformance regression, are detected.只有执行计划中的修改，无性能衰退被检测
QUESTION NO:377
你正在管理一个11g库(用ASM存储)。数据库有一个big文件表空间。你想文件快速打开，在共享池中占用很少的内存（去管理extent maps）。哪些配置将将能够完成你的目标？
ASM兼容性属性匹配ASM磁盘组；compatible初始化参数匹配数据库实例
A. Set the ASM compatibility attribute for the ASMdisk group to 11.1.0.
设置ASM磁盘组的ASM兼容属性为11.1.0
B. Set the RDBMS compatibility attribute for the ASM diskgroup to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASMinstance to 11.1.0.
D. Set the COMPATIBLE initializationparameter for the database instance to 11.1.0. 设置数据库实例的compatible初始化参数为11.1.0
QUESTION NO:378
你想进行一个users表空间的备份。它有一个独立的文件900mb。你的磁带驱动器为300mb（每个）。配置了SBT通道。为了完成备份，你发起下列RMAN命令：
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
关于上面命令执行描述正确的是：
(Choose two.)
A. The backup piece size will belimited to 300 MB.备份片限制为300mb
B. The operation is accomplished usingthe default channel available.使用默认通道来完成操作。
C. The RMAN parallelizes the backup although the parallelismis not set for a channel.
D. Three channels for the tape drive must be configured bysetting the parallelism to three.
QUESTION NO:379
View the Exhibit.
Examine the followingcommand that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe','(country_id,cust_state_province)') FROMdual;
这个命令描述重要的语句是：
A. It collects statistics into the pending area in the datadictionary.
B. It creates a virtual hidden column in theCUSTOMERS_OBE table.它在customers_obs表中创建了一个虚拟隐藏列。
C. It collects statistics with AUTO_SAMPLE_SIZE forESTIMATE_PERCENT.
D. It creates a histogram to hold skewed information aboutthe data in the columns.
QUESTION NO:380
View the Exhibit toexamine the parameter values.
你计划设置你的数据库实例的memory_target参数的值。你指定什么值？
A. 90 MB
B. 272 MB
C. 362 MB
D. 1440 MB
QUESTION NO:381
你安装11g，执行一个手工升级从oracle9i。作为升级的一部分，你执行了以下脚本:
SQL>@utlu111i.sql
关于这个脚本执行描述正确的语句
C. It must be executed from theenvironment of the database that is being upgraded.它必须被执行（从需要被更新的数据库的环境中）
QUESTION NO:382（Jesse）
(Choose three.)通过SQL性能分析器进行性能分析描述正确的3句：
A. It detects changes in SQL executionplans.在SQL执行计划中检测changes
B. It produces results that can be usedto create the SQL plan baseline.它产生结果（可用于创建sql计划基线）
C. The importance of SQL statements is based on the size ofthe objects accessed.
D. It generates recommendations to runSQL Tuning Advisor to tune regressed 逆行SQLs.它产生推荐方案去运行sql调优建议器去调优逆向的sql文本
E. It shows only the overall impact on workload and not thenet SQL impact on workload.
QUESTION NO:383
(Choose all that apply.)哪个任务可以使用EM支持工作台来完成，在11g中？
A. Generate reports on data failure such as data filefailures.
B. You can package and uploaddiagnostic data to Oracle Support.打包和上传诊断数据到oracle support
C. You can track the Service Request(SR) and implement repairs.跟踪服务器请求并实现修复
D. You can manually run health checksto gather diagnostic data for a problem.你可以手工运行状态检查去收集问题的诊断数据
QUESTION NO:384
关于validatedatabase命令描述正确的语句是：
A. It checks the database for intra blockcorruptions only.它只检查数据库内部坏块
B. It checks for block corruption in the valid backups ofthe database.
C. It checks the database for both intrablock and interblockcorruptions.
D. It checks for only those corrupted blocks that areassociated with data files.
QUESTION NO:385
(Choose two.)启用flashback data archive的先决条件是：
A. Undo retention guarantee must be enabled.
B. Database must be running in archivelog mode.
C. Automatic undo management must beenabled.自动undo管理必须启用
D. The tablespace on which theFlashback Data Archive is created must be managed with Automatic Segment SpaceManagement (ASSM).闪回数据归档所创建的表空间呢必须被ASSM所管理。
Explanation:
QUESTION NO:386（Jesse重点）
.你正在管理appprod数据库。你计划复制这个数据到同一系统下，名字叫dupdb。
发起下列RMAN命令去创建一个复制数据库：
RMAN> CONNECT target sys/[email protected]
RMAN> DUPLICATE TARGETDATABASE
TOdupdb
FROM ACTIVE DATABASE
DB_FILE_NAME_CONVERT'/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/'
SPILE
PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/'
SET SGA_MAX_SIZE = '300M'
SET SGA_TARGET = '250M'
SET LOG_FILE_NAME_CONVERT'/oracle/oradata/prod/redo/',
'/scratch/oracle/oradata/dupdb/redo/';
成功执行以上命令的3个先决条件： (Choose three.)
A. The source database should be open.
B. The target database should be inARCHIVELOG mode if it is open.如果target数据库打开的话，需要处于archivelog模式
C. RMAN should be connected to both theinstances as SYSDBA. RMAN应该以SYSDBA身份连接到两个实例
D. The target database backups should be copied to thesource database backup directories.目标数据库备份应该copy到源数据库备份目录下
E. The password file must exist for thesource database and have the same SYS user password as the target. 在源数据库中的口令文件必须存在，且与target有相同的SYS用户的密码
QUESTION NO:387
(Choose all that apply.) 你正在管理一个11g asm实例（一个ASM兼容性属性设置为11.1.0的磁盘组右3个磁盘，冗余设置为high。）磁盘组中的某个磁盘不可用，因为电源失效。下面哪个语句是正确的？
A. The disk automatically goes offline.
B. The disk is immediately dropped from the disk group.
C. The ASM tracks the extents that aremodified during the outage.
D. The ASM migrates the extents from theunavailable disk to the remaining disks.
QUESTION NO:388
关于在ADR中积累accumulated的事件的保留策略正确的是：
D. The default setting is for one yearafter which the incident metadata is purged from the ADR and the files areretained for one month.事件元数据从ADR中清空是默认值1年。文件保留1个月
ADR记录的事件元数据存储1年，文件保留1个月
QUESTION NO:389 钱包关闭，产生错误。
你打开一个加密钱包encryption wallet，发起下面命令：
SQL>CREATE TABLESPACE securespace
DATAFILE '/home/user/oradata/secure01.dbf'
SIZE 150M
ENCRYPTION USING '3DES168'
DEFAULT STORAGE(ENCRYPT);
接着你关闭了wallet。以后，你发起下列命令去创建employees表，在securespace表空间中。你为empid列使用了nosalt选项。
输出是什么？
A. It creates the table and encrypts the data in it.
B. It generates an error because thewallet is closed.它产生了一个错误，因为wallet处于关闭状态。
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannotbe used with the ENCRYPT option.
QUESTION NO:390
Examine the followingPL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
上面的Pl/SQL块执行的描述语句？
D. The nonaccepted plans in the SQLManagement Base are verified with the existing plan baselines.在SMB中的未接受的计划被验证（用已经存在的计划基线）
QUESTION NO:391
(Choose two.)热补丁区别于传统补丁的两方面：
A. It consumes more memory comparedwith conventional patching.它消耗更多的内存，比传统补丁
D. It does not require down time toapply or remove unlike conventional patching.它不需要宕机时间去应用或删除补丁时。
QUESTION NO:392
关于11g中表压缩启用正确的描述是：
D. Compression can be enabled at thetable, tablespace, or partition level for both direct loads and conventionalDML.在表，表空间或分区级别可以启用压缩（针对直接导入和传统DML）
QUESTION NO:393（Jesse）
(Choose allthat apply.)在你的数据库上执行闪回事务的先决条件是：
A. Supplemental log must be enabled.追加日志必须启用
B. Supplemental log must be enabled forthe primary key追加日志必须启用在PK上.
C. Undo retention guarantee for the database must beconfigured.数据库的undo保留保护必须配置。
D. Execute permission on theDBMS_FLASHBACK package must be granted to the user.在DBMS_FLASHBACK包上的执行权限必须授权给用户。
Explanation:
QUESTION NO:394 100tb—10g—intrafileparallel backup
You are managing anOracle Database 11g database. You want to take the backup of MULT_DATA, a bigfile tablespace of size 100 TB on tape drive, but you have tape drives of only 10GB each. Which method would accomplish the task quickly and efficiently?
A. intrafile parallel backup
B. parallel image copy backup
C. backup with MAXPIECESIZE configured for the channel
D. parallel backup with MAXPIECESIZE configured for the channel
QUESTION NO:395
(Choose all that apply.)关于查询结果query result cache描述正确的是？
A. It can be set at the system,session, or table level.它可以设置在system，session，table级别
B. It is used only across statements in the same session.
C. It can store the results from normalas well as flashback queries.它可以存储结果（normal和flashback查询）
D. It can store the results of queries based on normal,temporary, and dictionary tables.
QUESTION NO:396
(Choose two.)你想使用sql性能分析器去分析一个sql调优集（在test库中）。在一个sql调优集中的sqls测试执行期间执行的活动描述正确的是：
A. Every SQL statement in the STS isconsidered only once for execution.在STS中的每个SQL语句只被考虑一次（执行）。
B. The SQL statements in the STS are executed concurrently 同时的to produce the execution plan and execution statistics.STS中的sql语句被执行时，同时产生执行计划和执行统计。
C. The execution plan and executionstatistics are computed for each SQL statement in the STS.在STS中的每条SQL语句的执行计划和执行统计被计算
D. The effects of DDL and DML are considered to produce theexecution plan and execution statistics. DDL和DML的影响被考虑去产生执行计划和执行统计。
QUESTION NO:397
(Choose two.)通过使用数据库回放功能，在系统上的哪两个改变和他们的影响可被测试？
A. multiplexing of the control file
B. database and operating systemupgrades
C. adding the redo log member to the database
D. changing the database storage toASM-managed storage
QUESTION NO:398（Jesse）
你执行下列命令：
SQL>ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS= false;
SQL> EXECUTEDBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');
SQL> EXECUTEDBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
哪个语句是正确的，关于在上面的会话中的在sh.customers表上面统计收集？
A. The statistics are stored in thepending statistics table in the data dictionary.统计信息存储在未决统计表中（数据字典中的）
B. The statistics are treated as the current statistics bythe optimizer for all sessions.
C. The statistics are treated as the current statistics bythe optimizer for the current sessions only.
D. The statistics are temporary and used by the optimizerfor all sessions until this session terminates.
QUESTION NO:399
数据库资源管理器在（运行自动化维护任务的）维护窗口中是自动启动的。这是什么原因呢？
D. to prevent the Automated MaintenanceTasks from consuming 消费的excessive过度的 amounts of systemresources预防自动化维护任务消耗过度的系统资源。
QUESTION NO:400
Which is the source usedby Automatic SQL Tuning that runs as part of the AUTOTASK framework?哪个源可以由自动化sql调优（作为AUTOTASK架构的一部分运行）使用。
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR topSQL identification 基于AWR的top sqlidentification的sql语句
C. SQL statements that are part of the available SQL TuningSet (STS) only
D. SQL statements that are available in the cursor cache andexecuted by a user other than SYS
Topic 5, Pool5
QUESTION NO:401
View the Exhibit andexamine the output.
You executed thefollowing command to enable FlashbackData Archive on the
EXCHANGE_RATE汇率兑换表 table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
这个命令的输出结果是：
D. The command generates an errorbecause no Flashback Archive name is specified and there is no defaultFlashback Archive.这个命令产生一个错误因为no flashbackarchive名字没有被指定（这里没有默认的flashback archive）
QUESTION NO:402
View the Exhibit toexamine the error duringthe database startup.数据库启动过程中的错误
你打开RMAN会话（数据库实例）。去修复这个失败，你执行了下列命令作为第一个命令。
RMAN> REPAIR FAILURE;
这个命令结果描述正确的是：
C. The command produces an errorbecause the ADVISE FAILURE command has not been executed before the REPAIRFAILURE command.这个命令产生一个错误因为advise failure命令没有被执行（在执行repair failure命令之前）
QUESTION NO:403
你发起下列命令在临时表空间lmtemp上：
SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;
为了这个命令成功的执行，哪个需求必须被满足fulfilled？
A. The tablespace must be locallymanaged.表空间必须是本地管理。
B. The tablespace must have only one temp file.
C. The tablespace must be made nondefault and offline.
D. The tablespace can remain as the default but must have noactive sort operations.
Explanation:
QUESTION NO:404
(Choose two.)关于flashback table功能描述正确的两句：
A. Flashback Table can be performed on system tables.
B. Flashback Table operation does notshrink the segments.闪回表操作不能收缩区间
C. Flashback Table uses log mining to extract SQL_REDO andSQL_UNDO statements.
D. Flashback Table operation acquiresexclusive data manipulation language (DML) locks.闪回表操作获取排它的DML锁。
QUESTION NO:405
Which configurationshould you use to accomplish this task?
你作为一个DSS系统的 DBA。这里有一个业务需求，跟踪和存储数据库中少数表的所有的事务至少3年。Automaticundo management在数据库中被启用。你应该使用哪个配置来完成这个任务？
A. Enable Flashback Data Archive forthe tables.
B. Enable supplemental logging for the database.
C. Specify undo retention guarantee for the database.
D. Create Flashback Data Archive on the tablespace on whichthe tables are stored.
E. Query V$UNDOSTAT to determine the amount of undo thatwill be generated and create an undo tablespace for that size.
QUESTION NO:406
你的组织决定去升级10g到11g（多cpu环境），在升级结尾，你注意到dba执行了以下脚本：
SQL> @utlrp.sql
执行这个脚本的重要意义：
C. It performs parallel recompilationof any stored PL/SQL as well as Java code.它执行存储Pl/SQL和java代码的并行重新编译。（编译无效对象）
QUESTION NO:407
(Choose two.) ASM metadata backup and restore (AMBR)功能的使用，哪两个？
A. It can be used to back up all data on ASM disks.
B. It can be used to re-create the ASMdisk group with its attributes.可用于重建ASM磁盘组（用它的属性）。
C. It can be used to recover the damaged ASM disk group alongwith the data.
D. It can be used to gather informationabout a preexisting ASM disk group with disk paths, disk name, failure groups,attributes, templates, and alias directory structure.可用于收集信息（关于已存在的ASM磁盘组，磁盘路径，磁盘名，失败组，属性，模版和别名目录结构）
QUESTION NO:408
You executed thefollowing PL/SQL block successfully:你成功执行以下Pl/SQL块
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (
NULL, DIR_NAME=>'Detail CPU Usage',
FINDING_NAME=>'CPU Usage',
MIN_ACTIVE_SESSIONS=>0,
MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150, 162);
END;
/
接着执行以下命令：
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
上面命令产生ADDM分析（如果<90,则没有cpu使用率被发现）
B. without the CPU Usage finding if itis less than 90如果<90，则没有cpu使用率发现。
QUESTION NO:409
(Choose all that apply.)哪个语句描述了DBMS_NETWORK_ACL_ADMIN包的能力？
A. It can be used to allow the access privilege settingsfor users but not roles.
B. It can be used to allow the accessprivilege settings for users as well as roles.它可以用于去允许访问权限设置（为了用户，角色）
C. It can be used to control the time intervalfor which the access privilege is available to a user.它可用于去控制时间间隔（访问权限的有效性，对于用户来说）
D. It can be used to selectively 不普遍地restrict theaccess for each user in a database to different host computers.它可用于不普遍地限制数据库中每个用户对不同主机的访问
E. It can be used to selectively restrict a user's access todifferent applications in a specific host computer.
QUESTION NO:410？？（Jesse）需要看如何关联任务？
为了提升一个程序中的一套SQL查询的性能而产生推荐方案，你执行下列代码块：
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1');
END;
/
BEGIN
dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL');
dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE');
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK1'));
END;
/
代码块执行成功；然而你没有得到需要的数出。什么原因造成的呢？
A. A template needs to be associated with the task.
B. A workload needs to be associatedwith the task.一个工作负载需要关联任务
C. The partial or complete workload scope needs to beassociated with the task.
D. The type of structures (indexes, materialized views, orpartitions) to be recommended need to be specified for the task.
QUESTION NO:411
你正在管理一个oracle11g实例（用ASM存储）。ASM实例down。为了知道data磁盘组中磁盘的详细信息，你发起下列ASMCMD命令：
ASMCMD> lsdsk -I -d DATA
关于这个命令输出正确的是：
A. The command succeeds but it retrieves only the disknames.
B. The command produces an error because the ASM instance isdown.
C. The command succeeds but it shows only the status of theASM instance.
D. The command succeeds and retrievesinformation by scanning the disk headers based on an ASM_DISKSTRING value.命令执行成功，通过基于ASM_DISKSTRING值来扫描diskheader信息。
QUESTION NO:412 （Jesse）
你计划设置AWR基线度量阈值（为一个移动windows基线）。在你执行这个任务之前，你应该有什么动作？
A. Compute the baseline statistics.计算基线的统计
B. Take an immediate AWR snapshot.
C. Decrease the window size for the baseline.
D. Decrease the expiration time for the baseline.
QUESTION NO:413
你需要创建一个分区表去存储历史数据，你发起下列命令：
CREATE TABLE purchase_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL (1,'month')) STORE IN (tbs1,tbs2,tbs3)
(
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005','dd-mm-yyyy')),
PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007','dd-mm-yyyy')))
AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007','dd-mm-yyyy');
上面命令的输出是：
A. It returns an error because the range partitions P1 andP2 should be of the same range.
B. It creates two range partitions (P1, P2). Within eachrange partition, it creates month wise subpartitions.
C. It creates two range partitions ofvarying range. For data beyond '1-1-2007,' it creates partitions with a widthof one month each.它创建两个变化范围的范围分区。超出1-1-2007的数据，它创建分区（用一个月宽度）
D. It returns an error because the number of tablespaces(TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2)specified.
Explanation:
QUESTION NO:414
View the Exhibit toexamine the Automatic Database Diagnostic Monitor (ADDM) tasks.考察automatic database diagnostic monitor任务
You executed thefollowing commands:执行下列命令：
SQL> VAR tname VARCHAR2(60);
SQL>
BEGIN
:tname := 'my_instance_analysis_mode_task';
DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT');
END;
Which statementdescribes the consequence?哪句描述结论？
A. The ADDM task is filtered to suppress the Segment Advisorsuggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisorsuggestions for the SCOTT schema only.
C. The PL/SQL block produces an errorbecause the my_instance_analysis_mode_task task has not been reset to itsinitial state.PL/SQL块产生一个错误，因为my_instance_analysis_mode_task任务不能重置到它的初始状态。
D. All subsequent ADDM tasks including my_instance_analysis_mode_taskare filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
| var tname VARCHAR2(60); BEGIN DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(NULL, 'my Segment directive','SCOTT'); :tname := 'my_instance_analysis_mode_task'; DBMS_ADDM.ANALYZE_INST(:tname, 1, 2); END; To see a report containing all actions regardless of the directive: SELECT DBMS_ADVISOR.GET_TASK_REPORT(:tname, 'TEXT', 'ALL') FROM DUAL; |
Explanation:
QUESTION NO:415（Jesse，从cursor_cache中导入计划，accepted状态）
Examine the followingPL/SQL block:
DECLARE
my_plans pls_integer;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id=> ?9twu5t2dn5xd?;
END;
关于通过上面命令导入sql 计划基线描述正确的是：
A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTEDstatus.
C. It is not loaded with the ENABLED status.
D. It is not loaded with the ACCEPTED status.
QUESTION NO:416
View the Exhibitexhibit1 to observe the maintenance window property.
View the Exhibitexhibit2 to examine the output of the query.
(Choose two.)哪两个语句描述结论：
意思是增加工作时间；提高资源使用率
A. The window duration should beincreased.
B. RESOURCE_PERCENTAGE should beincreased.
C. RESOURCE_PERCENTAGE should be decreased.
D. The repeat time for the window should be decreased.
QUESTION NO:417
Evaluate the followingstatements:
CREATE TABLEpurchase_orders
(po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pkPRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUESLESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),
PARTITION Q2 VALUES LESSTHAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITION Q3 VALUES LESSTHAN (TO_DATE(?1-oct -2007?d-mon-yyyy?),
PARTITION Q4 VALUES LESSTHAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLEpurchase_order_items
(po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOTNULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
(Choose two.)上面语句的两个结论是：
A. Partitions of PURCHASE_ORDER_ITEMS have system-generatednames.
B. Both PURCHASE_ORDERS andPURCHASE_ORDER_ITEMS tables are created with four partitions each.两个表，每一个都创建在4个分区上
C. Partitions of thePURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions ofthe PURCHASE_ORDERS table.items表与Orders表存在相同的表空间上
D. The PURCHASE_ORDER_ITEMS table inherits the partitioningkey from the parent table by automatically duplicating the key columns.
E. Partition maintenance operations performed on thePURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERStable.
QUESTION NO:418（Jesse，）
(Choose all that apply.)关于securefile LOBs正确的是：
A. The amount of undo retained is user controlled.（undo的总量保持被用户控制）
B. SecureFile LOBs can be used only for nonpartitionedtables.
C. Fragmentation is minimized by usingvariable-sized chunks dynamically.同构使用动态的可变大小chunks使分裂最小化
D. SecureFile encryption allows for random reads andwrites of the encrypted datA.安全文件加密考虑到allow for 加密数据的随机读和写
E. It automatically detects duplicate LOB data and conservesspace by storing only one copy.它自动监测duplicate LOB数据和保存空间（通过存储一个副本）
QUESTION NO:419
View the Exhibit forsome of the current parameter settings.当前的参数设置
A user logs in to the HRschema and issues the following commands:一用户登陆到HR模式下，发起下列命令：
SQL> CREATETABLE emp
(empnoNUMBER(3),
enameVARCHAR2(20),
salNUMBER(8,2));
SQL>INSERT INTO emp(empno,ename) VALUES(1,'JAMES');
At this moment当时, a second user also logs in to the HR schema and issuesthe following command:当时，第二用户也登陆到HR模式，发起下列命令
SQL>ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in theabove scenario?
A. A deadlock is created.
B. The second user's command executes successfully.
C. The second user's session immediately produces theresource busy error.
D. The second user's session waits fora time period before producing the resource busy error.第二个用户会话等待一个事件周期，在产生资源忙之前。
QUESTION NO:420
You upgradedOracle Database 10g to Oracle Database 11g. How would this affect the existing users'passwords?你升级10g到11g。将怎样影响你已经存在用户的密码？
A. All passwords automatically become case-sensitive.
B. All passwords remainnon-case-sensitive till they are changed.直到他们被修改，所有的密码保持不区分大小写
C. All passwords remain non-case-sensitive and cannot bechanged.
D. All passwords remain non-case-sensitive until theirpassword attribute in the profile is altered.
QUESTION NO:421（Jesse）
Sql访问建议器为优化sql查询提供什么推荐方案？
(Choose all that apply.)
A. selection of SQL plan baselines
B. partitioning of tables and indexes表分区和索引
C. creation of index-organized tables
D. creation of bitmap, function-based,and B-tree indexes位图，函数，b树索引的创建
E. optimization of materialized viewsfor maximum query usage and fast refresh最大化查询使用和快速刷新的物化视图的优化法
![[每日一题] 11gOCP 1z0-052 :2013-09-24 temporary tables.........................................C11[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)