ITPub博客

71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on yourdatabase. Your database is facing a series of interrelated problems over a period of two hours. You needto ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?A. C...

479.Which two statements about workload capture and replay operations are true? (Choose two.)A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean statefor worklo...

351.What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafilesB. Size of the tempfilesC. Date of last backup for datafiles and tempfilesD. Filenames for each datafileE. Checkpoint SCN associated with the last RMAN backupAnswer: CE从输出来看...

544.Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain thatthey dont want you to shut down the database to perform the backup. What options are available to you?A. Put the database in hot backup mode and perform an online backup, including backing up the archi...

601.You need to perform a block media recovery on the tools01.dbf data file in the SALES database byusing Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? (Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN...

338.You run the following commands:RMAN> list expired backup;RMAN> delete expired backup;What will happen to the backup set pieces associated with the backups that appear in the list expiredbackup command?A. They will be renamed.B. Nothing will happen to them. The backup set pieces do not exis...

426.The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_name "Source", t.platform_name"Compatible Targets", endian_formatfrom v$transportable_platform t, v$database dwhere t.endian_format = (select ...

253.You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL planbaseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept theprofile.Which statement is true when you accept the suggested SQL profile?A. The tuned plan is not...

64.You performed an incomplete recovery and opened the database with the RESETLOGS option. TheLOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding thearchived redo log files, created in an earlier incarnation of the database, is true?A. The archived redo log files ...

197.Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user;E. report obsolete;Answer: D注意：report need backup days 3意思是列出恢复时需要3天归档日志进行恢复的数据文件。而不是3天内没有做过备份的数据文件。RMAN> report nee...

373.Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Flashback DatabaseE. Transaction ProcessingF. Recycle BinAnswer: ACE注意：flashback table与flashback dropflashback table需要undo, 但是flas...

310.The RVPC user can do which of the following? (Choose all that apply.)A. Register databases if granted the register database privilegeB. See all databases in the recovery-catalog schemaC. See all database-related metadata in the recovery catalog if they are granted access to that databaseD. U...

519.You notice that a long-running transaction is suspended due to a space constraint, and there is noAFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is justabout to reach the RESUMABLE_TIMEOUT value.Which of these actions is appropriate?A. Abort t...

406.Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor, with before and after metricsC. Graphs showing the actual performance improvement m...

662.To enable faster incremental backups, you enabled block change tracking for the database. Whichtwo statements are true about the block change tracking file? (Choose two.)A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first...

495.Which statement is true regarding the VALIDATE DATABASE command?A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database.C. It checks the database for both intrablock and interblock corruptions.D. It checks for only...

Rebalancing actASM ensures that file extents are evenly distributed across all disks in a disk group. This is true for the initial file creation and for file resize operations. That means we should always have abalanced space distribu...

659.Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DROP DISK misc2;C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E. ALTER DISKGROUP dgroupA ADD DISK '/...

63.Which method would you use to undo the changes made by a particular transaction without affectingthe changes made by other transactions?A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determin...

440.Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTEAnswer: C考察的是dbms_scheduler创建作业相关