ITPub博客

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

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

（260）Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)A. Diagnose and repair a data file corruption offline.B. Diagnose and repair a data file corruption online.C. Diagnose and repair failures on a standby database.D. Recover from failures in the Rea...

（259）Which setting enables the baselines by default in Oracle Database 11g?  A. setting the STATISTICS_LEVEL parameter to TYPICAL  B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)  C. enabling Automated Maintenance Task using Oracle Ent...

（258）Which two statements are true regarding the SQL Repair Advisor? (Choose two.)A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C. T...

（257）Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)   A. flashback query                        &n...