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

Is oracle a programming language?

985

Is truncate autocommit in oracle?

1084

Why we use bulk collect in oracle?

1044

What is procedure overloading in oracle?

1060

Is oracle a language?

944

How do you bind variables in oracle?

980

Is insert autocommit in oracle?

1068

What is data type in oracle?

1123

Why packages are used in oracle?

1066

Can we commit inside a function in oracle?

963

What is a schema in oracle?

1012

What is bulk load in oracle?

1069

What happens in oracle commit?

1024

What are operators in oracle?

1053

What is bind variable in oracle 11g?

1039

Un-Answered Questions { Oracle }

difference of using cursor for loop and open,fetch,close.which one is better

1805

What do you mean by dba?

572

What is the difference between alert log file and tarce file ?

2172

what is normalisation?what are its uses?

2273

What is supporting issues GL AP and AR?

2549

What is memory advisor in Oracle?

1077

How a database is related to tablespaces?

1031

What is ODI console?

671

Which function is used to find the largest integer less than or equal to aspecific value?

564

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2122

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

List out the types of joins.

1157

How do I uninstall oracle 11g?

1117

What is the difference between bind and lexical parameter?

1077

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2319

For More Un-Answered { Oracle } Questions Click Here