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

Why do we use coalesce function in oracle?

1065

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

1009

How translate command is different from replace?

1031

How will you differentiate between varchar & varchar2?

998

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

950

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

970

What is the use of aggregate functions in oracle?

987

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

947

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

1075

Why do we need integrity constraints in a database?

984

What are the different responsibilities of a dba?

658

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 }

Is oracle dba in demand?

550

What is tns entry?

1073

Explain the payment term in ar. : oracle accounts receivable

1068

what is Single Byte Overhead...?

2507

What privilege is needed for a user to connect to oracle server?

958

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2292

Explain the use of online redo log files in oracle.

1001

How to end the current transaction in oracle?

974

What happens if you lost a data file?

991

What is data file?

1058

what is load plans and types of load plans?

568

What are the common oracle dba tasks?

1083

How can we force the database to use the user specified rollback segment?

1089

what is difference between sql plus and sql*plus? (not sql and sql plus).

3838

What is execute immediate in oracle?

966

For More Un-Answered { Oracle } Questions Click Here