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

Explain integrity constraint?

1161

In which language oracle has been developed?

1073

Difference between varchar and varchar2 data types?

1184

What is hash cluster in oracle?

1174

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

1047

How many memory layers are in the oracle shared pool?

1181

What are nested tables?

1174

How do we get field detail of a table?

1080

What are the roles of dba?

1068

Differentiate between pre-select and pre-query?

1106

What is save point in oracle database?

1296

What is hot backup and logical backup?

1051

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

1361

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

1164

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

1024

Un-Answered Questions { Oracle }

What is pga_aggregate_target?

571

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

How oracle flex asm works?

What is odi studio?

586

What are bind variables and why are they important?

543

How many types of segments in Oracle?

1070

how may join possible between (requisition with purchase order)

2250

How do you tell what your machine name is and what is its IP address?

2096

How to create a table interactively?

1090

What is the difference between sharding and partitioning?

986

What is an Oracle index?

1655

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1916

How many types of auditing in Oracle?

1035

When do you get a .pll extension in oracle? Explain its importance

1042

what are bitmap indexes? How does they work?

2245

For More Un-Answered { Oracle } Questions Click Here