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?

983

How to create a new user account in oracle?

977

How to start a specific oracle instance?

1008

What is a dead lock in oracle?

1062

What are the differences between char and varchar2 in oracle?

1098

How to pass a parameter to a cursor in oracle?

1124

How to create a stored procedure in oracle?

1042

How to return top 5 rows in oracle?

1008

How to select some columns from a table in oracle?

1023

How to concatenate two text values in oracle?

1071

What is a data lock in oracle?

1051

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

960

What is an oracle user role?

948

How to download oracle database 10g xe?

968

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

947

Un-Answered Questions { Oracle }

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

549

What is the difference between instance recovery and crash recovery?

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

978

How many control files should you have?

559

How to create additional tablespaces for an new database?

989

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

951

How do we represent comments in oracle?

1009

What is the sequence of firing in form level trigger?

What is recovery manager in Oracle?

1009

How to create a new view in oracle?

1025

What are the components required to manage oracle real application clusters database?

How to use "while" statements in oracle?

1257

Difference between lexical and bind varible.

What is end user in database?

556

What is a sub query? What are its various types?

1104

For More Un-Answered { Oracle } Questions Click Here