ITPub博客

（520）Which of the following are not disabled by default?A. JobsB. ChainsC. WindowsD. Window groupsE. Schedule答案：（E）

（519）You notice that a long-running transaction is suspended due to a space constraint,and there is no AFTER SUSPEND triggered event addressing the issue.You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value.Which of these actions is appropriate?...

（518）The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?A. ...

（517）Which of the following are true concerning block media recovery?(Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in archive logs is encountered,RMAN will search forward for newer versions of the blocks that are not corrupt.C. Uncorrupted blocks from ...

（516）In a Database Replay workload capture,what client request information is gathered?(Choose all that apply.)A. SQL textB. Shared server requests(Oracle MTS)C. Bind variable valuesD. Information about transactionsE. Remote DESCRIBE and COMMIT operations答案：（A、C、D）...

（515）A developer calls and reports that he accidentally dropped an important lookup table from a production database.He needs the table to be recovered.What action would you take?A. Initiate an incomplete recovery operation using RMAN.B. Copy the table from a development database....

（514）A user performs an update on a table.Shortly after committing the transaction,they realize that they had an error in their WHERE clause causing the wrong rows to be updated.Which Flashback option would allow you to undo this transaction and restore the table to its previous state?A...

（513）What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the above答案：（A）

（512）Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule?(Choose two)A. A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as p...

（511）You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:LOG_ARCHIVE_DEST 1='LOCATION=/disk1/arch MANDATORY'LOG_ARCHIEVE_DEST 2='LOCATION=/disk2/arch'LOG_ARCHIVK_DEST_3='LOCATION=/diSk3/arch'LOG_ARCH...

（510）You executed the following command in Recovery Manager(RMAN):RMAN>REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB. a list of files requiring more than 3 days of archive logs to applyC. a list of files ...

（509）Which of the following cannot be used as input to the SQL Tuning Advisor?(Choose all that apply.)A. A single SQL statement provided by a userB. An existing SQL Tuning Set(STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as usin...

（508）You want to set the following Initialization parameters for your database InstanceLOG_ARCHIVE_DEBT_1= 'LOCATION=/disk1/arch'LOG_ARCHIVE_DBST_2= 'LOCATION=/disk2/arch'LOC_ARCHIVB DBST_3= 'LOCATION=/disk3/arch'LOG_ARCHIVE DBST_= 'LOCATION=/disk3/arch'Identify the statement th...

（507）Your database is running In ARCHIVELOG mode.One of the data files,USBRDATAOI.DBF,in the users tablespace is damaged and you need to recover the file until the point of failure.The backup for the data file is available.Which three files would be used in the user-managed recovery pro...

（506）Examine the following ALTER command;SQL>ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops within the disk group.B. It adds previously dropped disks back into the disk group.C. It restores disks that are being droppe...

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

（504）View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance.To repair the failure,you executed the following as the first command in the RMAN session:RMAN>REPAIR FAILURE;Which statement describes the consequence of the comman...

（503）Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager(RMAN).(Choose two.)A. You can use RMAN stored scripts.B. Recovery is faster if data is stored in catalog in addition to the control file.C. You can store backup I...

（502）A database is running In ARCHIVELOG mode.It has two online redo log groups and each group has one member.A LGWR Input/output(I/O) fills due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash.The steps to recov...

（501）Note the output of the following query;SQL>SELECT flashback_archieve_name,status FROM dba_flashback_archieve;FLASHBACK_ARCHIEVE_NAME  STATUS-------------------------------  --------FLA1You executed the following command to enable Flashback Data Archive on the EXCH...