The safer , easier way t
o help you pass any IT exams.
2
/
8
1.What are the prerequisites for performing flashback transa
ctions? (Choose all that apply)
A.
Supp
lemental log must be enabled
B.
Supplemental log must be
enabled for the primary key
C.
Undo retention guarantee for the
database must be configured
D.
EXECUTE
permission on the DBMS_FLASHBACK pack
age must be granted to the user
Answer:
ABD
2.
Your product
ion 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, th
e database fails to open displaying the
message that the data file belonging to the users tablespace are corrupted.
The steps to recover the
damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the
data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files
.?
A.2, 4, 3
B.1, 4, 3, 2
C.2, 5, 4, 3, 6
D.5, 2, 4, 3, 6
E.1, 5, 4, 3, 6, 2
Answer:
E
3.
You want
to perform an RMAN backup of database as a copy. Which two factors will you consider while
performing the
backup operation? (Choose two).
A.
The backup as copy can only be taken
to disk
B.
The backup as co
py can only be taken to tape
C.
Backup can be performe
d only w
hen the instance is shutdown
D.
Backup will constitute all used an
d unused blocks in the database
Answer:
AD
4.
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You
executed the following commands to con
figure the settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk
FORMAT '/home/oracle/disk2/%U';
Yo
u issue the following RMAN command to backup the database:
RMAN> RUN
2> {
3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk;
4> BACKUP DATABASE;
