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

Oracle General Interview Questions

Questions Answers Views Company eMail

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7791

What is DTS and purpose of DTS ?

TCS,

1 6972

What is currency type in database ?

TCS,

3 14407

What is a heap related to database ?

TCS, University of Edinburgh,

1 7860

What are the built-in functions used for sending Parameters to forms ?

Oracle, TCS,

3397

Can you have more than one content canvas view attached with a window ?

Oracle,

2340

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

Oracle,

2922

Does a Before form trigger fire when the parameter form is suppressed ?

Oracle,

1 4746

Is it possible to split the print reviewer into more than one region ?

Oracle,

2285

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

Oracle, TCS,

2369

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

Oracle,

2037

Can a field be used in a report without it appearing in any data group ?

Oracle,

4 8193

The join defined by the default data link is an outer join yes or no ?

Oracle,

1 6291

Can a formula column referred to columns in higher group ?

Oracle,

2517

Can a formula column be obtained through a select statement ?

Oracle,

2336

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2062

What is an Oracle Instance?

1135

What is oracle database client?

1044

How does one get the view definition of fixed views/tables?

1031

What is meant by joins? List out the types of joins.

1042

Is there a function to split a string in plsql?

1072

How to import one table back from a dump file?

1037

What happens if variable names collide with table/column names?

1206

What are the common oracle dba tasks?

1160

How to load data through external tables?

1151

How would you change old and new values in an insert, delete and update triggers?

1032

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1895

How to use "in" parameter properly?

1084

How do you store pictures in a database?

1017

Give the different types of rollback segments.

1042

For More Un-Answered { Oracle General } Questions Click Here