- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Backup and Recovery Interview Questions & Answers - Learning Mode

Backup and Recovery Interview Questions & Answers - Learning Mode

Backup and recovery is one of the most important aspects of database administration. If a database crashed and there was no way to recover it, the devastating results to a business could include lost data, lost revenue and customer dissatisfaction.

Try Backup and Recovery Interview Questions & Answers - Exam Mode

1 2 3 Next

Sort By : Latest First | Oldest First | By Rating

Backup and Recovery Interview Questions & Answers - Learning Mode
Try Backup and Recovery Interview Questions & Answers - Exam Mode
Question: What are the steps involved in Database Startup ?

Answer: Start an instance, Mount the Database and Open the Database. Source:
Question: How to check RMAN version in Oracle?

Answer: If you want to check RMAN catalog version then use the below query from SQL*plus
SQL> Select * from rcver; Source:
Question: What is the steps for recovery of missing data file? and the steps for physical stand by database creation?

Answer: Shut down the database and start mount then recreate the d.b by using recreation using old data file path. Source:
Question: What is Log Switch ?

Answer: The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. Source:
Question: What are the different modes of mounting a Database with the Parallel Server ?

Answer: Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.
Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database. Source:
Question: Can Full Backup be performed when the database is open ?

Answer: No. Source:
Question: What are the new features in MapViewer 11g?

Answer: Certification on WebLogic Server version 10 and 10.3
Powerful and open JavaScript/AJAX mapping API for interactive client side mapping
Support for Safari desktop browser
Support for ESRI Shape Files
Support for Google Map tiles (requires a Google Maps API key)
Interface for 3rd party map tile servers (in JavaScript API)
Secure map rendering (role based map content display)
Support for OGC Web Feature Server themes and Annotation Text
Improved Labeling, text st Source:
Question: What is SYSTEM tablespace and when is it created?

Answer: Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. Source:
Question: Explain the relationship among database, tablespace and data file.

Answer: Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace. Source:
Question: What is the difference between HOTBACKUP and RMAN backup?

Answer: For HOTBACKUP we have to put database in begin backup mode, then take backup where as RMAN would not put database in begin backup mode. RMAN is faster can perform incremental (changes only) backup, and does not place tablespace in HOTBACKUP mode. Source:
Question: What is Mirrored on-line Redo Log ?

Answer: A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members. Source:
Question: What are the types of Synonyms?

Answer: There are two types of Synonyms Private and Public. Source:
Question: What is Oracle Identity Federation 11g?

Answer: Oracle Identity Federation 11g delivers the industry?s most comprehensive implementation of federation standards delivered via Oracle Universal Federation Framework ? unified, extensible and customizable architecture for rapid deployment in any multi-vendor environment.

OIF is the only federation solution on the market that comes deployed on a complimentary Oracle WebLogic ? best-of-breed application server container in a default configuration.

Additionally, OIF 11g is the only fed Source:
Question: What is an Oracle index?

Answer: An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table. Source:
Question: When can hash cluster used?

Answer: Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows. Source:
Question: What is the difference between Complete and Incomplete Recovery?

Answer: An incomplete database recovery is a recovery that it does not reach to the point of failure. The recovery can be either point of time or particular SCN or Particular archive log specially incase of missing archive log or redolog failure where as a complete recovery recovers to the point of failure possibly when having all archive log backup. Source:
Question: How to put Manual/User managed backup in RMAN?

Answer: By using catalog command:
RMAN> CATALOG START WITH ?/oracle/backup.ctl?; Source:
Question: What is the use of Control File?

Answer: When an instance of an Oracle database is started, its Control File is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery. Source:
Question: What is Partial Backup ?

Answer: A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down. Source:
Question: What is fractured Block?

Answer: Because the database continues writing to the file during an online backup, there is the possibility of backing up inconsistent data within a block. For example, assume that either RMAN or an operating system utility reads the block while database writer is in the middle of updating the block. In this case, RMAN or the copy utility could read the old data in the top half of the block and the new data in the bottom top half of the block. The block is a fractured block, meaning that the data in th Source:

1 2 3 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds