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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

how can it possibble to see the report output in excel sheet in oracle applications

Oracle, Wipro,

4 9772

what is sql*loader parameters and where we will use it.

Accenture,

1 7237

what is the syntax of update command?

Semantic Space,

3 6420

which clause we are not used in where clause?

Semantic Space,

3 7560

waht is referencial integrity?

Semantic Space,

2 7416

what is the syntax of SELECT command?

6 8098

what is the syntax of INSERT command?

7 10274

what is the syntax of UPDATE command?

8 12038

what is the syntax of DELETE command?

8 11607

what is the syntax of CREATE command?

8 10145

what is the syntax of DROP command?

10 13198

what is the syntax of ALTER command?

8 13830

which sql command we can use to get a print out from oracle?

iFlex, INDUS,

2 11167

what is index?

4 7810

what is a view?

7 9720

Un-Answered Questions { Oracle }

How to rename a tablespace in oracle?

1042

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

2082

Is there a combination of "like" and "in" in sql?

1014

What is an anonymous block?

1173

How to invoke the original export import utilities?

994

How do you install statspack?

643

Can multiple columns be used in group by in oracle?

938

Where does the clusterware write when there is a network or storage issue?

Describe an oracle table?

1001

What degree do database administrators need?

516

difference between global n context sensitive segments?

2634

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

562

Explain parameter file in oracle.

985

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1249

How many types of km's? And you what are the type's km are used in your project?

530

For More Un-Answered { Oracle } Questions Click Here