ITPub博客

（621）You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file,if it has already been backed up.(Choose two.)A. The data file backup is done with multiple channelsB. The data files is in the read-write mode after being backed up...

其它安装步骤与11G安装相同，可参考其它博文

（620）You are using the control file to maintain information about the database backups that are being performed by Recovery Manager(RMAN).Identify two scenarios is which you must have a recovery catalog.(Choose two.)A. To store the backup information of multiple databaseB. To restrict t...

（619）View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR?A. The text alert log file will be available in Diag TraceB. A copy alert log file will be kept in Diag Incident for every incident.C. The XML version of the alert log file will be ava...

（618）You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1='LOCATION=/disk1/arch'LOG_ARCHIVE_DEST_2='LOCATION=/disk2/arch'LOG_ARCHIVE_DEST_3='LOACTION=/disk3/arch'LOG_ARCHIVE_DEST_4='LOCATION=/disk4/arch MANDATORY'Identify the stat...

（617）A database instance is using an Automatic Storage Management(ASM)instance,which has a disk group,DGROUP1,created as follows:SQL>CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devi...

（616）The EMP table has some discrepancy in data entry with a particular employee ID.You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are cor...

（615）Before a Flashback Table operation,you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operation...

（614）Which three types of files can be automatically placed in the flash recovery area(fast recovery area in 11g Release 2)?(Choose three.)A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file(SPFILE)E. Recovery Manager(RMAN)backup piece...

（613）You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database ins...

（612）Examine the following command used to perform incremental level 0 backup:RMAN>BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking,after the incremental level 0 backup you issued the following command:SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/m...

（611）To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:SQL>ALTER TABLESPACE users BEGIN BACKUP;While copying the file to the backup destination a power outage caused the instance to teminate abnormally.Which s...

（610）Which of the following advisors is run in every maintenance window by the auto-task system?A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor答案：（D）解析：SQL Access Advisor是一个ADDM诊断顾问，提供额外的支持，找出潜在的修...

（609）Examine the following commands and their output:select ename, sal from emp where ename = 'JAMES'ENAME     SAL-----  ------JAMES    1050update emp set sal = sal + sal * ...

（608）You are managing a 24 * 7 database.The backup strategy for the database is to perform user-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....

（607）Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having active online redo log file...

（606）Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN(choose all that apply)A. Limiting the input/output(I/O)bandwidth consumptionB. Specifying the size of backup sets and backup piecesC. Specifying vendor-specific info...

（605）What two are the prerequisites for enabling Flashback Database?(Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT state...

（604）You realize that the control file is damaged in your production database.After restoring the control file from autobackup,what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in...

（603）While performing a regular check on your recovery catalog you realized that the catalog database is running out of space andyou do not have options to increase the space.However,you have another database where more space is available and you want to move your existing recovery catalog ...