ITPub博客

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

（500）You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE'/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAULT STORAGE(ENCRYPT);T...

（499）Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository(ADR)?A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.B. The incident files and dumps are not retained in the ADR for the...

（498）The database Is configured in ARCHIVELOG mode.The database needs to be up 24 X 7.You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task,you issued the following command:SQL>ALTER TABLESPACE hi_data BEGIN BACKUP;Which two statemen...

（497）You are managing the APPPROD database as a DBA.You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:RMAN>CONNECT target sys/sys@APPPRODRMAN>DUPLICATE TARGET DAT...

（496）Which two statements are true regarding an Automatic Storage Management(ASM) instance?(Choose two.)A. An ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM i...

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

（494）Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or     PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate ...

（493）Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)A. It detects changes in SQL execution plans.B. It produces results that can be used to create the SQL plan baseline.C. The importance of SQL statements is based on the size of the...

（492）You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database.As a part of the upgrade process,you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?A. It must be executed from the Oracle Da...

（491）Examine the exhibit to view the parameters set in your parameter file.(Click the Exhibit(s)button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?A.120MB.320MC.480MD.600M答案：（D）解析：题目不完整...

（490）View the Exhibit.Examine the following command that is executed for the TRANSPORT table in the SH schema:SQL>SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id,cust_state_province)') FROM dual;Which statement describes the significance of this command?...