ITPub博客

（440）Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTE答案：（C）解析：查看DBMS_SCHEDULER包的定义支持的calendar syntax:FREQINTERVALBYMONTHBYWEEKNOBYYEARDAY...

（439）Which DBMS_SCHEDULER procedures can be used to enable a program?(Choose all that apply.)A. ENABLEB. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTEE. SET_ENABLED答案：（A、D）解析：查看DBMS_SCHEDULER包，B，C，E这三个过程根本就没有...

（438）When setting arguments for a job,which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?A. SET_JOB_ARGUMENT_VALUEB. SET_JOB_VALUE_ANYDATAC. SET_JOB_ANYDATA_VALUED. SET_SPECIAL_JOB_VALUEE. SET_JOB_ANYTYPE_VALUE答案：（C）...

（437）Within a resource-plan definition,what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.C. There is no differenc...

（436）Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIORITIZE_MAPPING_ORDERE. This functionality is not available through the DBMS_RESOURCE_MANAGER package.答案：（B）解析...

（435）Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPS答案：（E）

（434）Which of these represent the main components of Database Resource Manager?(Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Resource-plan groupsD. Resource-plan directivesE. All of the above答案：（A、B、D）解析：《administrator》 第27章...

（433）When shrinking a table segment,you choose to shrink all the indexes for that table using the SHRINK SPACE command.Which clause should you use?A. INCLUDING DEPENDENCIESB. INCLUDING DEPENDENCIES CASCADEC. COMPACTD. CASCADEE. None of the above答案：（D）...

（432）For which of the following can you use Segment Shrink?(Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partitions and subpartitionsE. None of the above答案：（A、C、D）解析：下面这些都不能进行联机段空间收缩：IOT ma...

（431）Which of the following options describes Segment Shrink?A. Reclaims space above and below the high-water mark without using additional spaceB. Moves rows to a new physical location,resetting the high-water mark,but uses additional space during the operationC. Deallocates space abov...

（430）Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?A. The database must be in read-write mode.B. The database must have no external files.C. The database must open in read-only mode.D. The database must be mounted but not opened....

（429）Which of the following supplied functions is used to identify external tables,directories,and BFILES?A. DBMS_TDB.CHECK_DIRECTORIESB. DBMS_TDB.CHECK_EXTERNALC. DBMS_TDB.CHECK_BFILED. DBMS_TDB.CHECK_EXT答案：（B）解析：（DBMS_TDB中一共就2个存储函数：CHECK_DB和CHECK_...

（428）Which of the following are prerequisite steps to transport a database?(Choose all that apply.)A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.B. Verify that there are no restrictions or limitations that the source or...

（427）When exporting metadata for the transportable tablespaces,what is the correct next step after confirming endian format?A. Export the tablespaces using data pump.B. Determine if the transportable set is self-contained.C. Convert the datafiles using RMAN.D. Copy the datafiles fro...

（426）The following query will provide what information about transportable tablespaces for the current database?(Choose all that apply.)select d.platform_name "Source", t.platform_name "Compatible Targets", endian_formatfrom v$transportable_platform t, v$databa...

（425）Which of the following are included in a transportable tablespace set?(Choose all that apply.)A. The datafiles that make up a self-contained group of tablespaces required for copyB. The system tablespaceC. An export of the tablespace metadataD. The spfileE. All of the above...

（424）Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?A. Username,instance number,session IDB. Instance number,username,session IDC. Instance number,session ID,usernameD. Username,session ID,instance numberE. None of the ...

（423）Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.B. The resumable setting for the initiating instance determines the resumable c...

（422）To enable resumable space allocation for the instance,which of the following initialization parameters should you set to a nonzero value?A. RESUMABLE_SPACE_TIMEB. RESUMABLE_SPACEC. RESUMABLE_TIMED. RESUMABLE_TIMEOUTE. TIME_RESUMABLE答案：（D）解析：RESUMABLE_T...

（421）When tuning Automatic PGA Memory Management,which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKA...