1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

Difference between primary key and unique key ?

Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

77 190355

What is Normalization ?

ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

55 73512

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 62313

Indexes in oracle ?

Keane India Ltd, L&T,

3 8691

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2077

Query to get max and second max in oracle in one query ?

CTS, Keane India Ltd, TCS, Wipro,

34 57298

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 6511

What is DTS and purpose of DTS ?

TCS,

1 6146

What is currency type in database ?

TCS,

3 12833

What is a heap related to database ?

TCS, University of Edinburgh,

1 7016

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

Oracle, TCS,

2839

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

Oracle,

1815

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

Oracle,

2398

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

Oracle,

1 3903

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

Oracle,

1831

Un-Answered Questions { Oracle }

Why do we need to rebuild indexes?

1

Can you joined two sources without common column?

323

What are dml statements in oracle?

613

What is a package ? What are the advantages of package ?

592

When do I need to use a semicolon vs a slash in oracle sql?

584




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

539

Where in the Oracle directory tree structure are audit traces placed?

2118

Explain what are the advantages of views?

602

How many categories of data types?

570

What file will give you oracle instance status information? Where is it located?

277

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1526

How would you determine what sessions are connected and what resources they are waiting for?

1609

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

606

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

1916

Explain how to close periods in ar. : oracle accounts receivable

701

For More Un-Answered { Oracle } Questions Click Here