ITPub博客

22.An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the ...

19.A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?A. It remains valid.B. It becomes invalid for all options of online table redefinition but automatica...

 18.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;You want to suppress ADDM output relating to Seg...

14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works ...

11.View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric?A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values obser...

9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonp...

7.You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.Which statement is true regarding the ACL created?A. It is a list of remote database links stored in the XML...

6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, ...

5.Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061Run Id : 1061Check Name : Data Block Integrity CheckMode :REACTIVEStatus : COMPLETEDStart Time : 2007-05-12 22:11:02.032292 -07:00End Time : 2007-05-12 22:11:20.835135 -07:...

2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?A. The collection level for the AWR should be set to BAS...

106.You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this&nbsp...

103.Observe the following PL/SQL block:BEGIN    dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);END;Which statement is correct regarding the above PL/SQL block?A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.B. It res...

90.View the exhibit and examine the output. Which statement can be an inference from the output? Exhibit:A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. The number of times that the backup or restore process di...

61.Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?A. SQL Repair AdvisorB. SQL OptimizerC. SQL Access AdvisorD. SQL Tuning AdvisorAnswer: D参考：http://docs.oracle.com/cd/E11882_01/se...

44.You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?A. The Automatic Memory Manager (AMM)B. The SQL Tuning AdvisorC. The Segment AdvisorD. The SQL Access AdvisorAnsw...

40.Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255);SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customers WHERE cust_state_province =''CA''';:task_name := 'MY_QUICKTUNE_TASK';DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name...

39.View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit?A. Accept the recommended SQL profile.B. Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Seg...

38.The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?A. statistics recommendationsB. SQL Profile recommendationsC. Index-related recom...

47.You issue the following command on the RMAN prompt.REPORT NEED BACKUP DAYS 5;Which statement is true about executing this command?A. It will display a list of files that need incremental backupB. It will display a list of files that need backup after five daysC. It will display a list of fil...

69.The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)WHERE ename = 'ALLEN';What are the minimum requirements for the statement to execute successfully? (Choose all that apply)A.ARCHIVELOG mo...