ITPub博客

（93）You are using flat files as the data source for one of your data warehousing applications.To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the dat...

（92）You executed the following commands in an RMAN session for your database instance that has failures:RMAN> LIST FAILURE;After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE;But there are new failures recorded in the Automatic Diagnostic Reposi...

（91）View the Exhibit to examine the error that occurred during the database startup.You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:RMAN>REPAIR  FAILURE;Which statement describes the consequence of this ...

（90）Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)A.Recover from failures in the RAC environment.B.Diagnose and repair a data file corruption online.C.Diagnose and repair a data file corruption offline.D.Diagnose and repair failures on a sta...

（89）Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A.failure when no standby database is configuredB.failure because a data file is renamed accidentallyC. failure that requires no archive logs to be applied for recoveryD. f...

（88）Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A.The database files are corrupted when the database is open.B.The user has dropped an important table that needs to be recovered.C.The archived redo log files are missing for which the bac...

（87）You are managing an Oracle Database 11g database running in ARCHIVELOG mode.The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00...

（86）View the Exhibit to examine the output for the CROSSCHECK BACKUP command.Which statement is true about the output of the command?A. The backup piece is expired as the new backup is available.B. The backup piece is expired because the operating-system file was not found.C. The bac...

（85）You want to configure and schedule offline database backups to run automatically.Which tool or utility would you use to achieve this?A. the XML scriptB. the PL/SQL scriptC. the DBMS_SCHEDULER packageD. Enterprise Manager to schedule the backup答案：（D）...

（84）Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)A.data filesB.control filesC.parameter fileD.online redo log filesE.server parameter file答案：（B、E）...

（83）You are using Enterprise Manager to schedule backups for your database.Which type of script would be generated by the backup scheduler?A. XML scriptB. PL/SQL scriptC. Operating system scriptD. Recovery Manager (RMAN) script答案：（D）

（82）You are managing an Oracle Database 11g database with the following backup strategy:1)   On Sunday, an incremental level 0 tape backup is performed.2)   Monday through Saturday, a cumulative incremental level 1 tape backup is performed.Which two statements are tr...

（81）You are managing an Oracle Database 11g database with this backup strategy:Every Sunday night, level 0 backup is performed.On Monday night and subsequent days, level 1 incremental backup is performed.The backups are not cumulative incremental. Which statement about Monday's backup i...

（80）You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.Which two statements are true about differential incremental backups? (Choose two.)A. The backup performed on Sundays contains all the blocks that have ever b...

（79）You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.Which two options do you have for performing user-managed backups? (Choose two.)A. You can perform consistent backups only.B. You can perform a complet...

（78）You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.Which three statements are true about these backups? (Choose three.)A. The backups would be consistent.B. The backups would be inconsistent.C. The back...

（77）You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP*ERROR at line 1:ORA-01123: cannot start online backup...

（76）Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?A. The backup will consist of used data blocks only.B. The database must be shut down to accomplish the backup.C. The backup can be accomplished without shutting down the databa...

（75）Your test database is configured to run in NOARCHIVELOG mode.One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.What would you do to recover the data file?A. Take the USER...

（74）The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'DB_RECOVERY_FILE_DEST = '/u01/oradata'DB_RECOV...