- 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: 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 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: Can Full Backup be performed when the database is open ?

Answer: No. 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: 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: 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 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: 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 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: 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 is a Logical Backup?

Answer: Logical backup means backing up the database objects like tables, views , indexes...etc using the EXPORT utility given by Oracle. The objects exported in this way can be imported into either same database or into any other database. Source:
Question: What are the types of Synonyms?

Answer: There are two types of Synonyms Private and Public. Source:
Question: Who should upgrade to Oracle Universal Federation Framework 11g?

Answer: Customers who wish to take advantage of 11g?s new unified Oracle Universal Federation Framework
Customers who wish take advantage of complimentary enterprise-class tools for system management, monitoring, auditing and reporting
Customers who want to rapidly SSO-enable their federation partners using OpenSSO Fedlet
Customers looking to accept identity from leading OpenID providers (Google, Yahoo, etc.) or interested in becoming an OpenID provider
Customers who prefer to deploy OIF on 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 MapViewer?

Answer: MapViewer is a Java-based visualization tool that is used to render, in map form, location based content and spatial data stored using the spatial feature of Oracle Database. It includes It can also render map and related content from ESRI Shape Files, real-time XML feeds such as GeoRSS, and geographic web services including themes from OpenGeospatial Consortium Web Feature Services. 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 Restricted Mode of Instance Startup ?

Answer: An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege. Source:
Question: How to put Manual/User managed backup in RMAN?

Answer: By using catalog command:
RMAN> CATALOG START WITH ?/oracle/backup.ctl?; 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.078125 Seconds