Printable View
Hi
I am preparing for Oracle 8i backup and recovery and I have with ILT and STS. Actually I am working full time in fiance field. I have taken a week off to prepare for this examination.
i will appreciate somebody can give me some suggestions. Please
Thanks
just study all modules in the ILT and also undertans all questions from STS. Do not stop practising STS until u get 100% and also understand the explanation provided by the STS with the answers. Study RMAN properly.
ICEMAN
Hi zenith..
Here are few very imp questions....
1. What kind of destination can a DBA choose when specifying the LOG_ARCHIVE_DEST_n parameter?
A. net8 listener name
B. only a local directory
C. only a net8 alias for a remote database
D. a local directory or a net8 alias for a remote database
2. Which technique does Oracle use to perform full backup of data files?
A. The server process reads and backs up the entire file.
B. The server process reads the entire file and skips blocks that have never been used.
C. The server process reads the entire file and skips blocks assigned to temporary segments.
D. The server process reads the entire file and skips blocks currently not being used.
E. The server process reads the entire file and skips blocks unchanged from last backup.
3. What is the difference between using NOLOGGING operation in a single database environment and a standby database environment.
A. No difference
B. NOLOGGING operation not available in release 8.1
C. The affected data files need to be copied from primary to standby server.
D. NOLOGGING operation can be used on standby but not on primary database.
Question: Level 1 backup is taken on the first of each
month. Level 2 backup is taken every Sunday. Level 3
backup is taken daily. If database gets corrupted on the
2nd Wednesday of the month and is lost, which scenario will
restore the database completely?
A) Level 2 & Level 3 backups should be used.
B) Level 1 & Level 3 backups should be used.
C) A baseline backup (Level 0) is missing so nothing can
be recovered.
D) Level 1, Level 2, & Level 3 backups should be used.
Question: Which statement about RMAN w/ a database in
NOARCHIVELOG mode is true?
A) RMAN requires a recovery catalog.
B) RMAN supports multi-level incremental backups.
C) RMAN is compatible w/ Enterprise Backup utility.
D) RMAN only works in conjunction w/ a tape subsystem.
Question: When using RMAN w/out a catalog, the connection
to the target database ________________.
A) Must be local.
B) Must be remote.
C) Can be either local or remote.
D) Must be specified using a Net8 service name.
Question: Which statement about allocation of processes to
RMAN is true?
A) When enabling I/O slaves, ensure that the shared pool
is sized appropriately.
B) I/O slaves can only be used if the operating system
supports asynchronized I/O.
C) Enabling I/O slaves can be controlled by setting
USE_IO_SLAVES appropriately.
D) Setting BACKUP_TAPE_IO_SLAVES = true will enable a
dedicated slave to write a tape device.
Question: Which TWO types of data files can be considered
non-essential?
A) Datafiles belong to a lost tablespace.
B) Datafiles belong to an index tablespace.
C) Datafiles belong to a system tablespace.
D) Datafiles belong to a temporary tablespace.
E) Datafiles belong to an application data tablespaces.
F) Datafiles belong to a rollback segment tablespace.
Question: What is the recommended initial size of a
tablespace containing RMAN recovery catalog?
A) 1M
B) 20M
C) 100M
D) 10% of the size of the target database.
Question: What are the TWO purposes of using RMAN command
CATALOG?
A) Update recovery catalog about rollback segment creation.
B) Update recovery catalog about files created before RMAN.
C) Update recovery catalog about operating system backups.
D) Update recovery catalog about files created before
Oracle 8.
E) Update recovery catalog about files belong to a clone
database.
Question: Work is done by RMAN through ___________.
A) Pl/SQL packages
B) external procedures
C) operating system scripts
D) operating system commands.
Question: When the status of a tablespace moves from
read-only to read-write, which TWO events occur?
A) Redo log switch must take place.
B) Normal checkpoint on the files now occur.
C) Oracle automatically marks the file for backup.
D) All objects in tablespace are checked for integrity.
E) DBWn process writes to the data files of the tablespace.
Question: There was a question about cancel-based recovery asking you basically:
how can you stop a cancel-based recovery?
A. Recovery can be stopped by entering cancel at the recovery prompt
B. Recovery can be stopped by pressing ctrl-C at the recovery prompt
.... (I forgot the rest?)
Best of Luck....
Justin !!!!!
Hi ,
can any one check these answers .
1. What kind of destination can a DBA choose when specifying the LOG_ARCHIVE_DEST_n parameter?
A. net8 listener name
B. only a local directory
C. only a net8 alias for a remote database
D. a local directory or a net8 alias for a remote database
Ans D
Question: Which TWO types of data files can be considered
non-essential?
A) Datafiles belong to a lost tablespace.
B) Datafiles belong to an index tablespace.
C) Datafiles belong to a system tablespace.
D) Datafiles belong to a temporary tablespace.
E) Datafiles belong to an application data tablespaces.
F) Datafiles belong to a rollback segment tablespace.
D & F
Question: What is the recommended initial size of a
tablespace containing RMAN recovery catalog?
A) 1M
B) 20M
C) 100M
D) 10% of the size of the target database.
20M
Question: Work is done by RMAN through ___________.
A) Pl/SQL packages
B) external procedures
C) operating system scripts
D) operating system commands.
PL/SQL Packages and Operating System Commands
also anyone can put their views on the other questions .
thanks
Question: Work is done by RMAN through ___________.
A) Pl/SQL packages
B) external procedures
C) operating system scripts
D) operating system commands
I think this should be Pl/SQL packages
Sure don't bother to study, just memorize the answers. What the heck B&R isn't that important anyway right? Jeez!
Study all the chapters in the ILT, after you complete each chapter do ALL the STS questions for that chapter. When you get a question wrong make sure you "UNDERSTAND" why and move on. This is the way I did it, way back in 2000. Don't just mindlessly memorize questions.
Ps What exactly is the "fiance field" do you arrange marriages?
MH
I think it's a lot like writing $100 instead of $1000. No big deal, extra letter, extra zero here and there.
ROLLBACK is ESSENTIAL!Quote:
Originally posted by prakashs43
Hi ,
Question: Which TWO types of data files can be considered
non-essential?
A) Datafiles belong to a lost tablespace.
B) Datafiles belong to an index tablespace.
C) Datafiles belong to a system tablespace.
D) Datafiles belong to a temporary tablespace.
E) Datafiles belong to an application data tablespaces.
F) Datafiles belong to a rollback segment tablespace.
D & F
B & D
Yeah ogbologbo, remembering back to my B&R exam, I got that question.