ITPub博客

（527）What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?A.The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.B.The ASM rebalance operation will consume fewer resources and complete in...

（526）Which of the following is a benefit of ASM fast disk resync?A. Failed disks are taken offline immediately but are not dropped.B. Disk data is never lost.C. By default,the failed disk is not dropped from the disk group ever,protecting you from loss of that disk.D. The failed dis...

（525）What components are present in an ASM instance?(Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter file or spfile答案：（A、B、E）

（524）What are three benefits of using ASM?(Choose three.)A. Ease of disk administration and maintenanceB. Load balancing across physical disksC. Software RAID-1 data redundancy with double or triple mirrorsD. Automatic recovery of failed disks答案：（A、B、C）...

（523）The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements?(Choose all that apply.)A. Date formatB. Decimal characterC. Group separatorD. First day of the monthE. None of the aboveF. All of the above答案...

（522）The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?A. Languages for server messagesB. Day and month names and abbreviationsC. Symbols to represent a.m.,p.m.,AD,and BCD. Affirmative and negative response stri...

（521）You notice that a job in a chain has not completed on a nonconstrained RAC database.Which of these are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one...

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