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?

1030

Explain view?

1034

Explain can a view based on another view?

1 1516

Explain what are the advantages of views?

1069

Explain what are clusters?

1108

Explain a data segment?

1069

Explain what are the uses of rollback segment?

1015

What is sequence?

1083

Explain what are the characteristics of data files?

1085

Explain how are indexes update?

1064

Explain table?

1115

Explain what are the type of synonyms?

1112

Explain what are synonyms used for?

1034

Explain a segment?

1087

Explain database link?

1123

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Write a trigger example in oracle?

1063

How to rename an index?

1072

Explain the blob datatype?

1071

What are the different types of synonyms?

1140

How to select some rows from a table in oracle?

1078

What are the different types of failures that occur in Oracle database?

1067

Explain how are indexes update?

1064

What is Data Dictionary Cache in Oracle?

1163

What is parameterized cursor in oracle?

1150

Why does for update in oracle 8 cause an ora-01002 error?

1003

How to list all tables in your schema?

1053

Explain integrity constraints?

1104

what is insert all statement in sql

6515

What is program global area (pga) in oracle?

1030

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

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