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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain the difference between sap and oracle?

978

What is oracle join syntax?

946

When system tablespace is created?

973

What are the database administrators utilities available?

976

What is system tablespace?

1045

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

975

How does one get the view definition of fixed views/tables?

969

What is a snapshot log?

957

Can objects of the same schema reside in different tablespace?

1002

How index is implemented in oracle database?

947

How are extents allocated to a segment?

1065

What are the attributes of cursor?

992

What are set operators?

1035

What is blob datatype?

1060

What are a cluster and non-cluster index?

959

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is archive log in Oracle?

1073

What suggestions do you have to reduce the network traffic?

905

What is a proxy object?

1012

Explain the blob datatype?

1018

Can we create database in oracle using command line ?

1032

Why should I use oracle database?

948

What is logical backup in oracle?

969

How to experiment a data lock in oracle?

1003

How to lock and unlock a user account in oracle?

1030

How to put more than 1000 values into an oracle in clause?

974

Explain the use of owner option in exp command.

994

What is a package in oracle?

1030

How to update values in a table in oracle?

964

How to get the Installed Oracle Version Information ?

1077

What is a tns service name?

947

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