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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is a snapshot log?

1054

Can objects of the same schema reside in different tablespace?

1107

How index is implemented in oracle database?

1051

How are extents allocated to a segment?

1184

How does one create a new database?

642

What database block size should I use?

776

How does one coalesce free space?

599

What are the attributes of cursor?

1111

What are set operators?

1144

What is blob datatype?

1203

What are a cluster and non-cluster index?

1071

How do we create privileges in oracle?

1103

State and explain about oracle instance?

1053

What is the data type of dual table?

1071

What is using clause and give example?

1109

Un-Answered Questions { Oracle }

What are set operators?

1144

Difference between Row Id and Row Num?

732

where do u put the report file

2137

Difference between oracle's plus (+) notation and ansi join notation?

1160

What is a nested table and how is it different from a normal table?

1115

What is SKM and when we will use this SKM?

722

How many anonymous blocks can be defined?

1260

How to turn on or off recycle bin for the instance?

1133

How to define a record variable to store a table row?

1113

How to load a large xml file?

1110

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2967

How to clone the database using RMAN back

2323

What is current record attribute property?

what is oracle forms?

1164

Any work done in oracle workflow builder. Did you customize or build a new workflow?

For More Un-Answered { Oracle } Questions Click Here