Here are few exam questions !!!!
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
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
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
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?
D) 10% of the size of the target database.
Question: What are the TWO purposes of using RMAN command
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
E) Update recovery catalog about files belong to a clone
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....