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

What is meant by joins?

1057

Can we save images in a database and if yes, how?

1057

What is a view and how is it different from a table?

1040

How will you write a query to get a 5th rank student from a table student_report?

1858

What are the different editions of oracle?

1103

What is meant by an index?

1135

What is meant by a deadlock situation?

1104

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

1086

How can we find out the current date and time in oracle?

1086

What is a nested table and how is it different from a normal table?

1044

How is it different from a normal table?

1026

How does the on-delete-cascade statement work?

1100

What is meant by joins? List out the types of joins.

1023

What do you understand by database schema and what does it hold?

1228

What do you mean by merge in oracle and how can we merge two tables?

1049

Un-Answered Questions { Oracle }

What is the scd? and Types of SCD?

615

Explain the purpose of forms_ddl.

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2260

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

605

What is the difference between hot backup and cold backup in oracle?

1008

What language does oracle use?

1094

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

what is insert all statement in sql

6506

What is null value in oracle?

1095

What is tkprof and how can we use it?

What is the variable?

615

How to call a stored function with parameters?

1032

How to display row numbers with the records?

1073

What are the key components of oracle’s maximum availability architecture?

How a database is related to tablespaces?

1028

For More Un-Answered { Oracle } Questions Click Here