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 to connect to a local oracle 10g xe server?

939

How to use subqueries with the in operator using oracle?

1033

Can select statements be used on views in oracle?

985

How to use "while" statements in oracle?

1233

How to sort the query output in oracle?

970

How to use null as conditions in oracle?

1003

How to use "for" statements in oracle?

1019

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

1025

What is transport network substrate (tns) in oracle?

994

How to write a left outer join with the where clause in oracle?

1027

How to count duplicated values in a column in oracle?

985

What are the differences between char and nchar in oracle?

1022

How to install oracle odbc drivers?

1041

What is a table index in oracle?

1071

How to grant create session privilege to a user in oracle?

948

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the types of trigger in oracle?

917

How to get execution path reports on query statements?

930

Give the various rollback segment states.

1000

Please explain joins in oracle?

1009

How to convert characters to numbers in oracle?

1001

What are the ways tablespaces can be managed and how do they differ?

2274

What are transaction isolation levels supported by oracle?

997

What is tns name?

928

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

996

What is a schema in oracle?

968

please explain.. DB architecture ...

1968

Why do we use bulk collect in oracle?

1012

What is oracle server autotrace in oracle?

1091

Explain the dml?

921

How to declare a local variable?

1055

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