ITPub博客

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

132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?A. parallel image copy backupB. backup wit...

146.You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two s...

510.You executed the following command in Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB. a list of files requiring more than 3 days of archive logs to applyC. a list of files that RMAN recom...

621.You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up. (Choose two.)A. The data file backup is done with multiple channelsB. The data files is in the read-write mode after being backed up in the r...

662.To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? (Choose two.)A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first...

652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen durin...

653.View the Exhibits: Exhibit 1 and Exhibit 2Both processes use an existing job template PROG_1. The time taken by the jobs are recorded in theTEST_LOG table. It was observed that the job creation process in exhibit 1 takes less time than in exhibit 2.What is the reason for this?Exhibit:A.It c...

620.You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. (Choose two.)A. To store the backup information of multiple databaseB. To restrict the amount...

612.Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the following command:SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rma...

607.Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corru...