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 7577

Explain the relationship among Database, Tablespace and Data file?

4 12624

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63192

What are Schema Objects ?

2 5515

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

3 9396

Can a Tablespace hold objects from different Schemes ?

3 7587

what is Table ?

2 5256

What is a View ?

3 6512

Do View contain Data ?

10 23494

Can a View based on another View ?

3 11800

What are the advantages of Views ?

3 10191

What is a Sequence ?

3 6907

What is a Synonym ?

3 7059

What are the type of Synonyms?

1 5835

What is a Private Synonyms ?

1 5011

Un-Answered Questions { Oracle }

What do you understand from cache fusion?

Who developed oracle & when?

1003

What is SKM and when we will use this SKM?

661

What is bind variable in oracle 11g?

1039

What is materialized view in Oracle?

1074

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

585

Difference between negative and positive adjustments : oracle accounts receivable

1104

What are the components of logical database structure in oracle database?

1088

What are the different types of backups that are available in oracle?

Can we write insert statement in function in oracle?

1090

What are the different types of modules in oracle forms?

1001

What is archive log in Oracle?

1134

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

590

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2026

What is logical backup in oracle?

1017

For More Un-Answered { Oracle } Questions Click Here