ITPub博客

（156）What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly,but can ...

（155）Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company.For this,he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executin...

（154）A database is running in ARCHIVELOG mode and regular backups are performed.A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?A. Drop the affected tablespace,re-create the tablespace,restore the...

（153）You are managing an ASM instance.You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops ...

(152)You are performing incomplete recovery using RMAN.You execute the following RUN block:RUN{  SET UNTIL SCN 1107600;  RESTORE DATABASE;  RECOVER DATABASE;}Which sta...

（151）Which statements about the MEMORY_TARGET initialization parameter are true?(Choose all that apply.)A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET,if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_T...

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