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 7760

What is DTS and purpose of DTS ?

TCS,

1 6956

What is currency type in database ?

TCS,

3 14384

What is a heap related to database ?

TCS, University of Edinburgh,

1 7839

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

Oracle, TCS,

3384

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

Oracle,

2333

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

Oracle,

2915

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

Oracle,

1 4725

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

Oracle,

2280

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

Oracle, TCS,

2355

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,

2025

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

Oracle,

4 8149

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

Oracle,

1 6264

Can a formula column referred to columns in higher group ?

Oracle,

2506

Can a formula column be obtained through a select statement ?

Oracle,

2321

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?

2051

How to define an external table with a text file?

1067

How to check the server version in oracle?

1092

What is the difference between online and offline backups?

1057

What happens to the current transaction if the session is killed?

988

What is SQL Tuning Advisor in Oracle?

1178

What is execute immediate in oracle?

1021

Explain the use of consistent option in exp command.

1066

what is the difference between data migration and production migration.

2346

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

What is flashback in Oracle?

1017

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

What are oracle functions?

1030

Explain the use of grant option in imp command.

1026

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