ITPub博客

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

（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_TARGET答案：（A、B、C、...

（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 S...

（417）When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF. SORT_AREA_SIZE答案：（E）解析：查看各个参数是否为...

（416）To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor,you can set values for which of the following initialization parameters?(Choose all that apply.)A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF...

（415）For Oracle 11g,Oracle strongly recommends that you configure your database to use which of the following memory-management features?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Man...

（414）By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value,you will enable which of the following memory-management options?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Auto...

（413）Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Manual SGA M...

（412）Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between the capture and replay systemsB. When errors that occur in the capture system dont occur in the replay systemC. Top SQL statements...

（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 begi...