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 are actual and formal parameters?

1104

Differentiate between translate and replace?

1118

Explain the use of rows option in imp command.

1086

Explain the use of rows option in exp command.

1091

Explain the use of tables option in exp command.

1116

Differentiate between post-database commit and post-form commit?

1041

Explain the use of full option in exp command.

1116

Difference between pre-select and pre-query

1109

Explain an exception?

995

What are the varoius components of physical database structure of oracle database?

1006

Explain the use of online redo log files in oracle.

1037

Explain the use of grant option in exp command.

1063

What is a sub query? What are its various types?

1179

Explain enable novalidate constraint.

1081

What is a synonym? What are its various types?

1110

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to run queries on external tables?

1047

Hi Can any one tell me what are the API's used in requisition import.

1923

Explain the use of full option in exp command.

1116

What is an oracle user role?

984

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

Whats the benefit of dbms_stats over analyze?

2002

Explain a segment?

1087

What are the execution control statements in oracle?

1095

What are group functions in oracle?

1041

What is the usage of save points in oracle database?

964

What is blob data type in oracle?

1123

What is rowid and rownum in oracle?

1011

What is a nested table?

1058

How are extents allocated to a segment?

1125

What are the system predefined user roles?

1041

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