ITPub博客

（150）You have enabled backup optimization in RMAN.You issue the following RMAN command to configure a redundancy-based retention policy:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Which statement is true?A. The command fails because you cannot configure a redundancy-based retention polic...

（149）You perform a backup using the following BACKUP command:RMAN>BACKUP AS COMPRESSED BACKUPSET DATABASE;Which statement is true of this command?A. A different procedure is required to restore a database from compressed backupsB. The AS COMPRESSED clause of the BACKUP command provi...

（148）Which dependent object will get invalidated even if it is not affected by the table redefinition?A. packagesB. triggersC. synonymsD. views

（147）You installed Oracle Database 11g afresh.Which statements are true regarding the default audit settings in this database?(Choose all that apply.)A. The audit trail is stored in an operating system file.B. Auditing is disabled for all privileges.C. The audit trail is stored in t...

（146）You want to take the backup of the USERS tablespace.It has a single data file of 900 MB.You have tape drives of 300 MB each.The SBT channel is configured for the RMAN.To accomplish the backup, you issued the following RMAN command:RMAN>BACKUP SECTION SIZE 300M TABLESPACE users;...

（145）You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.The SALES table has a materialized view,materialized log,indexes,referential integrity constraint,and triggers with the PRECEDES clause existing on it.What act...

（144）In your database,the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.You issued the following command:SQL>SELECT/*+RESULT_CACHE*/ sale_category,sum(sale_amt) FROM sales GROUP BY sale_category;Where would the result of this query be stored?...

（143）Which two are the prerequisites to enable Flashback Data Archive?(Choose two.)A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created...

（142）In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)A. when one or more file directory paths are accidentally deleted from an ASM disk groupB. when one of the disks in a disk group is accidentaly unpluggedC. when t...

（141）Exhibit:View the Exhibit for some of the current parameter settings.A user logs in to the HR schema and issues the following commands:SQL>CREATE TABLE emp(empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));SQL>INSERT INTO emp(empno,ename)VALUES(1,'JAMES');At this moment,a...

（140）Which two statements are true regarding Health Monitor checks in Oracle Database 11g?(Choose two.)A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.B. Health Monitor checks can be used to verify the integrity of ...

（139）Which two prerequisites are needed for performing workload capture and replay?(Choose two.)A. Close all sessions performing queries using database links.B. running the database in shared server modeC. The database on which the workload is replayed has to be a restore of the origina...

（138）You are working on the APPDB database as a DBA.The database has a default Flashback Data Archive DFLA1 created on it.You issued the following command to drop the Flashback Archive FLA1:DROP FLASHBACK ARCHIVE fla1;What is the effect of this command?A. The Flashback Archive FLA1 ...

（137）Your company wants to upgrade the current production database to the RAC environment.To perform testing before migrating to the RAC environment,you performed the workload capture on the production database to record the peak workload.You set up the test RAC database and want to replay ...

（136）You issued the following command to mount the DATA disk group in restricted mode:ALTER DISKGROUP data MOUNT RESTRICT;What is the implication of this command?A. The client RDBMS instance can access the file as a read-only file.B. A new disk cannot be added to a disk group.C....

（135）The ADMIN_EMP table has columns EMPNO,ENAME,DEPTNO,and SAL.It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column.You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tables...

（134）You are managing an Oracle Database 11g database.You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB.You have tape drives of 300 MB each.To accomplish the backup,you issued the following RMAN command:RMAN>BACKUP SECTION SIZE 30...

（133）You performed the RMAN database backup with the KEEP option.Which two statements are true regarding this backup?(Choose two.)A. The backup contains data files,the server parameter file,and the control file even if the control file autobackup is disabled.B. The KEEP option overrides...

（132）You are managing an Oracle Database 11g database.You want to take the backup of MULT_DATA,a big file tablespace of size 100 TB on tape drive,but you have tape drives of only 10 GB each.Which method would accomplish the task quickly and efficiently?A. parallel image copy backupB...