Oracle Interview Questions
Questions Answers Views Company eMail

What is SYSTEM tablespace and When is it Created?

2 6259

Explain the relationship among Database, Tablespace and Data file?

4 10918

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 53076

What are Schema Objects ?

2 4437

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

3 8255

Can a Tablespace hold objects from different Schemes ?

3 6351

what is Table ?

2 4331

What is a View ?

3 5366

Do View contain Data ?

10 20735

Can a View based on another View ?

3 10674

What are the advantages of Views ?

3 8817

What is a Sequence ?

3 5505

What is a Synonym ?

3 5939

What are the type of Synonyms?

1 5113

What is a Private Synonyms ?

1 4209


Un-Answered Questions { Oracle }

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

322


What is tkprof and how is it used?

285


What is null value in oracle?

638


What to do if the startbd.bat failed to start the xe instance?

611


What is Journalization and why we are using in ODI?

277






What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

706


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1483


What are the different types of backup available in the oracle?

300


What is the sequence of firing in form level trigger?

1


Explain about integrity constraint?

606


How to drop an existing view in oracle?

571


what is normalisation?what are its uses?

1763


How to see the table columns used in an index?

596


Can group functions be used in the order by clause in oracle?

580


How a tablespace is related to data files?

583