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?

1029

What is oracle join syntax?

1001

When system tablespace is created?

1036

What are the database administrators utilities available?

1027

What is system tablespace?

1091

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?

1040

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

1019

What is a snapshot log?

1000

Can objects of the same schema reside in different tablespace?

1060

How index is implemented in oracle database?

1002

How are extents allocated to a segment?

1124

What are the attributes of cursor?

1048

What are set operators?

1079

What is blob datatype?

1124

What are a cluster and non-cluster index?

1018

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain user account with reference to oracle.

977

Explain about your project and its relation to the current job position you are applying to?

1004

What is a oracle database?

1053

How to export data to a csv file?

1297

Explain the use of record option in exp command.

999

What is a partition in oracle?

1118

Why do we need integrity constraints in a database?

1017

What are the most common interview questions on ETL Testing for experience?

1140

How would you change old and new values in an insert, delete and update triggers?

1019

What is the usage of control file in oracle?

1082

List out the types of joins.

1152

What is coalesce function?

1068

What is the database name in oracle?

1018

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1424

What is data type in oracle?

1118

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