Oracle General Interview Questions
Questions Answers Views Company eMail

What do database buffers contain?

651

Explain view?

675

Explain can a view based on another view?

1 952

Explain what are the advantages of views?

683

Explain what are clusters?

711

Explain a data segment?

741

Explain what are the uses of rollback segment?

657

What is sequence?

702

Explain what are the characteristics of data files?

707

Explain how are indexes update?

695

Explain table?

735

Explain what are the type of synonyms?

662

Explain what are synonyms used for?

691

Explain a segment?

691

Explain database link?

745


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert a string to a date in oracle database?

626


What is a table index in oracle?

726


How to declare a local variable?

694


How many types of table in Oracle?

705


What happens to the current transaction if the session is ended?

612






Briefly explain what is literal? Give an example where it can be used?

638


How to retrieve values from data fields in record variables?

650


How to create id with auto_increment on oracle?

641


What are the different types of database objects?

620


How to create an oracle database manually?

660


What is oracle server autotrace in oracle?

705


How would you begin to troubleshoot an ORA-3113 error?

1699


List the various oracle database objects?

699


Can we write dml statement in function in oracle?

724


How to define a data field as not null?

717