Skip to main content

The Oracle Server

The Oracle Server consists of an Oracle instance and an Oracle database.

Oracle instance: Is a means to access an Oracle database. Its Always opens one and only one database. An Oracle instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a system global area (SGA) is allocated and Oracle background processes are started.The SGA is a memory area used to store database information that is shared by database processes.

Oracle database: An Oracle database is a collection of data that is treated as a unit. The general purpose of a database is to store and retrieve related information. The database has a logical structure and a physical structure. The physical structure of the database is the set of operating system files in the database.

Comments

Post a Comment

Popular posts from this blog

Oracle Developer Technical Interview Questions

Here i am putting all the questions i had faced during my interviews ... Interview at “3i InfoTech”, Chennai:  1) What is flow of execution of WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, and WHEN-NEW-ITEM-INSTANCE? 2) What is PRE-QUERY and POST-QUERY? When these triggers will fire? 3) If the object library with some blocks and triggers if a form inherited that object library if u doesn’t need some trigger to be inherited the can u delete that trigger from that form? 4) How u can call a report from a form? Which property u has set in runtime? 5) If u create a relation between two blocks in the form what are all triggers it will create? 6) What is a ref cursor? 7) To call a form which type of built-ins u has to use? 8) What is the main difference between expand and variable property for a text item in reports. 9) In a report layout there is accepted and rejected fields and it has a parameter when u run the report based on the parameter the output should sh...
Post a Comment
Read more

Communicating with a RDBMS Using SQL

What is SQL? SQL Stands for Structured Query Language. I t is the  international  standard language for relational database management systems. It is useful for  accessing and manipulating data in a databases.  To access the database, you execute a structured query language (SQL) statement, which is the American National Standards Institute (ANSI) standard language for operating relational databases.
Post a Comment
Read more

INDEX Definition

In Oracle, an  INDEX  is a database object intended to improve the performance of  SELECT  queries. Indexes are created on table columns, and the index stores all the values of the column under index segments. If the  SELECT  query uses an indexed column in any of the  WHERE  conditions, the query uses the index segment instead of performing a full table scan. This results in enhanced query performance.
Post a Comment
Read more