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 is the format trigger?

What are record groups ? Explain the types of record group.

What is forms_mdi_window?

Explain the use of decode function

How is mapping of name of dll and function done?

What is the placeholder column?

How to convert the oracle reports to excel sheet from oracle?

What are object group?

What do you understand by anchoring in reports?

How will you run ms_batch file in forms?

Explain the different types of queries created in reports?

Explain the various types of canvas in form.

What is bind variables in oracle reports?

Difference between bind parameter and lexical parameter.

How to avoid duplicate entries in the forms?

Un-Answered Questions { Oracle }

How to invoke the data pump export utility?

1187

Difference between the “verify” and “feedback” command?

1368

Which profile required to access solution in Designer tool?

586

What is the difference between substr and instr?

1037

What is the difference between a hot backup and a cold backup in oracle?

1017

What is J2EE Agent and port number?

614

You have taken a manual backup of a datafile using os. How rman will know about it?

552

Give two methods you could use to determine what DDL changes have been made.

6776

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2329

What is the sql query to find the employee who has Nth maximum salary?

5331

How to define an oracle cursor variable?

1028

How to create a new oracle data file?

1032

What do you mean by oracle database?

572

How do you set up your tablespace on installation level: low?

570

What are the limitations oracle database 10g xe?

1046

For More Un-Answered { Oracle } Questions Click Here