as12

QUESTION 51
Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

QUESTION 27
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

QUESTION 49
You perform a backup using the following BACKUP command:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?

QUESTION 73
Which of the following is not a configurable attribute for an individual disk group?

QUESTION 59
Which package provides API's for the SQL Tuning Advisor?

QUESTION 43
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

QUESTION 44
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?

QUESTION 50
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?

QUESTION 56
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

QUESTION 45
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?

QUESTION 53
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 that are pending for the DG1 disk group. Which statement should you issue?

QUESTION 38
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?

QUESTION 62
View exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?

QUESTION 31
Exhibit: View 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?

QUESTION 67
Exhibit #1
Exhibit #2
Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are
recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1
takesless time than the process in exhibit2. What is the reason for this?

QUESTION 57
The DB_BLOCK_CHECKING initialization parameter is set to OFF.
Which block checking would be performed

QUESTION 40
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

QUESTION 69
View exhibit # 1
View exhibit # 2

View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine theoutput of the query.
Which two statements describe the conclusions? (Choose two.)

QUESTION 30
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

QUESTION 46
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.)

QUESTION 58
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by
the activity. How would you achieve this?

QUESTION 36
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?

QUESTION 33
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

QUESTION 34
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?

QUESTION 71
After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command
from the
ASM instance:
Select group_number, count(*) from v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?

QUESTION 66
View exhibit
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?

QUESTION 72
What is the net effect of the following command?
alter diskgroup dgroup1 drop disk abc;

QUESTION 29
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.)

QUESTION 54
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:
View exhibit

QUESTION 65
View exhibit #1
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of
COUNTRY_ID is
"US."
View exhibit #2 to examine the commands and query plans. The optimizer can sense 8 rows instead
of 29
rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual
selectivity?

QUESTION 60
Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

QUESTION 35
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?

QUESTION 52
You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN { SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE; }
Which statement is true about the result?

QUESTION 64
View exhibit to examine the details for an incident. Which statement is true regarding the status of the
incident?

QUESTION 37
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.

QUESTION 70
ASM supports all but which of the following file types? (Choose all that apply.)

QUESTION 26
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support?(Choose all that apply.)

QUESTION 55
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;
View exhibit
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to
provide the required result?

QUESTION 41
View 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?

QUESTION 42
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

QUESTION 68
Exhibit
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?

QUESTION 28
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

QUESTION 48
Which dependent object will get invalidated even if it is not affected by the table redefinition?

QUESTION 75
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:
Put the tablespaces in backup mode.
Back up the datafiles for all tablespaces.
Take the tablespaces out of backup mode.
Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?

QUESTION 63
View exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

QUESTION 39
Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

QUESTION 61
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

QUESTION 47
You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

QUESTION 74
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

QUESTION 32
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 tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?