CoolInterview.com - 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
COOLINTERVIEW.COM ORACLE INTERVIEW QUESTIONS BACKUP AND RECOVERY INTERVIEW QUESTIONS 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: CoolInterview.com
Question: Can Full Backup be performed when the database is open ?

Answer: No. Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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)
Heatmaps
Secure map rendering (role based map content display)
Support for OGC Web Feature Server themes and Annotation Text
Improved Labeling, text st Source: CoolInterview.com
Question: What is a Synonym in case of Backup and Recovery?

Answer: A Synonym is an alias for a table, view, sequence or program unit. Source: CoolInterview.com
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: CoolInterview.com
Question: What is Oracle OpenSSO Fedlet?

Answer: Oracle OpenSSO Fedlet (Fedlet) is feature of OIF 11g. It is a compact, easy to deploy SAMLv2 Service Provider implementation. It includes a small software package and a simple file-based configuration, embeddable into a Service Provider?s Java EE or .NET application. Fedlet establishes SSO between an Identity Provider and a Service Provider without requiring a fully featured federation product on the Service Provider side. Deploying Oracle OpenSSO Fedlet does not require extensive knowledge of S Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Answer: Complete database recovery from disk failure is possible only in ARCHIVELOG mode.
Online database backup is possible only in ARCHIVELOG mode. Source: CoolInterview.com
Question: What are the types of Synonyms?

Answer: There are two types of Synonyms Private and Public. Source: CoolInterview.com

1 2 3 Next



India News Network
Latest 20 Questions
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
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.109375 Seconds