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 7867

What is DTS and purpose of DTS ?

TCS,

1 7031

What is currency type in database ?

TCS,

3 14484

What is a heap related to database ?

TCS, University of Edinburgh,

1 7931

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

Oracle, TCS,

3434

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

Oracle,

2371

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

Oracle,

2952

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

Oracle,

1 4816

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

Oracle,

2338

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

Oracle, TCS,

2423

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,

2066

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

Oracle,

4 8328

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

Oracle,

1 6341

Can a formula column referred to columns in higher group ?

Oracle,

2553

Can a formula column be obtained through a select statement ?

Oracle,

2380

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Give the constructs of a package, function or a procedure.

1095

What is the usage of merge statement?

1203

How to add another datafile to a tablespace?

1088

What is a data lock in oracle?

1180

Can group functions be mixed with non-group selection fields?

1073

How to end the current transaction in oracle?

1071

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2147

What do you mean by merge in oracle?

1029

How to empty your oracle recycle bin?

1074

How do I uninstall oracle client from windows?

1057

How will you write a query to get a 5th rank student from a table student_report?

1918

What are the different types of trigger and explain its various uses and functions?

1166

Why cursor variables are easier to use than cursors?

1139

How to return top 5 rows in oracle?

1112

How a tablespace is related to data files?

1165

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