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

Oracle General (1809)
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?

1003

Can objects of the same schema reside in different tablespace?

1062

How index is implemented in oracle database?

1006

How are extents allocated to a segment?

1125

How does one create a new database?

589

What database block size should I use?

732

How does one coalesce free space?

550

What are the attributes of cursor?

1054

What are set operators?

1082

What is blob datatype?

1128

What are a cluster and non-cluster index?

1018

How do we create privileges in oracle?

1045

State and explain about oracle instance?

991

What is the data type of dual table?

995

What is using clause and give example?

1044

Un-Answered Questions { Oracle }

Explain what are synonyms used for?

1034

how to write the procedures in odi?

727

What is oracle d2k? Why we use it?

How to check the server version in oracle?

1092

What is odi studio?

586

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2279

How many types of tables supported by oracle?

1076

How to convert numbers to characters in oracle?

1030

What to do if the binary spfile is wrong for the default instance?

1069

What privilege is needed for a user to create tables in oracle?

953

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2183

How to loop through data rows in the implicit cursor?

1073

What happens if you set the sga too low in oracle?

1149

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1695

How can we tune a sql query to optimize the performance of a database?

For More Un-Answered { Oracle } Questions Click Here