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 an oracle transaction?

1146

How to find out what privileges a user currently has in oracle?

1 1514

What are the limitations oracle database 10g xe?

1046

How to start an oracle instance?

1019

How to find out what oracle odbc drivers are installed?

1042

How to empty your oracle recycle bin?

1022

How to add a new column to an existing table in oracle?

1139

How to select all columns of all rows from a table in oracle?

1053

What is a server parameter file in oracle?

1059

How to use subqueries with the exists operator in oracle?

1027

How to use values from other tables in update statements using oracle?

1080

How to recover a dropped table in oracle?

1048

How to convert characters to times in oracle?

1023

Where are the settings stored for each instance in oracle?

1105

What is an oracle cursor variable?

1076

Un-Answered Questions { Oracle }

i am writing a query select EmpNo from Emp how can i call in after parameter form

2127

How many types of table in Oracle?

1124

How is clustered database important in oracle rac architecture?

What is oracle data type?

964

What do you mean by merge in oracle and how can we merge two tables?

1049

What is a snapshot in oracle database?

1025

What happens if a tablespace clause is left off of a primary key constraint clause?

581

What is coalesce function?

1074

Please explain joins in oracle?

1062

Can we protect our pl/sql source code?

1045

Explain for repository?

588

Explain the use of full option in exp command.

1116

How to convert characters to numbers in oracle?

1065

How do I reset a sequence in oracle?

1098

Explain oracle insert into command?

1115

For More Un-Answered { Oracle } Questions Click Here