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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is merge statement used for?

1024

Explain the use of consistent option in exp command.

1068

Explain the use of indexes option in imp command.

1179

what is the use of system.effective.date variable in oracle?

1116

Explain the types of exception?

1143

When do you get a .pll extension in oracle? Explain its importance

1042

What are the various types of snapshots ?

1029

Explain the use of ignore option in imp command.

1035

What is the purpose of save points in oracle database?

1119

Difference between open_form and call_form in oracle.

1161

Explain an exception and its types?

1073

What are the different types of record groups in oracle? Explain each of them

1025

Explain the use of record length option in exp command.

1067

What is control file used for?

1209

Explain the use of inctype option in exp command.

1034

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is rowid and rownum in oracle?

1011

List the types of joins used in writing subqueries?

998

What is difference between truncate and delete?

1040

How to define a data source name (dsn) in odbc manager?

1034

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5329

What are temporal data types in oracle?

1123

What are a cluster and non-cluster index?

1018

Differentiate between function and procedure in oracle.

1077

How to drop an index in oracle?

1076

Explain what are the uses of rollback segment?

1015

State the various uses of dbcc command?

1060

In oracle there is column command, how will you explain that?

1057

Â How to use an oracle sequence generator in a mapping?

1076

What is oracle latest version?

1096

How to find the duplicate rows count from employees table in oracle?

1092

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