Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What do database buffers contain?

973

Explain view?

985

Explain can a view based on another view?

1 1446

Explain what are the advantages of views?

1019

Explain what are clusters?

1050

Explain a data segment?

1024

Explain what are the uses of rollback segment?

968

What is sequence?

1017

Explain what are the characteristics of data files?

1038

Explain how are indexes update?

1023

Explain table?

1071

Explain what are the type of synonyms?

1061

Explain what are synonyms used for?

988

Explain a segment?

1033

Explain database link?

1064

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1853

Why do you use stored procedures and state some of its disadvantages?

977

How to drop a stored procedure in oracle?

1004

How to create tables for odbc connection testing?

1022

What is procedure overloading in oracle?

998

Â How to use an oracle sequence generator in a mapping?

1025

How to create id with auto_increment on oracle?

943

What is the usage of save points in oracle database?

918

What is max rowid in oracle?

973

How to end the current transaction in oracle?

972

What are the different pseudo commands? Explain in general?

1028

What would you do with an in-doubt distributed transaction?

1924

What is the relation of a user account and a schema?

1068

How to export data with a field delimiter?

980

What is memory advisor in Oracle?

1030

For More Un-Answered { Oracle General } Questions Click Here