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?

1085

How will you differentiate between varchar & varchar2?

1041

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

988

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

1031

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 }

What are the different windows events activated at runtime ?

2900

Discuss row chaining, how does it happen? How can you reduce it?

542

Explain alias?

1150

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

What is tkprof and how is it used?

608

In oracle there is column command, how will you explain that?

1055

Who is dba in dbms?

581

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

What is an Oracle Rollback Segment?

1119

What is the difference between "as" and "is" in an oracle stored procedure?

991

Which is the best option used to move database from one server to another serve on same network and why?

547

How to create a new view in oracle?

1078

What is a connect identifier?

1039

What is a snapshot in oracle database?

1025

Mention what are the benefits of oracle rac?

For More Un-Answered { Oracle } Questions Click Here