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 the difference between formal parameters and actual parameters?

1088

How to view the dropped tables in your recycle bin?

1 1480

How to define an anonymous procedure without variables?

1107

How many data types are supported?

1079

How to connect to the server with user account: sys?

1017

How to define default values for formal parameters?

1044

What are the restrictions on external table columns?

1052

What privilege is needed for a user to insert rows to tables in another schema?

1015

How to loop through data rows in the implicit cursor?

1073

How to create additional tablespaces for an new database?

1027

How many categories of data types?

995

Can you assign multiple query result rows to a variable?

987

How to use fetch statement in a loop?

1019

What is the use of the drop option in the alter table command?

596

How do you use automatic pga memory management with oracle 9i and above?

589

Un-Answered Questions { Oracle }

How to check your oracle database 10g xe installation?

986

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1391

Mention in rac what files should be created on shared storage?

What is the use of the Service Knowledge module?

588

What is end user in database?

597

What is a private synonym?

1588

What do you understand by oracle forms and why are they required?

1019

How to rename an existing table?

1129

Explain enable novalidate constraint.

1080

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

1065

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

638

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2163

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2185

In the oracle version 9.3.0.5.0, what does each number shows?

1301

Why do we need a database?

595

For More Un-Answered { Oracle } Questions Click Here