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

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

Oracle Interview Questions

Questions Answers Views Company eMail

What do you know about normalization? Explain in detail?

1005

What are the different oracle database objects?

1152

State all possible different index configurations a table can possibly have?

1106

What is the difference between translate and replace?

1118

How can we delete duplicate rows in a table?

1041

What is a cursor and what are the steps need to be taken?

1296

Compare and contrast between sql and sql server and explain its various functions?

1019

How different is ms access and oracle?

1095

How to display employee records who gets more salary than the average salary in the department?

1128

State some uses of redo log files?

1070

What is coalesce function?

1149

How can we view last record added to a table?

1110

What is the maximum number of triggers that can be applied to a single table?

1074

What is the usage of merge statement?

1210

Explain the difference between a procedure and a function?

1242

Un-Answered Questions { Oracle }

How should a many-to-many relationship be handled?

597

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

1166

Explain what are the uses of rollback segment?

1069

How to create an oracle database?

1107

Explain the use of rows option in imp command.

1143

What does dba stand for in technology?

591

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1998

How to define default values for formal parameters?

1096

Mention what are the file storage options provided by oracle database for oracle rac?

How do I spool to a csv formatted file using sqlplus?

1094

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

1077

How to specify default values in insert statement using oracle?

1157

What happens in oracle commit?

1084

Describe varray?

1118

How to call a stored function with parameters?

1098

For More Un-Answered { Oracle } Questions Click Here