Oracle9i Database Administration Fundamentals - 2 Online Test

An Oracle database ensures detection of the need for database recovery by checking for synchronization using which of the following background processes?
DBW0
LGWR
CKPT
SMON
You are attempting to identify synchronization between files on a mounted database that was just backed up. Which of the following dictionary views may offer assistance in this task?
V$BACKUP_CORRUPTION
V$LOGFILE
V$DATAFILE_HEADER
V$BACKUP
You are generating a script for database backup in RMAN. Which of the following keywords indicates whether or not to back up empty blocks in a datafile or changed blocks?
FILESPERSET
LEVEL
TYPE
CURRENT
You are trying to determine the status of a database backup. In order to determine the data files involved in the backup, which of the following queries are appropriate?
SELECT FILE# FROM V$DATAFILE WHERE STATUS = ‘ONLINE’
SELECT FILE# FROM V$BACKUP WHERE STATUS = ‘ACTIVE’
SELECT FNAME FROM V$DATAFILE WHERE STATUS = ‘ACTIVE’
SELECT FNAME FROM V$BACKUP WHERE STATUS = ‘ONLINE’
After performing a data load of static data on a tablespace, the DBA performs a backup. If the DBA then sets the tablespace to read-only mode, when is the next time a backup should be taken?
Immediately after placing the tablespace into read-only mode
The next time a data load is performed on the tablespace
The next time the database is put into read-only mode
The next time the DBA shuts down the database
The DBA is attempting to back up the Oracle database control file. After issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command, where can the DBA find the backup control file creation materials Oracle created for him or her?
USER_DUMP_DEST
LOG_ARCHIVE_DEST
CORE_DUMP_DEST
BACKGROUND_DUMP_DEST
You are evaluating the complexity of an existing recovery strategy in your organization. Offline backups on OARCHIVELOG mode databases offer which of the following benefits over offline backups on ARCHIVELOG databases?
Complete recovery to point of failure
Ease of use
Fast restoration of transactions executed after backup
Ideal recoverability for extensive production data
You are backing up an Oracle database on the UNIX platform while the database is still open. Before issuing the tar command, which of the following statements should be issued?
shutdown immediate
shutdown abort
alter database data file begin backup
alter tablespace begin backup
You are attempting to connect to RMAN on the command line. In order to connect to the production database at the time you start RMAN, which of the following command-line options must be specified at the time of login?
Target
Msglog
Rcvcat
Cmdfile
You are creating a recovery catalog for your production database. Which of the following roles must be granted to the recovery catalog owner in order for RMAN to work properly?
RECOVERY_CATALOG_OWNER & SYS_DBA
EXP_FULL_DATABASE
SYSDBA
EXECUTE_CATALOG_ROLE
You are attempting to create a robust backup and recovery strategy using Oracle Enterprise Manager 2.0. Which two of the following tools allow you to start and stop the Oracle instance
Storage Manager& Data Manager
Backup Manager& Instance Manager
Data Manager& Instance Manager
Instance Manager & Storage Manager
The DBA is evaluating the use of RMAN in a backup and recovery strategy for Oracle databases. Which of the following are reasons NOT to use RMAN in conjunction with the overall method for backing up and recovering those databases?
When backup and recovery is required for Oracle9 or Oracle9 i
When the database consists of large but mostly static data files
When automation of the backup processing is required
When your backup strategy must encompass files other than Oracle database files
Which of the following SQL * loader parameters enables you to load a specified number of records stored in the data file?
ROWS
SKIP
LOAD
BINDSIZE
A machine hosting the Oracle database has three separate physical disks (called DISK1, DISK2, and DISK3, respectively) used for storing three online redo logs. Which of the following configurations is best in order to multiplex redo log members across these three separate disks when redo logs are being archived?
DISK1: redo01a.dbf, redo01b.dbf; DISK2: redo02a.dbf, redo02b.dbf; DISK3: redo03a.dbf, redo03b.dbf
DISK1: redo01a.dbf, redo03b.dbf; DISK2: redo01b.dbf, redo03a.dbf; DISK3: redo02a.dbf, redo02b.dbf.C.
DISK1: redo01a.dbf, redo02a.dbf, redo03a.dbf; DISK2: redo01b.dbf,redo02b.dbf, redo03b.dbf; DISK3: redo01c.dbf, redo02c.dbf,redo03c.dbf
DISK1: redo01a.dbf, redo03b.dbf; DISK2: redo01b.dbf, redo02a.dbf; DISK3: redo03a.dbf, redo02b.dbf
The DBA has decreased LOG_CHECKPOINT_INTERVAL to 6000 and changed LOG_CHECKPOINT_TIMEOUT from 0 to 5. Which of the following choices best identifies the impact these settings will have on the Oracle database?
The increased checkpoint frequency will improve recoverability of the instance, but will adversely impact performance.
The increased checkpoint frequency will improve recoverability of the instance, and will improve performance.
The decreased checkpoint frequency will worsen recoverability of the instance, but will improve performance.
The decreased checkpoint frequency will worsen recoverability of the instance, but will improve performance.
Description:

This test is focused on backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Log files management is also covered in few questions of this test
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts