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 5769

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

2 11225

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

3 5785

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 8189

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

3 4631

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

2 7942

what is debit memo and credit memo in AR?

1 4045

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 4598

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 5345

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6015

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

Mphasis,

5 15970

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 7097

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 4667

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

1950

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

1 6503

Un-Answered Questions { Oracle }

What is oracle forms system.currentblock?

When do you get a .pll extension in oracle? Explain its importance

1045

What are the file systems and volume management techniques used in oracle rac?

How to filter out duplications in the returning rows using oracle?

1020

how to handle exceptions?

609

How many segment are present in Oracle Manufacturing

2321

Which profile required to access solution in Designer tool?

592

from where do u receive the information to develop report

2015

What does dba stand for database?

606

How can you find your id on a system?

569

What are the different types of record groups in oracle? Explain each of them

1028

Explain what are the different type of segments?

970

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2353

What are the different types of backups that are available in oracle?

Can we store images in oracle database?

1013

For More Un-Answered { Oracle } Questions Click Here