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 SYSTEM tablespace and When is it Created?

2 7569

Explain the relationship among Database, Tablespace and Data file?

4 12614

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63007

What are Schema Objects ?

2 5501

Can objects of the same Schema reside in different tablespaces.?

3 9374

Can a Tablespace hold objects from different Schemes ?

3 7575

what is Table ?

2 5243

What is a View ?

3 6495

Do View contain Data ?

10 23436

Can a View based on another View ?

3 11788

What are the advantages of Views ?

3 10182

What is a Sequence ?

3 6893

What is a Synonym ?

3 7046

What are the type of Synonyms?

1 5815

What is a Private Synonyms ?

1 5003

Un-Answered Questions { Oracle }

What is logical backup in oracle?

1014

What is the use of the Service Knowledge module?

586

Why is oracle database so popular?

990

How you find which the latest record in SCD type2 transformation is?

580

What is a connect identifier?

1037

Is truncate autocommit in oracle?

1077

How to write an inner join with the where clause in oracle?

1042

How to define an oracle sub procedure?

1136

How do I escape a reserved word in oracle?

1195

How to create tables for odbc connection testing?

1108

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

547

How to save query output to a local file?

1023

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2047

What does a senior database administrator do?

604

What are the tools for Oracle ?

1056

For More Un-Answered { Oracle } Questions Click Here