Database

Topic: Basic

What are the Back ground processes in Oracle and what are they. 

This is one of the most frequently asked question.There are basically 9 Processes but in a general system we need to mention the first five background processes.They do the house keeping activities for the Oracle and are common in any system.The various background processes in oracle area) Data Base Writer(DBWR) :: Data Base Writer Writes Modified blocks from Database buffer cache to Data Files.This is required since the data is not written whenever a transaction is committed.b)LogWriter(LGWR) :: LogWriter writes the redo log entries to disk. Redo Log data is generated in redo log buffer of SGA. As transaction commits and log buffer fills, LGWR writes log entries into a online redo log file.c) System Monitor(SMON) :: The System Monitor performs instance recovery at instance startup. This is useful for recovery from system failured)Process Monitor(PMON) :: The Process Monitor performs process recovery when user Process fails. Pmon Clears and Frees resources that process was using.e) CheckPoint(CKPT) :: At Specified times, all modified database buffers in SGA are written to data files by DBWR at Checkpoints and Updating all data files and control files of database to indicate the most recent checkpointf)Archieves(ARCH) :: The Archiver copies online redo log files to archival storal when they are busy.g) Recoveror(RECO) :: The Recoveror is used to resolve the distributed transaction in networkh) Dispatcher (Dnnn) :: The Dispatcher is useful in Multi Threaded Architecturei) Lckn :: We can have upto 10 lock processes for inter instance locking in parallel sql.

Browse random answers:

Explain the storage models of OLAP
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Are there any undocumented commands in Oracle? (for DBA)
What is the function of Optimizer ?
What is Execution Plan ? 
Can one resize tablespaces and data files? (for DBA) 
What is SAVE POINT ? 
BETWEEN ... AND operators in SQL.
Explain acid properties?
What is ACID property?
Which SQL Server database does not follow ACID properties?
What is rollback and roll forward?
How can one recover the database via reprocessing?
How to check whether the product is install,shared and Not installed in Apps.?
How to find a file version in Application DB:
What are the real time problems you have encountered and how you trouble shooted that?
What is an Oracle instance?
What is referential integrity?
Why Use Sql* Loader in Oracle Database?
How does one create a standby database? (for DBA) 
How does one give developers access to trace files (required as input to tkprof)? (for DBA) 
What are the responsibilities of a Database Administrator ? 
What is a trace file and how is it created ? 
What are the roles and user accounts created automatically with the database? 
What are the minimum parameters should exist in the parameter file (init.ora) ? 
Why and when should I backup my database? (for DBA)
What strategies are available for backing-up an Oracle database? (for DBA)
What is a Query Record Group? 
Give the stages of instance startup to a usable state where normal users may access it. 
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. 
What is the difference between the SQL*Loader and IMPORT utilities? 
What are the different types of segments?
What is a data segment? 
What is an index segment? 
What is rollback segment? 
What are the uses of rollback segment? 
What is a temporary segment? 
What is a datafile? 
What are the characteristics of data files? 
What is a redo log? 
What is the function of redo log? 
What is the use of redo log information? 
What does a control file contains? 
What is the use of control file? 
Explain the difference between a hot backup and a cold backup and the benefits associated with each. 
Explain the difference between a data block, an extent and a segment. 
Compare and contrast TRUNCATE and DELETE for a table. 
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each? 
How many types of columns are there and what are they 
Describe Referential Integrity ? 
What is row chaining? 
How to define data block size? 
What is path setting for DLL? 
What are key-mode and locking mode properties? level ? 
What does invoke built-in do? 
What are OPEN_FORM,CALL_FORM,NEW_FORM? diff? 
Diff. between VAT and Property Class? 
Which trigger related to mouse? 
What is Current record attribute property? 
What are the steps involved in Database Startup 
which system variables can be set by users? 
What are referenced objects? 
Can you store objects in library? 
Can you issue DDL in forms? 
What are the types of triggers and how the sequence of firing in text item 
What are record groups ? * Can record groups created at run-time? 
What are ALERT? 
Table Space,Data Files,Parameter File, Control Files 
What is a 2 Phase Commit 
What is pseudo columns ? Name them? 
What are Database Triggers and Stored Procedures 
What are the Different Optimization Techniques 
How does one create and drop database users? 
How does one stop and start the OMS? (for DBA)
What is CYCLE/NO CYCLE in a Sequence ? 
What are the Back ground processes in Oracle and what are they. 
How many types of Sql Statements are there in Oracle 
What are different Oracle database objects? 
What are the cursor attributes used in PL/SQL ? 
Find out nth highest salary from emp table 
Explain the difference between a data block, an extent and a segment.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
How do you increase the performance of %LIKE operator?  
What is Cache Fusion Technology?  
What is simple replication and advance replication?  
How are the indexes updated? 
How many memory layers are in the oracle shared pool? Explain them  
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?  
Explain the concept of the DUAL table.  
What are the ways tablespaces can be managed and how do they differ?  
Explain what are Oracle Catalog and Oracle Archive log?  
What are PCT Free and PCT Used? What is PCT increase parameter in segment?
What is dump destination? What are bdump, cdump and udump?
What is the difference between Cloning and Standby databases?  
What is Materialized views? Explain its uses.
Why and how the deadlock situation arises? 
What are the steps to take to improve performance of a poor performing query?
What is blocking and how would you troubleshoot it?