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 4858

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 5455

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

1 3797

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 6299

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

6 14469

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.

2183

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

Genpact,

8 18099

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

ABC, Cap Gemini,

7 23783

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9439

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 10881

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

1 4649

what is query and types of query

Reliance,

6 9129

how to create the triggers in the forms?

3 8340

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 3561

Un-Answered Questions { Oracle }

Explain the use of file option in exp command.

1134

How to loop through a cursor variable?

1092

What is transport network substrate (tns) in oracle?

1047

How to insert multiple rows with one insert statement in oracle?

1093

did u received a single file or multiple files

2023

What is oracle dba role?

583

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2078

How does oracle handle read consistency?

1102

How to define a data source name (dsn) in odbc manager?

1037

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

Tell me about standby database? What should we watch out for?

552

Does oracle partitioning improve performance?

1004

How to start an oracle instance?

1025

Explain for repository?

596

How to return top 5 rows in oracle?

1069

For More Un-Answered { Oracle } Questions Click Here