That's all folks !!
This is for all my GNU friends...
It's we on the tape !!!!
There are some
parts, are some dumps that I've collected from Internet. I've commented some parts.
Any correction is welcome.
Kadu.
MCP, MCDBA, MCSE, AIX
CP, and now OCP.
PART I
------
1 You perform an incomplete recovery using RMAN. You write the
following script:
RUN{
SET UNTIL
TIME =
ВЎВҐyyyy-nm-dd:hh:mi:ssВЎВ¦;
RESTORE DATABASE;
RECOVER DATABASE;
SQL ВЎВ§alter database open resetlogsВЎВЁ;}
Which command
is missing?
A. RESYNC CATALOG;
B. RELEASE CHANNEL;
C. ALLOCATE CHANNEL cname TYPE DISK;
D. SET LIMIT CHANNEL cname KBYTESS 4194304
ANSWER: C
You need to allocate a channel before any backup or recovery operation.
2 A media management layer is always used when
Recovery Manager
A. reads or writes to tapes
B. performs media recovery
C. reads or writes to disk files
D. reads or writes
through a channel
ANSWER: A
MML is used to interact with the third party library tape drivers, and so on.
3 Which two records does the
Recovery Manager RESYC CATALOG
command
update? (Choose two)
A. alert log records
B. log switch records
C. rollback segment
records
D. archived log copy records
ANSWER: B,D
The RC may update the records that are recorded in the control file. Alert Log and RBS
are not recorded in CFILE.
4 You have just created a script in Recovery Manager. After
noticing
an error in the script, you decide to
recreate it. Which command
replaces
the stored script in the recovery catalog?
A. REPLACE SCRIPT
B. REPLACE_SCRIPT
C. RECREATE
SCRIPT
D. RECREATE_SCRIPT
ANSWER: A
Easy.
5. Your recovery catalog user account is RECMAN with a password
of
RECMAN. Which
command will connect to Recovery Manager through the user
SMITH with a password of DNAGER if the database containing the recovery
catalog is
identified by the TNS ailas.RCVCAT?
A. $ rman smith/danger rcvcat recman/recman@RCVCAT
B. $ target smith/danger rcvcat
recman/recman@RCVCAT
C. $ rman target smith/danger rcvcat recman/recman@RCVCAT
D. $ rman rcvcat recman/recman@RCVCAT target (smith/danger)
ANSWER: C
The correct syntax would be "rman target smith/danger catalog recman/recman@rcvcat"
DBMS_RCVCAT and DBMS_RCVMAN are internal
packages of Oracle.
6. When two or more databases are backed up using RMAN, is it
appropriate to use each database as the otherВЎВ¦s recovery
catalog? Why?
A. Yes. The catalog is a recognized procedure
B. No. There would be too many dependencies
C. Yes, but only if the
database are run in NOARCHIVELOG
mode
D. No. A database that contains a catalog cannot be target
database
ANSWER: A
ItВґs
recommended that the recovery catalog resides on a different machine than the target
7. What is the last step when setting up a recovery
catalog?
A. create a catalog schema owner
B. run the CREATE CATALOG command
C. run the REGISTER DATABASE command
D.
resynchronise the database with the catalog
ANSWER: C
The order may be: create a schema owner, create a tablespace for the schema, grant
privileges
( recovery_catalog_owner, connect and resource ), connect to RMAN, create the catalog,
and register all the databases that RMAN will
backup.
There is no need to resync the catalog in the creation time. Resync is used for changes in the structure
of the database, such as ass a
tablespace.
8. You are configuring a database for ARCHIVELOG mode. Which
two
initialization parameters should you use? (Choose two)
A. LOG_ARCHIVE_SIZE
B. ARCHIVELOG_MODE
C. LOG_ARCHIVE_DEST
D. LOG_ARCHIVE_FORMAT
E. LOG_ARCHIVE_INTERVAL
ANSWER:
C,D
A,B and E don't exists.
9. Your database is configured in ARCHIVELOG mode. Which
three
types of backups can be performed? (Choose
Three)
A. Opened database backups.
B. Operating system backups when the database is closed.
C. Online control file backups using the
ALTER CONTROLFILE
BACKUP
command.
D. Online tablespace backups using the ALTER DATABASE BACKUP
CONTROLFILE command.
E. Online control
file backups the ALTER DATABASE BACKUP
CONTROLFILE command.
ANSWER: A,B, E. Opened backups ( hot ), operating system ( close ), and online
controlfile backup.
C is wrong because the syntax is ALTER DATABASE BACKUP CONTROLFILE, and not ALTER CONTROLFILE.
Online Tablespaces are hot
backups, and are made with begin backup and end backup.
10. When configuring a database in ARCHIVELOG mode and
enabling
automatic
archiving, the database must be shut down and opened in the
MOUNT
stage. Which three options can be used to do this? (Choose Three)
A.
STARTUP FORCE MOUNT
B. STARTUP TRANSACTIONAL MOUNT
C. SHUTDOWN IMMEDIATE AND STARTUP
D. SHUTDOWN ABORT AND STARTUP MOUNT
E. SHUTDOWN
NORMAL AND STARTUP MOUNT
F. SHUTDOWN IMMEDIATE AND STARTUP MOUNT
G. G. SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT
ANSWER: E,F,G.
Shutdown the database with any option except ABORT, mount the database, and execute
ALTER DATABASE ARCHIVELOG.
11. Which two tasks can a DBA
perform using the export/import
facility? (Choose two)
A. Examine log files.
B. Archive historical data.
C. Recreate the control
file.
D. Transport tablespaces between databases.
E. Make a logical backup of the rollback segment tablespace.
ANSWER: B,D.
Obvious.
12. What is the difference between using NOLOGGING operations in a
single
database environment and a standby database
environment?
A. NOLOGGING operations are not allowed when using a
standby
database.
B. The affected data file needs to be copied
from the
primary to
the standby server.
C. NOLOGGING operations can be used on the standby
database,
but not on the primary database.
D. The standby database becomes unavailable after a
NOLOGGING
operation has been used on the primary database.
ANSWER: B
What to do?
Backup all datafiles that are part of the nologging operations in the primary server. Archive the current
log file. Take offline this files in the
standby server, drop the tablespace, and transfer the backup and the archived
logs to the standby srv. Perform recovery of the stdby
srv.
13. When creating a standby database, which files must be
transferred to the standby server?
A. The database backup and the
online redo-log files.
B. The database backup and the archived redo-log files.
C. The standby control file, the database backup, and the
online
redo-log files.
D. The standby control file, the database backup, and the
archived redo-log files.
ANSWER: D
Remember to
archive the current redo log in the primary database.
14. In which mode is ВЎВҐClosed database backupsВЎВ¦ the only
backup
option
available?
A. READ ONLY mode
B. ARCHIVELOG mode
C. READ WRITE mode
D. NOARCHIVELOG mode
ANSWER: D
In archivelog mode the
closed db backup is the only option.
PART II
-------
1. What's incompleted recovery (choose 3)?
- Time-based
- cancel-based
-
change-based
- tablespace recovery
ANSWER: A,B,C.
Tbs recovery is a completed recovery.
2. LGWR will hang if the online redo logs were
filled faster
than the archiving process.
- True
- False
ANSWER: A
LGWR will wait for rewrite the redo log file if the archiver had not
completed the archiving.
3. What can be recovered while others are still run? (choose 2)
- data tablespace
- index tablespace
- system
tablespace
ANSWER: A,B
If system tablespace goes down, bye, bye, Recover is needed.
4. What's completed recovery?
- Time-based
-
cancel-based
- change-based
- tablespace recovery
ANSWER: D
See question 1.
5. When should you backup control file? after you do
-
alter tablespace add datafile ...
- alter system archive log all
ANSWER: A
Backup controlfile after each structure alteration in the
database.
6. When should you backup control file? after you do
- alter database drop logfile ...
ANSWER: A
As 5.
7. When should you
backup control file? after you do
- alter database rename file ...
- alter system archive log all
ANSWER: A
As 5.
8. What's the
disadvantage of NOARCHIVELOG
- lost transactions must be re-entered
- increase space utilization
ANSWER: A
9. in which state you can re-
create control file
- nomount
- mount
- open
ANSWER: A
In the mount stage the controlfile was read.
10. You import a full exported
file to a database and than
apply all archived log files can do a completed recovery
- true
- fales
ANSWER: B
Import/Export are
completely different from backup ( hot/cold/Rman ).
11. The characteristics of direct path export (choose 2)
- does not compete recource with
other users
- the buffer size has no impact
ANSWER: A,B
???
12. rolling forward will
- apply all entries in redo log file
- apply only
commited entries in redo log file
ANSWER: A
Will apply commited and uncommited entries, and the rollback phase will rollback the uncommited
entries.
13. alter tablespace ... begin backup
will backup all of the data files in that tablespace
- true
- false
ANSWER: B
After
this, you need to copy all the datafiles of the database with a S.O, utility ( cp, copy , shazam, etc ).
14. What's the characteristics of
direct path export
- compete recource with other users
- direct retrive blocks to DB buffer cache
- use a optimized "select * from table"
statement
ANSWER: B
C is wrong because the export read the blocks directly from the disk, not parsing the rows.
And about A ? IВґm not sure,
but all operations in the server compete resources.
15. The company's data is highly volatile. You should
- backup more often
- backup
less often
- no backup needed
ANSWER: A.
Remeber to use archivelog.
16. ARCH process will automatic started when you run
alter
database archivelog;
- true
- false
ANSWER: B
Use the init.ora parameter LOG_ARCHIVE_START = true.
17. when a data file corrupted, you
want to minimize the
down time. you run
startup mount;
alter database datafile ... offline;
what should you do next?
- restore the
corrupted data file
- alter database open
- recover data file
ANSWER: B ( supposed to be in archivelog )
Open the database with the
corrupted datafile offline, and let the users use the database ( with the exception of this tbs ).
Restore the data file ( file os ), and recover
the datafile.
18. where is the path of all control files stored?
- control file
- init.ora file
- log file
ANSWER: B
Parameter
Control_files in the init.ora
19. after you activate a standby database. what should you do next?
- recover the primary database
- create a
new standby database
ANSWER: A
Depends. If the cause of the activation was failure on the primary database ( most cases ), is A. This is the
role of the
stand by server, but the question is confused ( at least for me ).
20. why Oracle recover instance faster?
- uncommited
transactions will not be roll back immediately
ANSWER: A
Smon will roll back as needed.
21. To do a completed recovery, the database must
be in which mode
- ARCHIVELOG
- NOARCHIVELOG
ANSWER: A
See: complete recovery is different from complete restore.
22. incompeted
recovery must restore
- damaged files
- all data files in the tablespace
- all data files
ANSWER: A.
23. after incompleted recovery,
you need open database
- RESETLOGS
- NORESETLOGS
ANSWER: A
24. change a database to archive log mode must be in
- mount
- nomount
- open
ANSWER: A
25. what privilege you must have to change database to
archive log mode
- alter system
- alter database
ANSWER: B
? I really don't know, because all times I used a dba account.
26. which recovery will recover the database to a time in
the
past? (choose 3)
- Time-based
- cancel-based
- change-based
- datafile recovery
ANSWER: A,B,C
As 1.
27. what's the result of
alter database backup controlfile to trace;
- a copy of control file
- generate a editable script file
ANSWER: B
28. if a backgroud
process has an error, where the trace file
will be
- BACKGROUND_DUMP_DEST
- USER_DUMP_DEST
ANSWER: A
29. import the full exported
file and apply all the archive logs
will recover the database to the point of failure
- true
- false
ANSWER: B
30. when should you
perform a change based recovery?
- lost redo log file
- user dropped a wrong table. the time of the event was known
- in a distributed
environment
ANSWER: C.
31. What is the true for standby database?
- constant recovery mode
ANSWER: A
32. a DBA want to export
the full database but the user still
logged on. Which option should he/she use
- direct=y
- consistent=y
- ignore=y
ANSWER: B
33.
when you want to do a full offline backup, some processes may
access the data. what should you do?
- shutdown abort
- shutdown immediate
-
shutdown deferred
- shutdown mornal
ANSWER: B
34. when should you backup read-only tablespace?
- once, right after the tablespace
become read-only
- every time you do a online backup
ANSWER: A
35. when a online redo log can be reused?
- after checkpoint, after the
log file was archived
- after checkpoint, before the log file was archived
- before checkpoint, after the log file was archived
- before
checkpoint, before the log file was archived
ANSWER: A
36. all of the members in a redo log group has to be archived before
this group
can be reused
- true
- false
ANSWER: B
37. a DBA can run a command to archive a online redo log file
- true
- false
ANSWER:
A
Alter system switch logfile.
38. which server manager command can show the database archive status
- archive log list
- alter database
...
ANSWER: A
39. where the current log sequence number stored? (choose 2)
- archived log file
- control file
- system tablespace
data file
ANSWER: B, C
40. use a full offline backup in NOARCHIVELOG mode can recover
database to
- a time in the past
- the point of
failure
ANSWER: A
The time when the backup was made.
41. what is true for COLD backup (choose 3)
- backup all datafiles, redo log files,
control files and
parameter file
- database not available to the user while backup
- simple
ANSWER: A,B,C
42. Full export can NOT be
used in
- user lost a table
- create a new database and import the data
- recover the database to the last commited transaction
ANSWER:
C
43. which one can recover to the point of failure?
- database was changed from NOARCHIVELOG to ARCHIVELOG, not
shutdown, keep all
archived redo logs
- database was changed from NOARCHIVELOG to ARCHIVELOG, shutdown,
do a full backup
ANSWER: B
PART III
--------
#1. Your database is in ARCHIVELOG mode, and you want to recover from a media failure up to the time of
failure. Which files do you need to
restore?
A. the damaged files from any valid backup
B. the damaged files from a backup taken after the database was set in ARCHIVELOG mode
C. the
damaged files and the redo-log files from a backup taken after the database was set in ARCHIVELOG
mode
D. the damaged files, the redo-log files,
and the control files from a backup taken after the database was set
in ARCHIVELOG mode
Answer: B
#2. While performing a database recovery, you
want the redo-log files to be applied automatically. What are three
ways to do that? (Choose three.)
A. enter the word AUTO when prompted for a
log
B. set the AUTO_ARCHIVE_LOG initialization parameter
C. use the AUTOMATIC clause of the RECOVER command
D. within SQL*plus, issue the SET
AUTORECOVERY ON command
Answer:A,C,D
#3. To successfully recover when restoring a backup control file to a different location, what must you
do?
A. update the initialization parameter file
B. use the ALTER SYSTEM command to rename the control file
C. use the ALTER DATABASE command to
rename the control file
D. You cannot do this; control files should always be restored to their original location.
Answer: A
#4. Your archived
logs are not restored to the ARCHIVE_LOG_DEST directory. What are three ways to notify the
Oracle server of their location? (Choose three.)
A.
specify the location and name when prompted for a log
B. use the ALTER SYSTEM SWITCH LOGFILE command
C. use the RECOVER FROM command to indicate
the new location
D. use the ALTER SYSTEM ARCHIVE command to indicate the new location
Answer: A,C,D
#5. Your database is in NOARCHIVELOG mode,
and a media failure occurs. Which files do you need to restore to
minimize data loss?
A. the damaged files only
B. the damaged files only if no
log switch has occured since the last backup
C. all data files that are consistenet from the same backup set if a log switch has occured since the
last
backup
D. all data files that can be a mix from any backup set if a log switch has occured since the last backup (You
can take them from
different backup sets if you like.)
Answer: B
#6. You perform an incomplete database recovery using RMAN. Which state of the target database is
needed?
A. mount
B. nomount
C. open, initially open
D. open, initially closed
Answer: A
#8. Which statement regarding Recovery Manager with
a database operating in NOARCHIVELOG mode is true?
A. Recovery Manager requires a recovery catalog.
B. Recovery Manager supports multi-level
incremental backups.
C. Recovery Manager is compatible with Enterprise Backup utility.
D. Recovery Manager only works in conjunction with a tape
subsystem.
Answer: C
#9. Before you can restore data files to a new location using RMAN, what should you do?
A. issue the SWITCH command
B.
issue the RESTORE command
C. take the data files that you need to restore offline
D. copy the data files to the new location using an operating
system tool
Answer: D
#10. What is the recommended initial size for a tablespace containing an RMAN recovery catalog?
A. 1M
B. 20M
C. 100M
D.
10% of the size of the target database
Answer: B
#11. After rebuilding the recovery catalog by resynchronizing it with a copy of the backup
control file, you notice
references to files that no longer exist. Which CHANGE command clause should you use to remove these
references?
A.
REMOVE
B. DELETE
C. UNCATALOG
D. CATALOG REMOVE
Answer: C
#12. What are two purposes for using the Recovery Manager command CATALOG? (Choose
two.)
A. updating recovery catalog about rollback segment creation
B. updating recovery catalog about files created before RMAN
C. updating
recovery catalog about operating system backups
D. updating recovery catalog about files created before Oracle8
E. updating recovery catalog about
files that belong to a clone database
Answer: A,B
#13. What are two benefits of using RMAN with a catalog? (Choose two.)
A. You can copy the redo-
log history into the control file.
B. You can store scripts for backup and recovery operations.
C. You can register the target database with
recovery catalog.
D. You can maintain records of backup and recovery operations.
E. You can synchronize the recovery catalog and the target
database.
Answer: B,C
#14. Your daily report indicating which data files need to be backed up has been misplaced. Which Recovery
Manager command
returns a report containing the files in the USER_DATA tablespace that have not been backed
up within the last three days?
A. rman> list backup
days 3 tablespace user_data;
B. rman> report backup days 3 tablespace user_data;
C. rman> catalog backup days 3 tablespace user_data;
D. rman>
report need backup days 3 tablespace user_data;
Answer: D
#15. Which command is used to allow RMAN to store a group of commands in the recovery
catalog?
A. ADD SCRIPT B. CREATE SCRIPT
C. CREATE COMMAND
D. ADD BACKUP SCRIPT
Answer: A
#16. Which statement about "time-based recovery"
is true?
A. Recovery is stopped by entering CANCEL at the recovery prompt.
B. Recovery is stopped by pressing at the recovery prompt.
C. Recovery
is stopped after the database has committed all changes up to the specified point-in-time.
D. Recovery is stopped when the database has committed
all changes up to the specified system change
number(SCN).
E. Recovery is stopped when the specified method of recovery(CANCEL, TIME, or CHANGE)
is completed,
and the control files are recovered.
Answer: C
#17. Which RECOVER command is appropriate when, while recovering a lost data file, a
DBA discovers that a
required, archived redo-log is corrupted?
A. RECOVER DATABASE UNTIL CANCEL;
B. ALTER TABLESPACE system RECOVER;
C. RECOVER
TABLESPACE system UNTIL CALCEL;
D. RECOVER DATABASE USING MISSING REDOLOG;
E. RECOVER DATABASE USING BACKUP CONTROLFILE;
Answer: A
#18. Which
action does Oracle recommend after a DBA recovers from the loss of the current online redo-log?
A. back up the data files
B. back up the
instance
C. back up the database
D. back up the control file
E. archive any unarchived online redo-logs
Answer: C
#19. Which statement is true
when using the LogMiner utility?
A. The dictionary file is created in a directory as defined by UTL_FILE_DIR.
B. The CREATE DBMS LOGMNR command is
used to build the dictionary file.
C. The dictionary file must be created after the log file analysis has completed.
D. The dictionary file is
created as a backup if the data dictionary gets corrupted.
Answer: A
#20. Which option is used in the parameter file to detect corruptions in an
Oracle data block?
A. DBVERIFY
B. DBMS_REPAIR
C. DB_BLOCK_CHECKING
D. VALIDATE_STRUCTURE
Answer: C
#21. The alter log can contain specific
information about which database backup activity?
A. placing data files in begin and end backup mode
B. placing tablespaces in begin and end
backup mode
C. changing the database backup mode from open to close
D. performing an operating system backup of the database files
Answer:
B
#22. Which statement is true when using the DBVERIFY utility to detect corruptions in an Oracle data block?
A. The utility can only be invoked
on a data file that is online.
B. The utility can be used to verify the data files of a backup database.
C. The utility can assist in archiving
log files when the database load is high.
D. The utility is internal to the database and so can impact database activities.
Answer: B
#23. Work
is done by Recovery Manager through ___.
A. PL/SQL packages
B. external procedures
C. operating system scripts
D. operating system
commands
Answer: A
#24. When using Recovery Manager without a catalog, the connection to the target database ___.
A. must be a local
connection
B. must be a remote connection
C. can be a local or remote connection
D. must be specified using a Net8 service name
Answer: C
#25.
Which statement about an open database backup is NOT true?
A. The database must be in ARCHIVELOG mode.
B. The database is available for use during
backups.
C. All the database files copied are consistenet to a point-in-time.
D. An operating system backup of the database files is
required.
Answer: C
#26. When performing an open database backup, which statement is NOT true?
A. The database is fully accessible to all
users.
B. The database must be operating in ARCHIVELOG mode.
C. The database can be open but only in READ ONLY mode.
D. The database tablespaces
should be in BEGIN BACKUP mode.
Answer: C
#27. Which command creates a text backup of the control file?
A. ALTER DATABASE BACKUP CONTROLFILE TO
TRACE;
B. ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C. ALTER DATABASE BACKUP CONTROLFILE TO 'filename';
D. ALTER DATABASE BACKUP CONTROLFILE
TO TEXT 'filename';
Answer: A
#28. When the status of a tablespace moves from read-only to read-write, which two events occur? (Choose two.)
A.
Redo-log switch must take place.
B. Normal checkpoints on the files now occur.
C. Oracle automatically marks the file for backup.
D. All objects
in the tablespace are ckecked for integrity.
E. The DBWn process writes to the data files of the tablespace.
Answer: B,E
#29. In the view
V$DATAFILE_HEADER, what does value "YES" in the "FUZZY" column as specify?
A. The data file is corrupted.
B. The data file is in backup
mode.
C. The data file is locally managed.
D. The data file is part of a read-only tablespace.
Answer: B
#30. Why would a DBA load a table using
the NOLOGGING option?
A. to eliminate further backup
B. to temporarily disable collecting statistics
C. to reduce redo during a direct-load
operation
D. to specify that the blocks retrieved for this table are placed at the least recently-used end of the buffer
cache
Answer: C
PART IV
-------
1. (Similar Question seen 69 times, last seen on 7/10/2002)
A user has received an ORA-1578 error message indicating
datablock corruption of a specific file. It has been determined that the data
contained in the corrupted files can be lost with minimal
consequences. How should the uncorrupted rows be recovered?
A. Perform Table Only recovery in Recovery Manager.
B. Issue the ALTER TABLE REMOVE
command.
C. Delete all rows from the table and then issue a rollback.
D. Select All rows below and above the corrupted block and insert them
into a new table.
Answer: D
2. (Similar Question seen 32 times, last seen on 7/10/2002)
If an invalid checksum is detected on a redolog
group member prior to
its being archived, what will happen?
A. The redolog group member is archived.
B. The ARCH process hangs.
C. The
archive returns a fatal error.
D. No archive occurs and an error is written to the ALERT_LOG file.
Answer: D
3. (Similar Question seen 27
times, last seen on 7/10/2002)
You use Backup Manager because it is easy to access. Why is it easy to access?
A. It can be opened from SQL
plus.
B. It is NDS-compatible.
C. It is operating system independent.
D. It is not incorporated into Oracle Enterprise Manager.
Answer:
C
4. (Similar Question seen 24 times, last seen on 7/10/2002)
You have just changed the mode of your database to ARCHIVELOG. What table must
be viewed to view mode information?
A. V$ARCHIVELOG
B. V$DATABASE
C. V$RECOVER
D. V$INSTANCE
Answer: B
5. (Similar Question seen 29
times, last seen on 7/10/2002)
To use Recovery Manager to recover a database, the database ______.
A. Must include all archived redolog files.
B. Must have been taken or registered using RMAN.
C. Must include the backed-up control files.
D. Have online datafiles before they can be
restored using RMAN.
Answer: B
6. (Similar Question seen 44 times, last seen on 7/10/2002)
A datafile is not synchronized. If the database
is to continue running
without errors, the file must be in which type of tablespace along with
other database files?
A. ONLINE
B. READ-WRITE
C. TEMPORARY
D. READ-ONLY
Answer: D
7. (Similar Question seen 26 times, last seen on 7/10/2002)
If the checksum for each member in a
redolog group is invalid, what will
happen during archiving?
A. The archive process will reset.
B. The database will hang
C. The archive
process will switch to the next redolog group and continue the backup.
D. The redolog process will abort and the database will continue until the
problem has been resolved.
Answer: B
8. (Similar Question seen 27 times, last seen on 7/10/2002)
In which two files is the sequence number
of the current redolog file
recorded? (choose 2)
A. Most recent archived log file
B. Parameter file
C. Control file
D. System tablespace
datafile
Answer: C, D
9. (Similar Question seen 47 times, last seen on 7/10/2002)
A data file that belongs to the SYSTEM tablespace is
corrupted.
You perform a data file recovery, which action must you take to
perform this recovery?
A. take the datafile belongs to the SYSTEM
tablespace offline
B. You can't perform datafile recovery since this file belongs to the SYSTEM tablspace.
C. Take the SYSTEM tablespace
offline.
D. Export the entire SYSTEM tablespace.
Answer: B
10. (Similar Question seen 24 times, last seen on 7/10/2002)
You restore the
backup copies of the corrupted data files, which
command will begin the full database recovery?
A. RECOVER tablespace.
B. RECOVER datafile
C. RECOVER database
D. RECOVER database complete
Answer: C
11. (Similar Question seen 19 times, last seen on 7/10/2002)
You are the
DBA of a database that is used by investment strategy
analysis. The loss of transaction activities would be disastrous.
Which step would you
include as part of your backup and recovery
strategy:
A. Manually backup redo log files.
B. Automatically archive the redo log files
C.
Automatically archive the database
D. make frequent Cold Backups
Answer: B
12. (Similar Question seen 23 times, last seen on
7/10/2002)
Before determining a backup & recovery strategy for your database
which action should you take to ensure the appropriate
strategy?
A. meet with management to determine their tradeoffs involved in their expections of system availability.
B. Meet with end users to
determine their expectations for data availability
C. Determine how many redo log files you expect to be created on a daily basis
D. Determine
how many Checkpoints will be requested to allow the max. availability
Answer: A
13. (Similar Question seen 28 times, last seen on
7/10/2002)
Your database is not in ARCHIVELOG mode. A file has been damaged
and you now must apply your backup and recovery strategy. Which
step
should be your first?
A. Shut down the database, if it is not already
B. Startup the database
C. Restore most recent full online backup
D. Alter database to ARCHIVELOG mode
Answer: A
14. (Similar Question seen 19 times, last seen on 7/10/2002)
Which characteristic
describes an incomplete recovery?
A. Minimized the amount of work lost
B. Recovers to the state just prior to the current time
C. Can be
performed while the database is still available to users
D. Reconstructs the database to a point in the Past *
Answer: D
15. (Similar
Question seen 19 times, last seen on 7/10/2002)
You have decided to perform an incomplete recovery of database, which
action must you take to
accomplish this type of recovery.
A. restrore copy of control file that was backuped prior to the current time.
B. Issue the incomplete recover
command after restore all backup datafiles.
C. None
D. Halt recovery operation prior to reaching the current time.
Answer: D
16. (Similar
Question seen 18 times, last seen on 7/10/2002)
When recovery a damaged datafile, you determined that backup file
requires redo log entries to
be applied. Which action must you perform to
complete recovery.
A. Alter mode of database to archivelog.
B. Alter the mode of database to
noarchivelog.
C. Identify the necessary redo log files that been created since last backup.
D. Identify checkpoint information, and apply this
checkpoint to appropriate data file.
Answer: C
17. (Similar Question seen 19 times, last seen on 7/10/2002)
The database has to be run 24
hr/day and 7 days/week. If you
want to export the whole database with Export utility,
what should you consider?
A. concurrent transaction will
suffer
B. the database being exported will be locked
C. constraint may cause problem
Answer: A
18. (Similar Question seen 21 times, last
seen on 7/10/2002)
The recovery operation you are preparing include read-only
tablespaces. Which command can you issue to get a listing
of
the commands needed to recover this database?
A. ALTER TABLESPACE
B. CREATE CONTROL FILE
C. ALTER DATABASE RENAME
D. ALTER DATABASE BACKUP
CONTROLFILE TO TRACE
Answer: D
19. (Similar Question seen 23 times, last seen on 7/10/2002)
The PROD database is running in NOARCHIVELOG
mode and a media
failure occurs. The disk drive holding one of the detafile
cannot be replaced immediately and you have moved the datafile
to
another drive. Which command would you issue to reflect
this physical change in the databse?
A. ALTER DATAFILE RENAME
B. ALTER SYSTEM RENAME
FILE
C. ALTER DATABASE RENAME FILE
D. ALTER TABLESPACE RENAME FILE
Answer: C
20. (Similar Question seen 22 times, last seen on
7/9/2002)
To recover the database using the available archived redo log
files. Which two tasks you need to perform? (Choose two)
A. Set
AUTORECOVERY on
B. Set recover all on
C. Recover all database
D. Recover database
E. Set autorecover database on
F. Recover
Answer: A,
D
PART V
------
Q.01 Which statement is true about dbverify utility?
A. It can verify any DB_BLOCK_SIZE file.
B. It dose not verify
the file that block size is greater than 2K.
C. It dose not verify the file that block size is greater than 4K.
D. It dose not verify the file
that block size is greater than 8K.
Answer A.
Q.02 What dose an ARCn process in instance recovery?
A. It writes the datafile.
B. It
writes the redolog file.
C. It writes in the archivelog file.
D. It not take a part in instance recovery.
Answer D.
Q.3 Which
information is not recorded in Alert log file?
A. data file offline.
B. recovery information.
C. Backup mode ARCHIVELOG and NOARCHIVELOG.
Answer C.
Q .04 You want to connect the user name Smith and Password is Danger and recovery manager user name and password
are recman an
tns alias is RCVCAT.
Which statament is true.
A. rman smith/danger@ DB00
rcvcat recman/recman @ RCVCAT.
B. connect target smith/danger @
DB00
rcvcat recman/recman @ RCVCAT.
C. connect target smith/danger
rcvcat recman/recman @ RCVCAT.
D. rman target smith/danger @ DB00
rcvcat recman/recman @RCVCAT.
Answer D.
Q.05 Which record "Resync" command update?
Chooce two.
A. Log switches.
B. redologs
records.
C. Archivedlog records.
D.Datafile records.
Answer A,C.
Q.06 Database is close because loss of controlfile,how can you backup
the controlfile?
A. Create control file command.
B. Alter database backup controlfile from trace.
C. Alter database backup controlfile to
trace.
Answer C.
Q.06 You want to set the three Archive destinations
Which statement is true.
A.
LOG_ARCHIVE_DEST,LOG_ARCHIVE_DEST1,LOG_ARCHIVE_DEST2
B. LOG_ARCHIVE_DEST1,LOG_ARCHIVE_DEST2,LOG_ARCHIVE_DEST3
C.
LOG_ARCHIVE_DEST0,LOG_ARCHIVE_DET1,LOG_ARCHIVE_DEST2
ANSWER B.
Q.07 Multiplexing of the control file.
Q.08 You set your database mode
NOARCHIVELOG TO ARCHIVELOG mode.
What tells you to Oracle Server?(choose two).
A. specify the datafile location.
B. Specify Archive logs
destination where they are copying.
C. Increase the performance of server.
D. Name of Archive logs that are identifying.
ANSWER B,D.
Q.09 Which two parameters are different in primary database and standby database?
Q.10 In table V$DATAFILE_HEADER the column is FUZZY
"YES".
Which situation.
A. redo logs backup.
B. data file backup.
c. control file backup.
ANSWER B.
Q.11 When you activate the
standby database,What will happen ?.
A. Primary database becomes standby database.
B. Standby database becomes primary database.
ANSWER B.
Q.12 When operation involved NOLOGGING on primary database ,what work performe on standby database ?.
A. O/S level transffered archive logs.
B. change the operation nologging to logging.
C. You have to take a backup of the tablespace involved and copy it to the standby database.
ANSWER C.
Q.13 You transffered the archive log from primary database to standby database.
choose two.
A. ALTER SYSTEM command.
B.
ALTER DATABASE SYSTEM command.
C. STANDBY_ARCHIVE_DEST.
ANSWER A,C.
Q.14 You perform backup through RMAN,which memory area use RMAN ?
A. SHARED POOL.
B. PGA
C. LOG BUFFER.
D. SPA.
ANSWER B.
Q.15 You take backup and through BACKUP command create backup sets,
In
backup sets which blocksize of backup piece ?
A. same block size.
B. change blocke size.
ANSWER A.
Q.16 When you use Media Management
Layer software,What is do?
A. When writing or reading from tape.
B. Only writing to tape.
C. only reading from tape.
ANSWER A.
Q17.
YOU want to restore a file from backup which is taken through RMAN,what is state of restore file?
A. data file offline.
B. file is online.
C. restore database.
D. switch databse.
ANSWER A.
Q.19 Which is parameter is checked Oracle data block corruption?
A. DBMS_REPAIR.
B. dbv.
C. ANALYZE.
D. DB_BLOCK_CHECKING.
ANSWER D.
Q.20 When you open primary database with RESETLOGS option,what will happen.
A.
standby database invalidate.
B. no effect on standby database.
C. The archive files not reset for the standby database.
ANSWER A.
Q.21
Creation of recovery catalog ,What is the last step ?
A. create rman user.
B. connect to rcvcat.
C. Register to target database.
D. login
to o/s.
ANSWER. C.
Q.22 You want to export table and you do not want to include its data ?
A. DIRECT
B. ROWS
C. COMPATIBLE
D.
TABLE
ANSWER B.
PART VI
-------
1. What are two benefits of using RMAN with a catalog? (Choose two)
A. You can copy the redo-log
history into the control file.
B. You can store scripts for backup and recovery operations. ***
C. You can register the target database with
recovery catalog.
D. You can maintain records of backup and recovery operations. ***
E. You can synchronize the recovery catalog and the target
database.
Answer: B,D
2. What is recommended initial size for a tablespace containing an RMAN recovery catalog?
A. 1M
B. 20M ***
C.
100M
D. 10% of size of the target database.
Answer: B
3. Your daily report indicating which data files need to be backed up has been
misplaced. Which Recovery Manager command returns a report containing the files in the USER_DATA tablespace that have not been backed up within the
last three days?
A. rman> list backup day 3 tablespace user_data;
B. rman> report backup days 3 tablespace user_data;
C. rman> catalog backup
days 3 tablespace user_data;
D. rman> report need backup days 3 tablespace user_data; ***
Answer: D
4. Which command is used to allow RMAN
to store a group of commands in the recovery catalog?
A. ADD SCRIPT
B. CREATE SCRIPT ***
C. CREATE COMMAND
D. ADD BACKUP SCRIPT
Answer:
B
5. After rebuilding the recovery catalog by resynchronizing it with a copy of the backup control file, you notice references to files that no
longer exist. Which CRETAE command clause should you use to remove these references?
A. REMOVE.
B. DELETE.
C. UNCATALOG.
D. CATALOG REMOVE.
***
Answer: D
6. What are two purposes for using the Recovery Manager command CATALOG? (Choose two)
A. Updating recovery catalog about
rollback segment creation.
B. Updating recovery catalog about files created before RMAN.
C. Updating recovery catalog about operating systems
backup. ***
D. Updating recovery catalog about files created before Oracle 8. ***
E. Updating recovery catalog about files that belong to a clone
database.
Answer: C,D
7. What is the advantage of managed recovery mode?
A. During recovery, most common DBA errors can be avoided.
B.
Prompts for applying the next available redo logs suppressed.
C. The primary database automatically ships archived redo log files to the standby
server.
D. The standby database automatically applies the archived redo log when the files become available. ***
Answer: D
8. What is the
effect of issuing an ALTER DATABASE OPEN RESETLOGS command on the primary database?
A. It invalidates the standby database. ***
B. The standby
database can only be used in read-only mode.
C. A new standby database incarnation will automatically be started.
D. Once the archived log files
are applied to the standby database, the redo log of the standby database is reset.
Answer: A
9. What is the effect of activating a standby
database?
A. The primary database becomes a standby database.
B. The standby database becomes the primary database. ***
C. The primary
database is deactivated to avoid conflicts.
D. The remaining redo-log files are copied from the primary database and applied.
Answer:
B
10. What is the difference between using NOLOGGING operations in a single database environment and a standby database environment?
A.
There is no difference.
B. NOLOGGING operations are not available in release 0.1
C. The affected data file needs to be copied from the primary to
the standby server. ***
D. NOLOGGING operations can be used on the standby database, but not on the primary database.
Answer: C
11. The
command ALTER DATABASE CREATE STANDBY CONTROLFILE AS standby.ct creates a standby control file. What needs to be done next to create a standby
database?
A. The standby control file needs to be copied to the standby server. ***
B. The current redo-log files of the primary database need
to be archived.
C. The standby database needs to be created using the standby control file.
D. The standby control file needs to be copied to
the standby location on the primary server.
Answer: A
12. What is the correct procedure for multiplexing existing online redo logs?
A.
Issue the ALTER DATABASE. . . ADD LOGFILE GROUP command.
B. Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command. ***
C. Shut down the
database, copy the online redo-log, and start up the database.
D. Shut down the database, copy the online redo-log, edit the REDO_LOG_FILES
parameter, and start up the database.
Answer: B
13. Which statement concerning archiving is true?
A. Archiving occurs during a
checkpoint.
B. Archive logs can be written to multiple destinations. ***
C. Backups are not required when archiving is enabled.
D. Archiving
copies the data files to their backup destinations.
E. Archiving can be enabled through Recovery Manager commands.
Answer: B
14. What is
the function of SMON in instance recovery?
A. It writes data to the archive log files.
B. It writes data to the online redo log files.
C. It
frees resources held by user processes.
D. It synchronizes data file header and control files.
E. It roles forward by applying changes in the
redo log. ***
F. It writes dirty buffers from the buffer cache to the data files.
Answer: E
15. What is the function of ARCn in instance
recovery?
A. It writes data to the archive log files.
B. It writes data to the online redo log files.
C. It frees resources held by user
processes.
D. It synchronizes data file header and control files.
E. It writes dirty buffers from the buffer cache to the data files.
F. The
archive process does not take part in instance recovery. ***
Answer: F
16. What are two causes of user errors? (Choose two)
A. Incorrect
data is committed. ***
B. The operating system crashes.
C. There are insufficient privileges.
D. A table is accidentally truncated. ***
E. An
application file is accidentally deleted.
F. The application program receives an addressing exception.
Answer: A,D
17. Which option is
used in the parameter file to detect corruptions in an Oracle data block?
A. DB/VERIFY
B. DBMS_REPAIR
C. DB_BLOCK_CHECKING ***
D.
VALIDITY_STRUCTURE
Answer: C
18. Which statement is true when using the LogMiner utility?
A. The dictionary file is created in a
directory as defined as defined by UTL_FILE_DIR. ***
B. The CREATE DBMS LOGMSR command is used to build the dictionary file.
C. The dictionary
file must be created after the log file analysis has completed.
D. The dictionary file is created as a backup if the data dictionary gets
corrupted.
Answer: A
19. Which statement is true when using the DELIVERY utility to detect corruptions in an Oracle data block?
A. The
utility can only be invoked on a data file that is online.
B. The utility can be used to verify the data files of a backup database. ***
C. The
utility can assist in archiving log files when the database load is high.
D. The utility is internal to the database and so can impact database
activates.
Answer: B
20. The alert log can contain specific information about which database backup activity?
A. Placing datafiles in
begin and end backup mode.
B. Placing tablespace in begin and end backup mode. ***
C. Changing the database backup mode from open to close.
D.
Performing an operating system backup of the database files.
Answer: B
21. In which two situations would you have to apply redo information
to a read-only tablespace? (Choose two)
A. When the tablespace being recovered has always been writeable.
B. When the tablespace being
recovered is unknown to the control file.
C. When the tablespace being recovered is read-only and was read-only when the last backup occurred.
D. When the tablespace being recovered is writeable, but was read-only when the last backup occurred. ***
E. When the tablespace being recovered
is read-only, but was writeable when the last backup occurred. ***
Answer: D,E
22. Which two types of data files can be considered non-
essential? (Choose two)
A. Data files belonging to a lost tablespace.
B. Data files belonging to an index tablespace. ***
C. Data files
belonging to a SYSTEM tablespace.
D. Data files belonging to a temporary tablespace. ***
E. Data files belonging to an application data
tablespace.
F. Data files belonging to a rollback segment tablespace.
Answer: B,D
23. In which situation would you need to create a new
control file for an existing database?
A. When all redo-log files are lost.
B. When MAXLOGMEMBERS needs to be changed. ***
C. When
RECOVERY_PARALLELISM needs to be changed.
D. When the name of the parameter file needs to be changed.
Answer: B
24. A tablespace becomes
unavailable because of a failure. The database is running in NOARCIVELOG mode? What should the DBA do to make the database available?
A. Perform
a tablespace recovery.
B. Perform a complete database recovery.
C. Restore the data files, redo log files, and control files from an earlier
copy of a full database backup. ***
D. There is no possibility too make the database available.
Answer: C
25. Why is manual archiving not
recommended?
A. Additional disk resources are required.
B. More background processes are required.
C. A DBA must issue at SQL command to
archive the online redo-log files. ***
D. An operating systems script must be written to copy the online redo-log files.
Answer: C
26.
What kind of destination can DBA choose when specifying the LOG_ARCHIVE_DEST_n parameter?
A. A Net8 listener name.
B. Only a local dictionary.
C. Only a Net8 atlas for a remote database.
D. A local dictionary or Net8 atlas for a remote database. ***
Answer: D
27. How can a DBA
disable one of the current archive destructions?
A. Issue the command ALTER SESSION SET LOG_ARCHIVE_DEST+DEFER. ***
B. Shut down the database
and delete the archive destination dictionary at the operating system level.
C. Specify the initialisation parameter
LOG_ARCHIVE_DEST_STATE_n+DEFER.
D. It is not possible to disable archive destinations?
Answer: A
28. When configuring a database for
ARCHIVELOPG mode, you use an initialisation parameter to specify which action?
A. The size of archived log files.
B. How frequently log files
will be archived.
C. That the database is in ARCHIVELOG mode. ***
D. Whether archiving will be manual or automatic.
Answer: C
29. Your
database is configured in ARCHIVELOG mode. Which three types of backups can be performed? (Choose three)
A. Open database backups. ***
B.
Operating system backups when the database is closed. ***
C. Online control file backups using the ALTER CONTROLFILE BACKUP command.
D. Online
tablespace backups using the ALTER DATABASE BACKUP TABLESPACE command.
E. Online control file backups using the ALTER DATABASE BACKUP CONTROLFILE
command. ***
Answer: A,B,E
30. Which two actions must you take to stop automatic archiving of redo-log files? (Choose two)
A. Issue the
ALTER SYSTEM ARCHIVE LOGSTOP; command ***
B. Issue the ALTER SYSTEM SET LOG_ARCHIVE_START=FALSE; command
C. Set LOG_ARCHIVE_STOP=TRUE parameter
file and restart the database.
D. Set LOG_ARCHIVE_START=FALSE in the parameter file and restart the database. ***
Answer: A,D
|
gen. 0.738
Forum
User braindumps