ITPub博客

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_backup;)Which statement is true when the RMAN RUN block Is executed?A. The execution of the script fails...

78.You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?A. RMAN reads the block change ...

424.Which of these components correctly identify the unique value of the NAME column in theDBA_RESUMABLE view?A. Username, instance number, session IDB. Instance number, username, session IDC. Instance number, session ID, usernameD. Username, session ID, instance numberE. None of the aboveAns...

77.You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance.At the end of the day, while all three production database instances are running, you execute the followingcommand on the ASM instance :SQL> shutdown immediate;What is the result of executing this comm...

455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DROP attribute i...

123.What two statements are true regarding the recommendations received from the SQL Access Advisor?(Choose two.)A. It cannot generate recommendations that support multiple workload queries.B. It can recommend partitioning on tables provided that the workloads have some predicates and joinson th...

132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, abig file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Whichmethod would accomplish the task quickly and efficiently?A. parallel image copy backupB. backup with...

124.You are managing Oracle Database 11g with an ASM storage with high redundancy. The followingcommand was issued to drop the disks from the dga disk group after five hours:ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;Which statement is true in this scenario?A. It starts the ...

332.David managed to accidentally delete the datafiles for database called DSL. He called Heber andHeber tried to help but he managed to delete the control files of the database. Heber called Bill and Billsaved the day. They are using a recovery catalog for this database. What steps did Bill perfo...

130.Which are the prerequisites for performing flashback transactions on your database? (Choose all thatapply.)A. Undo retention guarantee for the database must be configured.B. Supplemental log must be enabled for the primary key.C. Supplemental log must be enabled.D. Execute permission on the...

96.Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positi...

703. Given below are RMAN commands to enable backup optimization and set the retention policy:The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.View the Exhibit to examine the operations performed by using RMAN. Which two statements are trueabout the ...

28.You have a range-partitioned table in your database. Each partition in the table contains the sales datafor a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer datamanipulations. The preferences for the table are set to their default...

224.You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL(NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESSTHAN(TO_DATE('1-1-2005', 'dd-mm-yyyy')), PA...

94.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What could havehelped you to correlate server sessions with channels?A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify ...

466.What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_MA. 1 is a monolingual sort.B. 2 is a monolingual sort.C. 1 is case insensitive.D. Both 1 and 2 are case insensitive.E. Case sensitivity is unknown.Answer: Alinguistic: 语法; ...

608.You are managing a 24*7 database. The backup strategy for the database is to performuser-managed backups.Identify two prerequisites to perform the backups. (Choose two.)A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tabl...

570.What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Transaction number-basedAnswer: ABCD参考：http://blog.csdn.net/leshami/article/details/7909887(Oracle 基于用户管理的不完全恢复)  &nbsp...

707. Because of a logical corruption in the EMPLOYES tables, you want to perform TablespacePoint-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, youqueried the TS_PITR_CHECK view and you realized that the table has a referential constraint withDEPARTMENTS th...

585.What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup groupAnswer: Aproprietary: 专有的