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?

1045

State and explain about oracle instance?

991

What is the data type of dual table?

991

What is using clause and give example?

1035

Explain about achiever in sql?

1032

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

1011

What are temporal data types in oracle?

1120

What is a relational database management system?

1119

What is difference between cartesian join and cross join?

1085

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

1078

Are truncate and delete commands same? If so why?

1148

How do we get field details of a table?

978

What is varray?

1130

What is a cursor variable?

1124

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

1036

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1069

Explain an index?

1130

How to delete all rows a table in oracle?

1067

What is SQL Tuning Advisor in Oracle?

1173

What is a cursor variable?

1124

What is Redo Log Buffer in Oracle?

1201

How to test null values?

1102

How do I know if oracle is installed on windows?

929

How do I escape a reserved word in oracle?

1195

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

Explain the use of parfile option in exp command.

1064

What is the difference between post-database commit and post-form commit?

1191

How to pass parameters to procedures?

1028

Can you drop an index associated with a unique or primary key constraint?

1017

What is the sql query to concatenate column values from multiple rows in oracle?

1054

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