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 import one table back from a dump file?

1025

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

1073

How to invoke the data pump export utility?

1187

How to define an anonymous block?

1157

How to list all tables in your schema?

1053

How to use "in out" parameter properly?

1048

How to use windows user to connect to the server?

988

How to execute a stored program unit?

1074

How to load data from external tables to regular tables?

1062

What happens to the current transaction if a ddl statement is executed?

1013

How to drop a tablespace?

1043

How to retrieve the count of updated rows?

1127

What happens to the indexes if a table is recovered?

993

How to get execution path reports on query statements?

987

How to add another datafile to a tablespace?

1040

Un-Answered Questions { Oracle }

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What is system global area (sga) in oracle?

991

Respected sir, Please send me technical questions related to oracle apps..

1813

What is the full form of dba?

602

What are the main benefits of using spfile over pfile?

641

What is a nested table and how is it different from a normal table?

1050

How to use attributes of the implicit cursor in oracle?

1008

What is set verify off in oracle?

1102

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

What is oracle d2k? Why we use it?

How to use group functions in the select clause using oracle?

1072

What are the constraints are used in Ur project?

550

defination of bitmap index

2124

Explain how can you use the same lov for 2 columns?

1128

What is Trigger in Oracle?

1171

For More Un-Answered { Oracle } Questions Click Here