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 collection attributes

1 4847

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

Oasis,

2 5446

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3792

sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

ESS,

1 6291

what r tyhe major differences between oracle 9i & 10g?

6 14448

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2179

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 18069

how to delete all duplicate records from a table using subquery?

ABC, Cap Gemini,

7 23757

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9420

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

Wipro,

2297

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 10858

what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 4637

what is query and types of query

Reliance,

6 9116

how to create the triggers in the forms?

3 8325

I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.

1 3556

Un-Answered Questions { Oracle }

How to install oracle database 10g xe?

1018

What is format trigger?

2071

What is a initialization parameter file in oracle?

1035

What does >> do?

586

What are record groups ?

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2022

How to declare a local variable?

1115

Explain about functional dependency and its relation with table design?

1010

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

2096

How to connect ms access to oracle servers?

1007

How to work with data objects interactively?

982

How can we delete duplicate rows in a table?

973

What are the types of profiles in ODI?

595

How to create id with auto_increment on oracle?

990

How translate command is different from replace?

1085

For More Un-Answered { Oracle } Questions Click Here