ITPub博客

455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DROP attribute is FALS...

452.Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the aboveAnswer: ABD以下哪些调度器元素鼓励对象的重用？Schedule objects do not specify any action to be performed; the...

450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer: AD参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357下列哪一个是轻量...

445.To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAMEAnswer: AD要为窗口...

443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTEAnswer: AE参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72402哪些DBMS_SCHEDULER...

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_ENABLEDAnswer: AD哪些DDBMS_SCHEDULER过程可以用来启用程序？Programs (as well as jobs) can be enabled in two ways: by using the ENA...

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.Answer: B哪一个DBMS_RESOURCE_MANAGER...

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 aboveAnswer: ABD哪些代表数据库资源管理器的主要组成部分？A、资源消费者组B、资源...

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 aboveAnswer: 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 aboveAnswer: ACD你可以使用段收缩用于以下哪些？The Segment Shrink feature can be used on tables, inde...

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_EXTAnswer: B参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_tdb.htm#ARPLS688...

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

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 from source to d...

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$database dwhere t.endian_format = (select ...

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

420.Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)A. SORT_AREA_SIZEB. HASH_AREA_SIZEC. BITMAP_MERGE_AREA_SIZED. CREATE_BITMAP_AREA_SIZEE. PGA_AGGREGATE_TARGETAnswer: ABCD自动程序全局区内存管...

419.In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_TARGETB. Configuring Automatic Shared Memory ManagementC. Configuring Automatic Memory ManagementD. Setting a nonzero value for SGA_MAX_SIZE a...

418.Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF. SORT_AREA_SIZEAnswe...

411.Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to restart one instance to begin workload capture.C. Specifically in RAC, you shut down all instances, restart them individually, and begin worklo...

410.Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)A. Make sure your replay database has the same structure as the capture database, except without data.B. Make sure the replay and capture databases are similar in data content.C. Perform a c...