ITPub博客

（660）You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1.Set the retention target: SQL>ALTER SYSTEM SET D...

（659）Which two commands never trigger an implicit rebalancing within the disk group?.(Choose two.)A. ALTER DISKGROUP misc MOUNT;    B. ALTER DISKGROUP misc DROP DISK misc2;C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E. ...

（658）Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager（RMAN）.(Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup inform...

（657）The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.What steps should you take to recover from this tempfile loss in an efficient manner?A. Allow the database to continue running,drop the TEMP tablespace,and t...

（656）The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.Which statement is true while performing a tape backup in an RMAN session?A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area(SGA)C. The tape buffer is...

（655）Examine the following ALTER command:SQL>ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops within the disk group.B. It restores disks that are being dropped as the result of a DROP DISKGROUP operationC. It mounts dis...

（654）You are using Recovery Manager（RMAN）with a recovery catalog to back up your production database.The backups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalo...

（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 the TEST_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?Exh...

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

（651）The user SYS creates a job by using the following command:begin  dbms_scheduler.create_job(job_name => 'update_sales',                  &nbs...

（650）Which three tasks can be performed using a duplicate database?(Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating...

（649）Examine the CREATE DISKGROUP command used to create a disk group:SQL>CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL:FRA3' NAME misc1, 'ORCL:FRA4' NAME misc2;In which situation would you use this method of disk group creation?A. When two-way disk mirroring is required for the ...

（648）Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN<scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP<timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 1...

（646）View the exhibit and examine the TRANS table's storage information.After a massive delete operation,you executed the following statement to shrink the TRANS table:SQL>ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?A. An error is prod...

（645）Which two statements are true about a job chain?(Choose two.)A. A job chain can contain a nested chain of jobs.B. The jobs in a job chain cannot have more than one dependency.C. A job of the CHAIN type can be run using event-based or time-based schedules.D. The jobs in a job ch...

（644）View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management(ASM).Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?A. Because the FR...

（643）View the Exhibit.You are creating a database by using Database Configuration Assistant(DBCA).You have chosen the File System option as the storage mechanism.What would be the result of choosing this option?Exhibit:A. Disk mirroring and striping would be done automaticallyB....

（642）In your production database,users report that they are unable to generate reports on an important table because it does not contain any data.While investigating the reason,you realize that another user executed the TRUNCATE TABLE command,which accidentally caused the data to be lost.No...

（641）Which three functions are performed by the SQL Tuning Advisor?(Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap,function-based,and B-tree indexesE. Rec...