Test your Oracle 9i Administration Skills

In the event of corruption encountered as the result for performing checksum operations in the Oracle database, which of the following tasks must be executed in order for operation of the database to continue?
Execute the SHUTDOWN ABORT command.
Issue the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP command.
Configure the LOG_BLOCK_CHECKSUM parameter.
Run the DBVERIFY utility
With NOARCHIVELOG enabled on your Oracle database, what files are required in order to execute database recovery?
Datafiles, log files, and control file
Datafiles and archive logs
Datafiles and log files
Datafiles only
The DBA is evaluating use of RMAN in conjunction with databases running in NOARCHIVELOG mode. An advantage to recovery of a NOARCHIVELOG database using RMAN includes which of the following choices?
Storage of recovery scripts in the recovery catalog
Satisfying requirement of tracking archives for the database
Ease of use
Ability to combine restore and recover database operations into one script
An export of a database is taken with FULL=Y. Later imports performed using this dump file will be able to populate this database with all the following sets of data, except one. Which is it?
Objects belonging to a particular user schema
Information from the SYSTEM tablespace
Contents of the control file
A specific list of tables
The DBA wants to create an incremental export of the database. The export should contain a rollup of all exports taken since the last full export. Which of the following command-line options would be used to direct EXPORT for this process?
INCREMENTAL
INCTYPE
COMPLETE
SYSTEM
After recovering the recovery catalog from a backup control file, the DBA finds that many backup entries in the recovery catalog are no longer present. In order to clear out unverifiable backup items, which of the following commands are appropriate?
RESET
RESYNC
VERIFY
UNCATALOG
A backup strategy needs to be formulated for a development environment. The goal is recoverability for changes made daily to database objects and stored procedures, rather than for data. Which of the following configurations is most appropriate?
ARCHIVELOG mode in conjunction with nightly offline backups
NOARCHIVELOG mode in conjunction with nightly offline backups
ARCHIVELOG mode in conjunction with online backups twice daily
NOARCHIVELOG mode in conjunction with weekly exports
After a session makes a change to a table in the Oracle database, at what point is that change physically written to the database files?
When the transaction commits
When the user disconnects
When a checkpoint occurs
As soon as the change is made
The Oracle database is experiencing peak transaction volume. In order to reduce I/O bottlenecks created by large amounts of redo write activity, which of the following steps can be taken?
Increase the size of the rollback segments
Increase the size of the log buffer
Increase the size of the buffer cache
Increase the size of the shared pool
To prevent database corruption due to opening a database when a datafile has been restored from backup, the Oracle database employs which of the following methods?
Synchronizing datafiles headers by CKPT
Uncommitted transaction rollback by PMON
Instance recovery by SMON
Distributed transaction recovery with RECOVERY
Currently, there is only one copy of a control file for a production Oracle database. How could the DBA reduce the likelihood that a disk failure would eliminate the only copy of the control file in the Oracle database?
Copy the control file and issue the ALTER DATABASE statement.
Issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE and restart the instance.
Add another control filename to the INIT.ORA file.
Copy control file to second location and add second name and location to INIT.ORA
The DBA is considering operation of a production database in NOARCHIVELOG mode. Data recovery would be supplemented by exports of data taken about every 6 hours. Which of the following choices correctly identifies the recovery implications of this setup?
Recovery to point of failure would be faster because no archive logs would need to be applied.
Recovery to point of failure would be slower because users would have to key in up to 6 hours of lost data.
Recovery to point of failure would be impossible because exports are incompatible with NOARCHIVELOG mode.
Recovery to point of failure would be unnecessary because NOARCHIVELOG mode offers fault tolerance.
The DBA has just created a database in NOARCHIVELOG mode. Which of the following two reasons may cause him or her to leave the database in that mode for production operation?
Business requirement for point-in-time database recoveries
Medium transaction volume on the database system between backups
Low transaction volume on the database system between backups & Limited available disk space on the machine hosting Oracle
Limited available disk space on the machine hosting Oracle
The DBA has configured a production database to run in ARCHIVELOG mode and then gone home for the night. At 3 A.M., the support pager goes off. In investigating the issue, it seems that connected users cannot issue any transactions, and no additional users can connect to the database. What is the problem?
The Oracle instance crashed.
The archiver process is hung.
All online redo logs are full.
The SYSTEM tablespace has been truncated.
In archive log multiplexing environments on Oracle9i databases, which of the following parameters is used for defining the name of the archive log in the additional destination?
LOG_ARCHIVE_FORMAT
LOG_ARCHIVE_MIN_SUCCEED_DEST. 15
LOG_ARCHIVE_DUPLEX_DEST
LOG_ARCHIVE_DEST
The DBA wants to ensure interoperability for backups between Oracle and third-party backup tools such as Legato. Which of the following choices identifies the component used for this purpose?
RMAN
MML
DML
OC
Description:

This test is for anyone who is interested in learning more about Oracle9i 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

Bidyadhar Jena

i have a lot of question to

2069 days 1 hours 46 minutes ago

Venkatesh S

get knowlege

3407 days 21 hours 51 minutes ago

harsimranjit singh

itis a good way to train a person whp is going to given DBA tests.

3717 days 20 hours 41 minutes ago

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