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

Oracle General Interview Questions

Questions Answers Views Company eMail

How do we create privileges in oracle?

995

State and explain about oracle instance?

936

What is the data type of dual table?

925

What is using clause and give example?

1001

Explain about achiever in sql?

981

What are a query and state the different types of queries and their uses?

947

What are temporal data types in oracle?

1070

What is a relational database management system?

1068

What is difference between cartesian join and cross join?

1021

Explain the difference between a procedure and a function? What do you understand by those terms?

1026

Are truncate and delete commands same? If so why?

1083

How do we get field details of a table?

936

What is varray?

1040

What is a cursor variable?

1050

Can we store pictures in the database and if so, how it can be done?

990

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain alias?

1084

Does oracle database need java?

948

Why do you use stored procedures and state some of its disadvantages?

975

What happens to the data files if a tablespace is dropped?

1000

How to define an oracle cursor variable?

980

What is difference between truncate and delete?

980

What are the attributes that are found in a cursor?

1015

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2264

What is an Oracle Instance?

1075

What is translate in oracle?

1053

What is partitioned table in Oracle?

1112

How to recover a dropped table in oracle?

986

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

1027

How to export data to a csv file?

1212

Write a syntax for update query in oracle?

975

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