ITPub博客

（698）In your production database, you Are using Recovery Manager(RMAN)with a recovery catalog to perform the backup operation at regular intervals，set the control file autobackup to on，Are maintaining image copies of the database files.You have lost the server parameter file(SPFILE) and t...

（697）Which statement is true about a Scheduler-generated event?A. It can be generated when a file arrives on the file system.B. It indicates state changes that occur within the Scheduler itself.C. It is raised by an application that is consumed by the Scheduler to start a job.D. It ...

（696）Examine the following command for RMAN backup:RMAN>RUN{  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;  ALLOCATE CHANNEL c3 DEVICE TYPE sbt; &nb...

（695）Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog.(Choose two.)A. configuring control file autobackup to be ONB. backing up data filed only and not the archived redo log filesC. running the recovery catalog d...

（694）As part of archiving the historical data,you want to transfer data from one database to another database,which is on another server.All tablespaces in the source database are read/write and online.The source and target databases use the same compatibility level and character sets.V...

（693）Which two statements are true about an image copy backup?(Choose two.)A. It may only be taken to disk.B. It will contain only the used blocks.C. It will contain all used and unused blocks.D. It can be performed on disk as well as on tape.答案：（A、C）

（692）Your company wants to upgrade the production database to a Real Application Clusters(RAC)environment.You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.The following steps may be used to replay the database ...

（691）You work in a data warehouse environment that involves the execution of complex queries.The current content of the SQL cache contains the ideal workload for analysis.You want to analyze only a few most resource-intensive statements.What must you do to receive recommendations on eff...

（690）The database users regularly complain about the difficulty in performing transactions.On investigation,you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace,which caused the problem.You want to control the usage of the undo...

（689）View the Exhibit and examine the RMAN commands.Which statement describes the effect of a backup retention policy on the backup of a backup set?A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.B. The copies of the backup will be rep...

（688）Which two statements are true about the compressed backups in RMAN?(Choose two.)A. Compressed backups can only be taken on the tape drives.B. The binary compression creates some performance overhead during backup operation.C. The ZLIB compression algorithm can be used only if the C...

（687）Users are connected to a database instance that is using Automatic Storage Management(ASM).The DBA executes the command as follows to shut down the ASM instance:SQL>SHUTDOWN IMMEDIATE;What happens to the database instance?A. It shuts down long with the ASM instance.B. It is...

（686）You execute the following FLASHBACK TABLE command:FLASHBACK TABLE emp TO TIMESTAMP TO_TIMESTAMP('2008-01-04 11:00:00', 'YYYY-MM-DD HH24:MI:SS');Which two statements are correct?(Choose two.)A. The EMP table that was dropped by mistake earlier is rest...

（685）In your test database:-You are using Recovery Manager（RMAN）to perform incremental backups of your test database，-The test database is running in NOARCHIVELOG mode，-One of the data files is corrupted，-All online redo log files are lost because of a media failureWhich op...

（684）Your database is running in ARCHIVELOG mode.You have been taking backups of all the data files and control files regularly.You are informed that some important tables in the BILLING tablespace have been dropped on February 28,2007 at 10.30 AM and must be recovered.You decide to perform...

（683）Your production database it functional on the SHOST1 host.You are backing up the production database by using Recovery Manager(RMAN)with the recovery catalog.You want to replicate the production database to anther host,SHOST2,for testing new applications.After you ensured that the back...

（682）Identify the scenarios in which the RMAN CROSSCHECK command is useful.(Choose all thatapply.)A. To check that the obsolete backups are deleted from the repository records and from the disk.B. To update the RMAN repository if you delete archived redo logs with operating system commands....

（681）The environmental variable ORACLE_BASE is set.You want to check the diagnostic files created as part of the Automatic Diagnostic Repository(ADR).View the Exhibit and note the various parameters set in your database.What will be the location of the ADR base?A. It is set to ORACL...

（680）Which two operations are NOT performed by the DUPLICATE command in Recovery Manager(RMAN)while duplicating a running database?(Choose Two)A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recove...