Oracle Interview Questions
Questions Answers Views Company eMail

Explain can a view based on another view?

1 809

Explain what are the advantages of views?

601

Explain what are clusters?

604

Explain a data segment?

638

Explain what are the uses of rollback segment?

574

What is sequence?

618

Explain what are the characteristics of data files?

620

Explain how are indexes update?

613

Explain table?

638

Explain what are the type of synonyms?

573

Explain what are synonyms used for?

597

Explain a segment?

606

Explain database link?

651

Explain an integrity constrains?

692

Explain the use of control file?

645


Un-Answered Questions { Oracle }

What privilege is needed for a user to create indexes in oracle?

559


What are the uses of synonyms?

594


How is mapping of name of dll and function done?

1


How is it different from a normal table?

575


What is a cursor and what are the steps need to be taken?

589






what is difference between group above and group left report

3191


What are the varoius components of physical database structure of oracle database?

557


What is a relational database management system?

660


What do you understand by the term 'normalization'? Explain the various modes of normalization?

256


How does one create a new database?

303


Where is the multi connections are used in ORACLE DATA INTEGATOR?

286


What is StandAlone Agent and default port number?

352


Explain the use of analyse option in exp command.

584


What is an Oracle database Full Backup?

624


How to connect to oracle using service name instead of sid?

543