ITPub博客

（280）View the Exhibit to examine the replay settings for replay parameters. What is the implication for setting the values for replay parameters? (Choose all that apply.)A. The COMMIT order in the captured workload is preserved during replay.B. The value 100 in the THINK_TIME...

（279）Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into ...

（278）You issued the following command:CREATE GLOBAL TEMPORARY TABLE admin_work_area(  startdate DATE,  enddate   DATE,  class     CHAR(20)...

（277）The BOOKINGS table contains online booking information.When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table.There is no fixed time interval between each online booking and its confirmation.Because sufficient...

（276）The following command is executed to create the baseline template:（276）The following command is executed to create the baseline template:EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME => TO_TIESTAMP(SYSDATE + 2),  &nbsp...

（275）You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? (Choose three.)A.   Even with resumable space allocation enabled for your database,...

（274）The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?A. statistics recommendationsB. SQ...

（273）Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by ...

（272）You issue the following RMAN command to set a retention policy on a database:RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;What will be the outcome of issuing this command?A. After two days, a backup will be marked obsoleteB. After two days, a backup will be deleted from the ...

（266）View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks...

（270）Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor答案：（A...

（269）Examine the following set of RMAN commands:RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT '/u02 /backup/ %U';RMAN> RUN(  ALLOCATE CHANNEL Chi DEVICE TYPE DISK;  EXECUTE SCRIPT full_ba...

（268）You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog.You have been taken database backups every evening.On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you foun...

（266）View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks...

（265）View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view.PRODCAT_VW is used in the GET_DATA procedure.GET_DATA is called in the CHECK_DATA function.A new column PROD_QTY is added to the PRODUCTS table.How does this imp...

（264）Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)  A. stored scripts in the recovery catalog  B. backups that can be deleted from disk  C. backup set...

（263）Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g toupload the physical files generated by Incident Packaging Service (IPS) to MetaLink?A. The database must be running in ARCHIVELOG mode.B. No special setup is required, and the feature...

（262）In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)  A. partitioning recommendations  B. statistics collection recommendations  C. index creation recommendations  D. materialized view recomm...

（261）In which cases is reference partitioning effective in enhancing performance?A. It is effective only in partition pruning.B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C. It is effective in both partition pr...