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

What are the built-ins that are used to Attach an LOV programmatically to an item?

1 6171

What are the built-ins that are used for setting the LOV properties at runtime?

1 4962

What is a record group?

1 3936

How many number of columns a record group can have?

2 9456

What is the Maximum allowed length of Record group Column?

2 5879

What are the different types of Record Groups?

1 6292

What is a Query Record Group?

1 4088

What is a Non Query Record Group?

1 9665

What is a Static Record Group?

2 9204

What are the built-ins used for Creating and deleting groups?

1 3828

What are the built -ins used for Modifying a group's structure?

1 3529

What are the built-ins used for Getting cell values?

1 6238

What are built-ins used for Processing rows?

1 6901

What are the built-ins used for finding Object ID function?

1 3816

What are the built-in used for getting cell values?

1 5905

Un-Answered Questions { Oracle }

What is rich query?

981

When should an artificial (or derived) primary key be used?

597

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1209

Write a trigger example in oracle?

1063

What are referenced objects? Explain the importance of referencing.

How many types of dba are there?

569

How to retrieve values from data fields in record variables?

1116

What are data pump export and import modes?

1068

Explain the term 'oracle grid architecture'?

587

Give the advantages and disadvantages of clusters.

1050

How to define an anonymous block?

1157

WHAT IS ecc 6.0

2147

What is hot backup and logical backup?

1051

What are the different types of backup available in the oracle?

586

How to assign a tablespace to a users in oracle?

1048

For More Un-Answered { Oracle } Questions Click Here