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

Why do we use coalesce function in oracle?

1169

What is the quickest way to fetch the data from a table?

1104

How translate command is different from replace?

1144

How will you differentiate between varchar & varchar2?

1089

What are the set operators union, union all, minus & intersect meant to do?

1038

What is a nvl function? How can it be used?

1100

What is the use of aggregate functions in oracle?

1075

What do you mean by a database transaction & what all tcl statements are available in oracle?

1042

What is a data dictionary and how can it be created?

1242

Why do we need integrity constraints in a database?

1080

What are the different responsibilities of a dba?

780

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

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What is rac?

What is table partitioning and why is it required?

Un-Answered Questions { Oracle }

What happens if the constraint name is left out of a constraint clause?

583

How to define a data field as not null?

1163

what happened to the global index when I truncate the data in one of the partition?

2070

What is program global area (pga) in oracle?

1092

A scenario for amount correction & how to use amount correction functionality in AP invoices

2201

what are the tools used for oracle 10g in real time.

2502

Can you joined two sources without common column?

670

what's query optimization and without use of IN AND Exist can we get another way data from query

2202

What is bind variables in oracle reports?

How to assign a table row to a record variable?

1097

How to drop an index in oracle?

1122

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1069

How to determine what records to extract?

What is a user exit program in oracle reports?

1083

What is BBED in Oracle?

1201

For More Un-Answered { Oracle } Questions Click Here