ITPub博客

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创建作业相关

461.The NLS_SORT parameter sets the default sort method for which of the followingoperations?(Choose all that apply.)A. WHERE clauseB. ORDER BY clauseC. BETWEEN clauseD. NLSSORT functionE. NLS_SORT functionAnswer: ADThe NLS_SORT parameter defines the default sort method (binary or linguisti...

273.Which statements are true regarding the system-defined moving window baseline in OracleDatabase 11g? (Choose all that apply.)A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default wit...

505.You configured the default backup device type as disk for RMAN backups. In your database, becauseof business requirements, you have to take a simultaneous duplicate backup of the data files when theRMAN BACKUP command is used.What must you set using the RMAN CONFIGURE command to achieve this?...

27.You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup relatedfiles in your database.After regular monitoring of space usage in the Mash recovery area. You realize that the flash recoveryarea is (jetting filled up very fast and it is running out of space. Y...