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

Oracle General (1809)
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 5753

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

2 11209

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

3 5762

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 8155

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

3 4598

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

2 7928

what is debit memo and credit memo in AR?

1 4040

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 4576

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 5326

What is the difference between SQL and SQL Server?

CTS, TCS,

2 5980

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

Mphasis,

5 15940

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 7071

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 4647

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

1943

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

1 6480

Un-Answered Questions { Oracle }

Differentiate between post-database commit and post-form commit?

1031

can you convert or reverse engineer a fmx back to a fmb file?

1157

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2137

What is the difference between restoring a database and recovering a database?

Give the different types of rollback segments.

1026

State all possible different index configurations a table can possibly have?

994

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2493

What are the limitations of check constraint?

1022

How to count groups returned with the group by clause in oracle?

1070

Can sub procedure/function be called recursively?

993

How to unlock the sample user account in oracle?

1007

What are the attributes of cursor?

1046

please explain.. DB architecture ...

2016

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1010

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

582

For More Un-Answered { Oracle } Questions Click Here