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

Oracle General Interview Questions

Questions Answers Views Company eMail

Can we commit inside a function in oracle?

972

What is a schema in oracle?

1026

What is bulk load in oracle?

1078

What happens in oracle commit?

1033

What are operators in oracle?

1064

What is bind variable in oracle 11g?

1041

What is private procedure oracle?

1016

How many types of tables are there in oracle?

1064

What is parameterized cursor in oracle?

1159

How do I spool in oracle?

1016

How do I recompile a procedure in oracle?

971

Can we call procedure inside function in oracle?

1102

What are the data types in oracle?

1046

What is set verify off in oracle?

1108

What is oracle data type?

973

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert a string to a date in oracle database?

1058

What happens if you use a wrong connect identifier?

1073

What is a snapshot in oracle database?

1029

What is a schema in oracle?

1026

What is the difference between count (*), count (expression), count (distinct expression)?

1013

How many types of cluster table in Oracle?

1036

What is connection pool in oracle?

993

Explain the use of parfile option in exp command.

1074

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2834

Why is oracle so popular?

1009

How many types of database triggers exist?

1144

What is a cursor in oracle?

1186

How to view all columns in an existing table?

941

How to establish administrator authentication to the server?

1050

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1388

For More Un-Answered { Oracle General } Questions Click Here