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

Explain integrity constraint?

1209

In which language oracle has been developed?

1139

Difference between varchar and varchar2 data types?

1264

What is hash cluster in oracle?

1250

What is the parameter mode that can be passed to a procedure?

1112

How many memory layers are in the oracle shared pool?

1256

What are nested tables?

1227

How do we get field detail of a table?

1134

What are the roles of dba?

1139

Differentiate between pre-select and pre-query?

1160

What is save point in oracle database?

1369

What is hot backup and logical backup?

1117

What is the fastest query method to fetch data from the table?

1422

can you convert or reverse engineer a fmx back to a fmb file?

1228

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1073

Un-Answered Questions { Oracle }

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

677

How many types of database software are there?

629

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2342

Can we use bind variables in oracle stored procedure?

989

how do u setup a replication site?

2035

What are types of data model?

602

What are the different responsibilities of a dba?

780

Where in the Oracle directory tree structure are audit traces placed?

2707

Can you have more than one content canvas view attached with a window ?

2374

Why do you create or replace procedures rather that drop and recreate.

1074

What is columnar storage what is the advantage?

1126

What is a dba?

641

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

1104

Explain the use of ignore option in imp command.

1090

How to get execution path reports on query statements?

1047

For More Un-Answered { Oracle } Questions Click Here