ITPub博客

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...

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...

324.Your database is up and running and one of your three control files is accidentally erased. You startRMAN and run the following command:RESTORE CONTROLFILE FROM AUTOBACKUP;Which of the following statements is true? (Choose all that apply.)A. The command restores only the missing control file...

299.In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YESand the users who need to access the database as DBAs have been granted SYSDBA enterprise role inOracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with theSYSDB...

286.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo logfiles are stored on three locations. The Flash Recovery Area is one of the locations. The details are givenbelow:LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'DB_...

563.How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21Answer: Clog_archive_dest_n, 这里是N，只能是1到10。所以，只能支持10个不同的archive-log destinationLOG_ARCHIVE_DEST_nwhere:n is an integer from 1 to 10参考：h...

413.Which of the following Oracle features is enabled by setting a nonzero value for theMEMORY_TARGET initialization parameter?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Manual SGA Memory Management...