Oracle 8 Backup Test

http://www.dbasupport.com/oracle/cert/bnr/


Q. 1 : Tracy is a dba for a Large Corporation. She performs a cold backup everynight and runs the database in a noarchive log mode. Which of the following recover operations can she perform
1. Recover to Point in Time when a media failure occurs
2. Recover to the Last backup when a media failure occurs
3. Use the IMP Utility to restore the database
4. None of the above

---------------------------
ans:2 : When the database is run in a noarchivelog mode, the recovery after a media failure can only be till the last cold backup.

Q. 2 : What command is used to recover the database
1. Alter Tablespace recover database
2. Alter Database Recover Database
3. Alter Database Recover
4. Create ControlFile Recover database
-------------
ans: 2

Q. 1 : What is a Backup ?
1. A Representative Copy of Data
2. It is a background process in oracle
3. It is the Standby Server that supports the Instance incase of Failure
4. None of the Above
-------
ans: 1


Q. 2 : You are the dba for a Bank . Your data is very volatile and your recover strategy requires you to recover from a media failure. What backup strategy will you use
1. Online Backup Frequently in a Archivelog mode
2. Perform cold backups every night and exports every hour
3. Backup after each transaction
4. None of the above
-------
ans: 1 : When the data is very volatile, a frequent online backup in an archivelog mode, will keep your recovery time to a minimum

Q. 3 : As a new dba, how can you test the Backup and Recovery strategy that is currently in place
1. Wait until the production system crashed and then try recovering it
2. Gather all documentation and Verify that it is correct
3. Gather Documentation and Test the strategy on a test database and verify Offsite Storage Procedures
4. Trash the old system and design a new strategy
----------------
ans: 3 : It is very important to understand the strategy that was put in place by the old dba before you want to make any changes to the backup strategy

Q. 4 : What is a DBA's primary objective when designing a strategy
1. Time of Backup
2. Tape Size and Software Cost
3. Minimizing Data Loss and Down Time due to failure
4. None of the above
-----------------
ans: 3 : Database Availability and Minimizing Downtime should be your primary goal

Q. 5 : What are the important considerations while designing a backup strategy
1. Business Requirements
2. Database / Data Availability
3. Volatile Nature of Data
4. All of the above
-----------
ans: 4

Q. 6 : What factor plays a primary role in Backup Strategy
1. Operating System
2. Tape
3. Critical Data Availability
4. Number of Employees
-------------------------
ans:3 : Data availability parameters should always be the primary factor in designing a backup and recovery strategy

Q. 8 : Which of the following are valid questions to ask when choosing a backup recovery strategy
1. Is the Data highly volatile or Static
2. Does Management understand the trade offs involved with system availability
3. How important is the data and should all transactions be guaranteed
4. All of the above
----
ans:4

Q. 10 : Which of the following depends on your Backup and Recovery Strategy

1. Database Performance
2. PL/SQL Package Performance
3. Determination of whether complete or incomplete recovery can be performed
4. None of the above
-------------------
ans: 3


Q. 11 : Why is it important to do a business requirement analysis, when you are creating a backup recovery strategy
1. Business Users have the money
2. To assess the criticality of the data and to confirm that all the resources are available from the business group
3. To resolve all the politics between Users and Developers
4. None of the above
---------
ans 2


Q. 12 : What would be your primary concern if you have very static data
1. Data Integrity
2. Database Size
3. Fault Tolerance
4. All of the above
------
ans: 3
DS: what does this mean?

BACKUP METHOD

Q. 3 : A tablespace was converted to READ-ONLY. What should you do next
1. Backup Control File and Redo Log Files
2. Backup Control File and Parameter File
3. Backup Controlfile Only
4. Backup Datafiles that make up the read only tablespace
--------------
ans: 4

Q. 4 : What command creates a script to recreate the Control File
1. Alter database backup trace to control file
2. Alter database backup create to trace
3. Alter database backup controlfile to trace
4. None of the above
--------
ans:3 : Alter database backup control file to trace produces a trace file in the DUMP_DEST. This file will contain all the commands required to recreate the control file and mount the database

Q. 5 : When an Online database backup is performed you are performing a database backup at this level
1. Table Level
2. Tablespace Level
3. Data File Level
4. Database Level
-----------------------
ans: 2 : In a hot backup scenario, you will put each tablespace in a backup mode and then backup the datafiles related to the tablespace


Q. 6 : What is the best shutdown option before a cold backup
1. FORCE
2. NORMAL
3. ABORT
4. Any of the Above
---------------------
ans:2 : A database has to be shutdown Normal or Immediate before a cold Backup. But Normal is the best way since it guarantees the consistency of the database.

Q. 7 : What is a Physical backup
1. Operating System Level backup of files without regard to logical content
2. Export of databases
3. Extract of DDL and then backup on to Tape
4. None of the above
--------------
ans: 1

Q. 8 : Online Backup Procedures are very powerful due to these reasons
1. Database remains open during backups
2. Full Point-in-time Recovery
3. All of the above
4. None of the above
-------------------
ans: 3

FAILURE SCENARY

Q. 1 : What are valid causes of User Process Failure
1. Abnormal Session Termination
2. Program Address Exception
3. Abnormal Disconnect
4. All of the above
-------------
ans: 4

Q. 2 : Tom executed a DDL statement in SQL PLUS. Oracle reported an Invalid Syntax Error. What Kind of Failure has tom experienced
1. Statement Failure
2. Instance Failure
3. Application Failure
4. Media Failure
-----------
ans:1 : A statement failure occurs when there is a logical failure due to a bad SQL statement.

Q. 5 : Which of the following are valid causes for Instance Failure
1. Power Outage
2. Hardware Problems
3. Background Process Failure
4. All of the above
-------------------------
ans: 4


Q. 6 : Tom's Database Connection was dropped due to a network Failure. What kind of Failure did tom experience now.
1. Instance Failure
2. Media Failure
3. TCP/IP Failure
4. Process Failure
----------
ans: 4 : A process failure is a failure in user process. This will not impact the system, but will not let the user continue with his work

Q. 7 : Lisa tried to enter null values in a non null column, what kind of failure would occur
1. User Process Failure
2. Instance Failure
3. Hardware Failure
4. Statement Failure
----
ans: 4



Q. 9 : What is Media Failure ?
1. The database cannot house any more audio files
2. The Hard Disk head crashed and cannot read or write to disk
3. Dba flushed the SGA
4. None of the above
------------------
ans:2 : An error can arise when trying to write or read a file that is required to operate the database. This is called disk failure because there is a physical problem reading or writing physical files on disk. A common example is a disk head crash, which causes the loss of all files on a disk drive. Different files may be affected by this type of disk failure, including the datafiles, the redo log files, and the control files. Also, because the database instance cannot continue to function properly, the data in the database buffers of the system global area cannot be permanently written to the datafiles.

Q. 11 : Zacks user process failed. What should the dba do to fix this
1. Reboot Client Machine
2. Reboot Server
3. Apply Redo Logs and then recover the database
4. None of the above
---------------------
ans: 4 : PMON will take care of the abnormally disconnected process

Q. 12 : What should you do as a DBA if the instance failed due to the failure in SMON Process
1. Reboot the Server
2. Lsnrctl start smon
3. svrmgrl startup smon
4. None of the above
--------------
ans: 4 : Restart the instance to restart SMON.


Q. 1 : What is archived log mode ?
1. Redo Logs are Not created in this mode
2. Redo Logs are Archived before they are
3. Redo Logs are overwritten before archiving them
4. None of the above
------------------------
ans: 2 : Oracle writes to the online redo log files in a cyclical fashion. After filling the first log, it writes to the second and so on. When running in ArchiveLog Mode, the ARCH process makes a copy of the log before overwriting them

Q. 3 : What happens when tablespaces are put in backup mode for hot backups
1. High Volume of REDO is generated
2. No updates to tables in that tablespace
3. All of the above
4. None of the above
----------------------
ans: 1 : When the tablespace is put in a backup mode for Hot Backups excessive redo is generated

Q. 1 : What option of Exporting allows quicker data extractions
1. Grants =y
2. Consistent =y
3. Direct = true
4. Direct=y
-----------------------
ans:4 : Direct=y option bypasses the SQL layer to allow quicker data extractions

Q. 3 : What are the 3 levels of Exports
1. GLOBAL, USER, TABLESPACE
2. FULL, USER, TABLE
3. FULL, TABLESPACE, TABLE
4. GLOBAL, LOCAL, TRANSACTIONAL
--------------------------------------------
ans: 2 : Export can be done at a Full, User and Table Level

Q. 7 : What can you do to reduce the burden on a rollback segment during the import of a large table
1. Assign a Large Rollback Segment
2. SET TRANSACTION USE ROLLBACK SEGMENT RBSLARGE
3. COMMIT=Y
4. None of the above
---------------------
ans: 3 : Commit=y will reduce the unnecessary burden on the rollback segments when importing large tables

Q. 8 : What is an Incremental Export
1. Export of the objects that have changed since last export
2. Export of rows that have changed since last export
3. Incremental Exports cannot be performed in Oracle
4. None of the above
------------
ans: 1

Q. 9 : An Incremental Export is a good strategy for
1. Applications with few large tables and less data changes
2. Applications where changes are scattered across small tables
3. All of the above
4. None of the above
-----------
ans: 2

Q. 14 : What sequence is followed during an import
1. Tables, Indexes, Triggers, Constraints
2. Tables, Triggers, Constraints, Indexes
3. Tables, Indexes, Sequences, Constraints, Triggers
4. None of the above
----------------------
ans: 1

Q. 15 : Which step of the query process is by passed by direct-path export
1. SQL Command Processing Layer
2. Space Management
3. Buffer Cache
4. All of the above
-------------
ans: 1

Q. 17 : Data Loss can occur if you use an Export / Import Strategy Because
1. Rollback Segment contents are Not written to the Export file
2. Archive Log Contents Cannot be Applied After an Import
3. Export may fail due to Referential Integrity constraints
4. None of the above
--------------------
ans: 2


Q. 23 : How can you create a file containing the scripts to create indexes from the export
1. Using the INDEXFILE Option
2. Using the INDEXES option
3. All of the above
4. None of the above
-----------
ans:1 : INDEXFILE option can be used during imports to create a file of Index and Table creation scripts.
-------------