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 are data pump export and import modes?

1068

How to generate query output in html format?

1118

Can sub procedure/function be called recursively?

1003

What happens if recursive calls get out of control?

1082

How to get a list of all background sessions in the database?

993

How to get execution statistics reports on query statements?

1094

How to shutdown your 10g xe server from command line?

1086

How to export your connection information to a file?

1131

How to shutdown your 10g xe server?

1149

How a tablespace is related to data files?

1109

Where is the export dump file located?

1158

What are the original export and import utilities?

1170

What is a connect identifier?

1039

How to view all columns in an existing table?

936

What is an anonymous block?

1250

Un-Answered Questions { Oracle }

What are the different types of failures that occur in Oracle database?

1067

How to view the tablespaces in the current database?

978

How translate command is different from replace?

1086

How to turn on or off recycle bin for the session?

1109

How to convert csv to table in oracle?

990

What are the functions of administration?

555

How to create a new table in oracle?

1156

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

IS it possible to built the oracle database without setting the kernal parameters?

2348

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

Explain how you would restore a database using RMAN to Point in Time?

2145

How can we expand Parameter Form Canvas on Reports 6i?

2425

Explain constraining triggers.

1095

How to create a stored procedure in oracle?

1103

What is File steps?

619

For More Un-Answered { Oracle } Questions Click Here