Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 16 of 95
149. What are the steps involved in Instance Recovery ? R_olling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process at the time of the failure. Resolving any pending distributed transactions undergoing a two- phase commit at the time of the instance failure. Data Base Administration Introduction to DBA 1. What is a Database instance ? Explain A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The memory structure that are used to store most queried data from database. This helps up to improve database performance by decreasing the amount of I/O performed against data file. 2. What is Parallel Server ? Multiple instances accessing the same database (Only In Multi-CPU environments) 3. What is a Schema ? The set of objects owned by user account is called the schema. 4. What is an Index ? How it is implemented in Oracle Database ? An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0) 5. What is clusters ? Group of tables physically stored together because they share common columns and are often used together is called Cluster. 6. What is a cluster Key ? |