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 4833

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 5440

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

1 3785

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 6281

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

6 14424

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.

2168

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

Genpact,

8 18044

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

ABC, Cap Gemini,

7 23732

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9385

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,

2288

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

8 10825

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

1 4625

what is query and types of query

Reliance,

6 9093

how to create the triggers in the forms?

3 8314

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 3551

Un-Answered Questions { Oracle }

does the query needs a hint to access a materialized view?

1857

What is SQL Tuning Advisor in Oracle?

1170

What is the usage of analyze command in oracle?

1089

Give one method for transferring a table from one schema to another?

599

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1677

What does >> do?

581

How to shutdown your 10g xe server from command line?

1082

please send me oracle pl/sql exp resume. and also faqs...

2490

What is the difference between $oracle_base and $oracle_home?

1080

How to import one table back from a dump file?

1025

What is memo?

635

How to convert characters to times in oracle?

1018

What are the oracle differences between nvl and coalesce

1145

What is oracle database client?

1029

How do you set up tablespaces during an oracle installation?

604

For More Un-Answered { Oracle } Questions Click Here