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.

1045

Explain integrity constraints?

1106

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?

998

What is meant by recursive hints in oracle?

1089

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

1039

Explain the use of file option in exp command.

1131

material view and view disadvantages?

1073

How many types of tables supported by oracle?

1077

How to select some rows from a table in oracle?

1078

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to define a data source name (dsn) in odbc manager?

1034

What are the execution control statements?

1065

How to connect to a remote server?

1127

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

How to calculate date and time differences in oracle?

1042

What are oracle functions?

1030

Explain the use of constraints option in exp command.

1048

Explain the use of grant option in imp command.

1030

What are the execution control statements in oracle?

1097

What are the differences between lov and list item?

1066

How do I find my oracle client driver version?

1040

What is oracle datasource?

987

How to empty your oracle recycle bin?

1022

What are the components of logical database structure in oracle database?

1088

What are triggers in oracle?

1040

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