The safer , easier way to help you pass any IT exams.
D. The archived redo log files are still maintained because the file names are unique. Answer: D
65.An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files? A. TEST_TBS is a small file tablespace. B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace. D. TEST_TBS is a dictionary-managed tablespace. Answer: D
66.Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
A. set SHARED_POOL_SIZE to zero B. set STATISTICS_LEVEL to BASIC C. set SGA_TARGET to a non-zero value D. set DB_CACHE_SIZE to a non-zero value E. set STATISTICS_LEVEL to TYPICAL or ALL Answer: AC
67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.) A. fixed tables B. heap tables C. external tables D. temporary tables
E. Index-Organized Tables (IOTs) Answer: BE
68.You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct? A. It will create the tablespace TEMP1 in group G1. B. It will create the tablespace TEMP1 in group G3. C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group. Answer: C
69.The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply) A.ARCHIVELOG mode must be enabled
B.Row Movement must be enabled for the table C.FLASHBACK must be set to ON for the database
D.The UNDO_MANAGEMENT parameter must be set to AUTO E.The UNDO_RETENTION parameter must be set appropriately 16 / 193
The safer , easier way to help you pass any IT exams.
Answer: DE
70.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?
A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation. Answer: C
71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your
database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do? A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
Answer: B
72.You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to _. A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space Answer: A
73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
A. You are backing up to tape and your tape device performs its own compression. B. You are making image copies, and you have not enabled tablespace compression.
C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage. Answer: CDE
74.Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.) A. Define the POWER option while adding or removing the disks.
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT. C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
17 / 193
The safer , easier way to help you pass any IT exams.
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES. Answer: AB
75.View the Exhibit. As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?
A. CKPT B. SMON C. MMON D. DBWR Answer: C
76.Identify three key features of ASM. (Choose three.) A. file striping
B. allocation unit mirroring C. automatic disk rebalancing D. automatic file size increment E. automatic undo management Answer: ABC
77.You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate;
What is the result of executing this command?
A. The ASM instance is shut down, but the other instances are still running. B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode. Answer: B
18 / 193
The safer , easier way to help you pass any IT exams.
78.You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command:
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?
A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup. B. RMAN reads the block change tracking file when it performs both incremental backups.
C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup. D. RMAN does not read the block change tracking file when it performs either incremental backup. Answer: C
79.You executed the following command: Which statement regarding the above command is correct? RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup. C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails. Answer: C
80.Which two statements regarding a SQL profile are true? (Choose two.) A. It is built by Automatic Tuning Optimizer.
B. It cannot be stored persistently in the data dictionary. C. It can be used by the query optimizer automatically.
D. It can be created manually by using the CREATE PROFILE command. Answer: AC
81.Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.) A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated. Answer: DE
82.Identify the three predefined server-generated alerts. (Choose three.) A. Drop User
B. Tablespace Space Usage
C. Resumable Session Suspended D. Recovery Area Low On Free Space E. SYSTEM Tablespace Size Increment Answer: BCD
19 / 193
The safer , easier way to help you pass any IT exams.
83.Which three actions are required to configure the Flashback Database? (Choose three.) A. set Flash Recovery Area B. enable Flashback logging
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode E. start the database in the NOARCHIVELOG mode Answer: ABD
84.View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump Answer: A
85.You executed the following command to drop a user: DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.) A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command. Answer: BC
86.Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
20 / 193