Oracle General Interview Questions
Questions Answers Views Company eMail

What do database buffers contain?

675

Explain view?

710

Explain can a view based on another view?

1 1004

Explain what are the advantages of views?

711

Explain what are clusters?

743

Explain a data segment?

766

Explain what are the uses of rollback segment?

683

What is sequence?

740

Explain what are the characteristics of data files?

725

Explain how are indexes update?

730

Explain table?

775

Explain what are the type of synonyms?

691

Explain what are synonyms used for?

723

Explain a segment?

726

Explain database link?

778


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a read only transaction in oracle?

702


What is using clause and give example?

703


Where do we use decode and case statements?

671


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1564


What is a system tablespace and when it is created?

651






Why do we use bulk collect in oracle?

690


How to create a new table by selecting rows from another table?

686


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1824


What are a cluster and non-cluster index?

671


Can we use bind variables in oracle stored procedure?

598


How different is ms access and oracle?

677


What are the general rules on data consistency?

683


How to list all indexes in your schema?

681


What is the implicit cursor in oracle?

684


Explain self joins in oracle?

676