Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 4915

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 5547

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

1 3867

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 6381

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

6 14718

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.

2269

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

Genpact,

8 18374

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

ABC, Cap Gemini,

7 23994

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9619

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,

2342

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

8 11120

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

1 4715

what is query and types of query

Reliance,

6 9363

how to create the triggers in the forms?

3 8461

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 3653

Un-Answered Questions { Oracle }

can u plz provide me oca sql dumps please i need them

1999

In what sequence do triggers get fired by oracle forms?

1027

How to get last row id?

1062

How many types of dba are there?

617

Mention what is the volume management techniques used in oracle rac?

query optmization techniques and quwry analyser+projects+ppts

2470

Is the After report trigger fired if the report execution fails ?

2956

How index is implemented in oracle database?

1051

How to assign query results to variables?

1101

What are the most common interview questions on ETL Testing for experience?

1196

How is rman better than user-managed backup recovery process?

How to create a table index?

1234

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4573

What is the function of Redo Log in Oracle?

1276

How can we tune a sql query to optimize the performance of a database?

For More Un-Answered { Oracle } Questions Click Here