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?

1118

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

1058

How translate command is different from replace?

1084

How will you differentiate between varchar & varchar2?

1041

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

987

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

1029

What is the use of aggregate functions in oracle?

1026

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

994

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

1150

Why do we need integrity constraints in a database?

1019

What are the different responsibilities of a dba?

722

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 }

Explain the use of constraints option in exp command.

1047

What is the difference between 10g OEM and 11g OEM?

965

Can we invoke one form from another in a multi-forms application?

1131

What is system global area (sga) in oracle?

991

How to use subqueries in the from clause in oracle?

1111

Is a rollback possible to any savepoint?

1094

how to clone 9i Database on to 10g Database.

2338

please explain.. DB architecture ...

2018

How to select some rows from a table in oracle?

1077

How to move objects from DEV to QA and QA to PROD Environments?

710

Explain the use of record option in exp command.

1006

What are the IKM types?

676

What is PL/SQL ?

2059

What is a database schema in oracle?

1110

What is oracle server autotrace in oracle?

1166

For More Un-Answered { Oracle } Questions Click Here