ITPub博客

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

408.Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automatically implemented.B. Individual SQL Access Advisor recommendations can be scheduled for implementation.C. All SQL Access Advisor recommendation...

406.Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor, with before and after metricsC. Graphs showing the actual performance improvement m...

405.To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C. From Advisor C...

404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?A. Filter versionsB. Filter loadsC. Filter tasksD. Filter optionsAnswer: D参考：http://docs.oracle.com/cd/E11882_01/server.112/e10822/td...

401.Which of the following are correct about TbMlock media recovery? (Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B. Logical corruptions are repairable by BMR.C. Physical corruptions are repairable by BMR.D. RMAN can us...

399.Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired.C. Datafiles remain online while corrupt blocks are repaired.D. A and CAnswer: B下列哪项不是块介质恢复（BMR）的优势？B、数据文件仍处于脱...

398.Choose the correct order to package and upload data for an incident to Oracle Support.A. Schedule, create new package, view manifest, view contentsB. Create new package, view manifest, view contents, scheduleC. Schedule, create new package, view contents, view manifestD. Create new package, ...

397.Which of the following tasks does the tool Incident Packaging Service (IPS) perform?A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Suppor...

396.Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)A. View long-running SQL workloadsB. View problem detailsC. Gather additional diagnostic informationD. Create a Service RequestE. Clean up incident data after upload to Oracle SupportAnswer: ...

394.Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.B. The default value is the value of the environment v...