Check how comfortable you are with Oracle Administration Online Test

The DBA is looking for simpler alternatives for backup and recovery in Oracle8I. Rather than defining scripts for backup and recovery processing using the command-line editor, which of the following OEM tools can assist?
Recovery Manager
Backup Manager
Storage Manager
OEM Console
The DBA is configuring use of RMAN with a recovery catalog. When using a recovery catalog in conjunction with RMAN, where can be the actual backup copies of database information found?
On tape or disk staging area
In the recovery catalog
In the production database
In the Oracle software distribution
The DBA is assessing maintenance of recovery catalog creation. Once created, where does the recovery catalog draw much of its information from when maintenance is performed on it?
Production database files
Recovery catalog control file
Production database control file
Archived redo logs.
If connection to the production database is not established from the command line, which of the following choices identifies an appropriate command syntax to issue from within RMAN to establish connection?
connect rcvcat scott/tiger@prod
connect prod scott/tiger@prod
connect target system/manager@prod
connect target rman/rman@rcat
The DBA is configuring RMAN for use as the backup/recovery tool for the Oracle database. After creating the production database and the recovery catalog, which command is used for establishing the baseline information required in the recovery catalog for proper RMAN usage?
RESET
REGISTER
RESYNC
REPORT
The DBA has shut down the database and made copies of all datafiles manually as a benchmark backup for stress testing. Which of the following RMAN commands will make that backup usable in the context of the rest of the contents of the recovery catalog?
RESYNC
CATALOG
REPORT
LIST
The DBA needs to identify available backups for the sys03.dbf datafile belonging to the SYSTEM tablespace. Which of the following commands would be most appropriate for this process?
LIST COPY OF TABLESPACE SYSTEM;
REPORT NEED BACKUP INCREMENTAL 5 DATABASE;
LIST COPY OF DATAFILE ‘/u03/oradata/prod/sys03.dbf’;
LIST INCARNATION OF DATABASE PROD;
The DBA is developing scripts in RMAN. In order to store but not process commands in a script in RMAN for database backup, which of the following command choices are appropriate?
RUN { ... }
EXECUTE SCRIPT { ... }
CREATE SCRIPT { ... }
ALLOCATE CHANNEL { ... }
The DBA is developing a script for backups that will ensure that no block corruption is permitted in a datafile. Which of the following commands is appropriate for that script?
SET MAXCORRUPT 0
SET DBVERIFY ON
SET LOG_BLOCK_CHECKSUM ON
SET ARCHIVELOG DESTINATION ‘/u03/oradata/prod/arch’
The DBA is considering dropping and re-creating indexes using the NOLOGGING option. Which of the following identifies the trade-off a DBA makes in using LOGGING vs. NOLOGGING?
Time vs. money
Speed vs. recoverability
Space on disk vs. space in memory
CPU vs. tape
The DBA makes a copy of Oracle database datafiles as part of an attempted backup. Later, the DBA realizes that the instance was running. Which of the following statements is true about the backup?
The backup is completely unusable, under all circumstances.
The backup might be usable, so long as the database was running in ARCHIVELOG mode.
The DBA has taken a reliable NOARCHIVELOG backup of the system.
The datafiles of the backup are unusable, but the control file is.
When backing up an ARCHIVELOG database, which of the following choices identifies the factors that would significantly contribute to a rapid recovery time?
Frequency of backups, Size of datafiles & I/O speed
Available memory, I/O speed &Size of datafiles
Number of multiplexed control files
Available memory
The DBA has just finished making operating system copies of datafiles for the backup. Which of the following choices identifies how the DBA should complete the backup?
Switch online redo logs, back up control file to trace, and take tablespaces out of backup mode
Back up control file to trace, switch online redo logs, save backup control file and redo logs to tape
Take binary copy of control file, take tablespaces out of backup mode, dismount database
Take tablespaces out of backup mode, back up control file to trace, switch online redo logs
You issue the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. Which of the following choices best describes the control file backup that is made by executing this command?
A flat file script used to create the control file
A binary copy of the control file
A flat file copy of the control file
A binary script used to create the control file
The DBA doesn’t want to be bothered with backing a particular table space up anymore, because data never changes. Instead, the table space objects need to be available only for query access. Which of the following commands would be used?
ALTER DATABASE BACKUP CONTROLFILE TO TRACE
ALTER TABLESPACE READ ONLY
ALTER TABLESPACE OFFLINE
ALTER DATABASE DATAFILE END BACKUP
The DBA issues the following query: select t.name, substr(d.name,1,40) dfname, d.fuzzy from v$tablespace t, v$datafile_header d where t.ts# = d.ts#; Which of the following describes what the output in the FUZZY column will represent?
The number of blocks that are corrupt in the file
Whether the file is being backed up
Whether AUTOEXTEND has been enabled on that file
Whether blocks are being written to the file by DBWR
Description:

This test is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007
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