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 9928

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

Accenture,

1 7331

what is the syntax of update command?

Semantic Space,

3 6526

which clause we are not used in where clause?

Semantic Space,

3 7667

waht is referencial integrity?

Semantic Space,

2 7523

what is the syntax of SELECT command?

6 8296

what is the syntax of INSERT command?

7 10509

what is the syntax of UPDATE command?

8 12324

what is the syntax of DELETE command?

8 11839

what is the syntax of CREATE command?

8 10394

what is the syntax of DROP command?

10 13483

what is the syntax of ALTER command?

8 14052

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

iFlex, INDUS,

2 11252

what is index?

4 7970

what is a view?

7 9917

Un-Answered Questions { Oracle }

what are knowledge modules?

635

Explain a synonym?

1021

What are the important tasks of common oracle dba?

556

What is the difference between translate and replace in oracle?

1161

What is the difference between a primary key & a unique key?

1086

What is a data lock in oracle?

1100

What is catalog in Oracle?

1354

Can we write dml statement in function in oracle?

1077

How many redo logs should you have and how should they be configured for maximum recoverability?

563

What is program global area (pga) in oracle?

1025

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1135

Explain parameter file in oracle.

1021

What is flashback in Oracle?

1015

How to best split csv strings in oracle 9i?

1039

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2130

For More Un-Answered { Oracle } Questions Click Here