The safer , easier way to help you pass any IT exams.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C. All historical data is purged and the new flashback data archives are maintained for three years. D. All historical data older than three years is purged from the flashback archive FLA1. Answer: D
129.You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)
A. The au_size disk group attribute determines the size of allocation units in the disk group. B. The allocation unit size may vary but the extent size is fixed.
C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
D. Extent management is completely automated.
Answer: AD
130.Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
A. Undo retention guarantee for the database must be configured. B. Supplemental log must be enabled for the primary key. C. Supplemental log must be enabled.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user. Answer: BCD 131.Exhibit:
View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign? A. 1440 MB B. 90 MB C. 362 MB D. 272 MB Answer: C
132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a
31 / 193
The safer , easier way to help you pass any IT exams.
big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently? A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channe D. intrafile parallel backup Answer: D
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 the configured retention policy. C. The backup contains only data files and archived redo log files. D. The KEEP option is an attribute of an individual backup piece. Answer: AB
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 300M TABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using the above command?
A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1. B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0. C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3. D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB. Answer: D
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 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?
A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
C. The materialized view, materialized log, and the index should be dropped and re-created after the
32 / 193
The safer , easier way to help you pass any IT exams.
online table redefinition is complete.
D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete. Answer: A
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. A disk in a disk group can be taken offline.
D. The client RDBMS instance cannot access the files in the disk group. Answer: D
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 the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode. 3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started. 5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine. A. 1, 4, 5, 3 (2 is not required.) B. 1, 4, 3, 5 (2 is not required.) C. 1, 2, 4, 5 (3 is not required.) D. 2, 1, 5, 3, 4 E. 1, 2, 4, 5, 3 Answer: A
138.You are working on the APPDB database as a DB A. 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 is dropped only if it is empty. B. The tablespace having Flashback Archive is dropped.
C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D. The Flashback Data Archive and historical data are dropped. Answer: D
139.Which two prerequisites are needed for performing workload capture and replay? (Choose two.)
33 / 193
The safer , easier way to help you pass any IT exams.
A. Close all sessions performing queries using database links. B. running the database in shared server mode
C. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
D. setting up the directory to capture the workload Answer: CD
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 database files and report failures if these files are inaccessible, corrupt or inconsistent.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks are always initiated manually when there is some critical error. Answer: AB 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 second user also logs in to the HR schema and issues the following command: SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2); What happens in the above scenario?
A. The second user's session immediately produces the resource busy error. B. The second user's command executes successfully.
C. The second user's session waits for a time period before producing the resource busy error. D. A deadlock is created. Answer: C
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 group B. when one of the disks in a disk group is accidentaly unplugged C. when the data file on an ASM disk group gets corrupted D. when one or more disks in an ASM disk group are lost Answer: AD
34 / 193
The safer , easier way to help you pass any IT exams.
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 must be managed with Automatic Segment Space Management (ASSM). Answer: BD
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? A. database buffer cache B. shared pool C. PGA
D. large pool Answer: B
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 action is required for dependent objects when you perform online table redefinition?
A. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process. C. Referential integrity constraints must be manually enabled after the online table redefinition process. D. The materialized log should be dropped before the online table redefinition process. Answer: A
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;
Which two statements are true regarding the execution of the above command? (Choose two.) A. The RMAN parallelizes the backup although the parallelism is not set for a channel. B. The backup piece size will be limited to 300 MB.
C. The operation is accomplished using the default channel available.
D. Three channels for the tape drive must be configured by setting the parallelism to three. Answer: BC
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 the database. D. Auditing is enabled for all privileges.
E. Auditing is enabled for certain privileges related to database security. Answer: CE
35 / 193