Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

1237

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

1 1580

What are the limitations oracle database 10g xe?

1105

How to start an oracle instance?

1078

How to find out what oracle odbc drivers are installed?

1099

How to empty your oracle recycle bin?

1079

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

1192

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

1107

What is a server parameter file in oracle?

1108

How to use subqueries with the exists operator in oracle?

1071

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

1138

How to recover a dropped table in oracle?

1102

How to convert characters to times in oracle?

1083

Where are the settings stored for each instance in oracle?

1161

What is an oracle cursor variable?

1135

Un-Answered Questions { Oracle }

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1950

how to join query for one source type is oracle another source type is sql server ?

2484

List out the components of logical database structure of oracle database.

1098

how to do daily transactions with out sql* loader control file regesterd in apps?

1733

How should a many-to-many relationship be handled?

597

How do you recover a lost control file?

8. Supporting AP, AR and GL?

2367

How to open and close an explicit cursor in oracle?

1108

What are data pump export and import modes?

1123

What does dba stand for in technology?

591

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

1355

Is oracle a programming language?

1045

What is the finger command?

621

How to create a table index?

1236

Explain the term 'oracle grid architecture'?

635

For More Un-Answered { Oracle } Questions Click Here