ITPub博客

由于工作原因，时间比较紧张，将暂停一段时间的博文更新，节后将有更加精彩的博文分享给大家！

终于把Oracle 11G OCP所有题目的资料汇总完了。马上会整理到相应的文集中,方便大家浏览和阅读。大家如果对个别题目，还有疑问可以跟帖回复，我们再做进一步的整理。

（711）The following command is executed to shut down an Automatic Storage Management(ASM)instance:SQL>SHUTDOWN ABORT;Which two statements describe the consequences of the above command?(Choose two.)A. The disk groups are orderly dismounted.B. The ASM instance requires recovery when i...

（710）You executed the following commands in a database session:Which statement is true about the contents of the recycle bin in this situation?A. They remain unaffected.B. They are moved to flashback logs.C. They are moved to the undo tablespace.D. They are moved to a temporary t...

（709）A database has three online redo log groups with one member each.A redo log member with the status ACTICE is damages while the database is running.What is the first step you should take to solve this problem?A. Attempt to Issue a checkpoint.B. Restart the database using the RES...

（708）You executed the following query:select oldest_flashback_scn, oldest_flashback_time from v$flashback_database_log;Considering that all the redo logs are available,what information can you derive from the output of the preceding query?A. The time when...

（707）Because of a logical corruption in the EMPLOYES tables,you want to perform Tablespace Point-in-Time Recovery（TSPITR）to recover the table.Before you started the TSPITR process,you queried the TS_PITR_CHECK view and you realized that the table has a referential constraintwith DEPARTMEN...

（706）You execute the following command to set the redundancy retention policy in Recovery Manager(RMAN):RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Identify the statement that correctly describes the implications of this command.A. when there are already three backups,for the fourth...

（705）View Exhibit1 to examine the DATA disk group when all the disks are online.Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?A. Because the disk group is created with NORMAL redundancyB. Because the disk repair time attribute is set to a ...

（704）View the Exhibit and examine the data manipulation language(DML)operations that you performed on the NEWEMP table.Note that the first two updated are not listed by the Flashback Versions QueryWhat could be the reason?A. The first two updated were not explicitly committed.B. ...

（703）Given below are RMAN commands to enable backup optimization and set the retention policy:RMAN>CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN>CONFIGURE BACKUP OPTIMIZATION ON;RMAN>CONFIGURE RETENTION POLICY TO REDUNCANCY 2;The U...

（702）View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE).When you tried to start the database instance,you received the following error:SQL>startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing i...

（701）A user receives the following error while performing a large volume of inserts into a table:ERROR at line 1:ORA-01536: space quota exceeded for tablespace 'USERS'The issue is resolved by increasing the space quota on the USERS tablespace ...

（700）Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN?(Choose two.)A. It is a copy or a subset of the target database.B. It is opened in RESTRICT mode after a duplicating operation.C. It is created by using backups and archi...

（699）Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default temporary tablspace.A user issues a query on the ORDERS table and receives the following error:ERROR at line 1:...

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