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

What is null value in oracle?

1052

How to create an oracle testing table?

1021

How to rebuild an index in oracle?

990

What is oracle open database communication (odbc)?

981

What are the restrictions in a oracle read only transaction?

985

What is an oracle database?

1005

What privilege is needed for a user to create views in oracle?

998

How to write a query with a right outer join in oracle?

1130

How to experiment a data lock in oracle?

1012

How to write text literals in oracle?

1034

How to convert times to characters in oracle?

995

How to install oracle database 10g xe?

977

How to change program global area (pga) in oracle?

1045

How to convert numbers to characters in oracle?

988

How to delete a column in an existing table in oracle?

1029

Un-Answered Questions { Oracle }

What are the database administrators utilities available?

988

What do you mean by oracle dba?

526

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2190

Can select statements be used on views in oracle?

1002

How to use attributes of the implicit cursor in oracle?

965

What is sequence?

1027

What do you mean by merge in oracle?

951

What is oracle d2k? Why we use it?

from where do u receive the information to develop report

1974

What happens if the update subquery returns multiple rows?

1067

What do you mean by sga and how is it different from pga?

how report can be generated if we have the database designed in oracle 10g?

1848

What do you mean by a database transaction & what all tcl statements are available in oracle?

951

Which profile required to access Models in Designer tool?

675

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2099

For More Un-Answered { Oracle } Questions Click Here