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=)