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 9956

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

Accenture,

1 7343

what is the syntax of update command?

Semantic Space,

3 6548

which clause we are not used in where clause?

Semantic Space,

3 7695

waht is referencial integrity?

Semantic Space,

2 7549

what is the syntax of SELECT command?

6 8337

what is the syntax of INSERT command?

7 10554

what is the syntax of UPDATE command?

8 12370

what is the syntax of DELETE command?

8 11881

what is the syntax of CREATE command?

8 10437

what is the syntax of DROP command?

10 13553

what is the syntax of ALTER command?

8 14130

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

iFlex, INDUS,

2 11270

what is index?

4 7995

what is a view?

7 9974

Un-Answered Questions { Oracle }

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

589

How to delete multiple rows from a table in oracle?

1065

What happens if you set the sga too low in oracle?

1156

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.

2007

What is oracle dba role?

583

Difference between case & decode?

686

How to assign data of the deleted row to variables?

1077

Is there a function to split a string in plsql?

1068

Can sub procedure/function be called recursively?

1006

What does >> do?

592

What is the difference between post-database commit and post-form commit?

1206

Explain coalesce function?

1209

How to enter a new row into a table interactively?

1015

How to handle a single quote in oracle sql?

1058

How to rename an index in oracle?

1118

For More Un-Answered { Oracle } Questions Click Here