Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Microsoft,

2 5898

what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item

2 11323

how to get count of tables in particular database in Oracle?

3 5920

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

Cap Gemini,

4 8375

the user should know to which database he is connected currently in oracle

3 4752

what is meant by physical order and logical order in clustered index and non clustered index.

2 8053

what is debit memo and credit memo in AR?

1 4167

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

IBM,

1 4663

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

IBM,

1 5413

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6147

In Oracle 10g, "g" Stands for what?

Mphasis,

5 16223

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 7232

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 4763

what is port in oracle? how is it related to database application.

1996

what is host string in sql plus? how does it related to database?

1 6593

Un-Answered Questions { Oracle }

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2067

What are the differences between char and varchar2 in oracle?

1251

Mention what are the benefits of oracle rac?

How is rman better than user-managed backup recovery process?

what are bitmap indexes? How does they work?

2311

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1348

How can you find dead processes?

586

How to check the server version in oracle?

1145

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2044

How to use subqueries with the in operator using oracle?

1142

How to define a procedure inside another procedure?

1072

List five most important parameter in 9i affecting performance?

610

What are the attributes that are found in a cursor?

1126

What are the different windows events activated at runtime ?

2950

Please explain oracle data types with examples?

1132

For More Un-Answered { Oracle } Questions Click Here