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

How to change user password in oracle?

1029

How to create a new user account in oracle?

1020

How to start a specific oracle instance?

1037

What is a dead lock in oracle?

1122

What are the differences between char and varchar2 in oracle?

1170

How to pass a parameter to a cursor in oracle?

1179

How to create a stored procedure in oracle?

1103

How to return top 5 rows in oracle?

1062

How to select some columns from a table in oracle?

1093

How to concatenate two text values in oracle?

1113

What is a data lock in oracle?

1119

What privilege is needed for a user to connect to oracle server?

994

What is an oracle user role?

984

How to download oracle database 10g xe?

1018

How to join two tables in a single query using oracle?

997

Un-Answered Questions { Oracle }

what are the oracle forms services components include?

1024

Were you involved in any data conversion, which one?

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2467

Explain what are the characteristics of data files?

1085

How to pass parameters to procedures?

1034

Explain a synonym?

1029

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

Is truncate autocommit in oracle?

1087

What database block size should I use?

733

How can we generate report output in excel format?

997

How to drop a tablespace?

1043

How to create additional tablespaces for an new database?

1027

Explain the various types of canvas in form.

How do I connect to oracle?

1030

How to declare a local variable?

1115

For More Un-Answered { Oracle } Questions Click Here