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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain the use of owner option in exp command.

1043

Explain integrity constraints?

1104

What do you mean by a deadlock?

1065

Will you be able to store pictures in the database?explain.

992

Explain the function of optimizer in oracle?

1143

What are the uses of synonyms?

1138

Explain the use of record option in exp command.

1006

Explain the use of analyse option in exp command.

1128

List the types of joins used in writing subqueries?

997

What is meant by recursive hints in oracle?

1087

List out the components of logical database structure of oracle database.

1036

Explain the use of file option in exp command.

1130

material view and view disadvantages?

1073

How many types of tables supported by oracle?

1076

How to select some rows from a table in oracle?

1078

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to end the current transaction in oracle?

1030

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078

Respected sir, Please send me technical questions related to oracle apps..

1813

What do you mean by group by clause?

1045

Where is the export dump file located?

1158

How to bring a tablespace offline?

1064

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

definition of cluster and non-clustered index?

3035

How to delete a column in an existing table?

1076

Explain about your project and its relation to the current job position you are applying to?

1006

How to open a cursor variable?

1035

what are the advantages of running a database in archive log mode?

2203

What is the dynamic sql in oracle?

1072

How many data types are supported?

1079

What is primefaces used for?

1049

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