ITPub博客

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

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