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?

1159

Differentiate between translate and replace?

1186

Explain the use of rows option in imp command.

1130

Explain the use of rows option in exp command.

1146

Explain the use of tables option in exp command.

1166

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

1092

Explain the use of full option in exp command.

1175

Difference between pre-select and pre-query

1173

Explain an exception?

1053

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

1038

Explain the use of online redo log files in oracle.

1077

Explain the use of grant option in exp command.

1106

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

1270

Explain enable novalidate constraint.

1129

What is a synonym? What are its various types?

1168

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to find out what oracle odbc drivers are installed?

1090

How to run queries on external tables?

1084

Explain the difference between a procedure and a function?

1237

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

Differentiate between translate and replace?

1186

How to execute a stored program unit?

1126

what is the use of system.effective.date variable in oracle?

1161

What are temporal data types in oracle?

1164

What are the execution control statements in oracle?

1127

How to rebuild an index in oracle?

1069

What are the differences between primary key and unique key?

1057

How do I manually create a database in oracle?

1068

How to pass parameters to procedures?

1085

How do I uninstall oracle client from windows?

1055

What do you understand by database schema and what does it hold?

1296

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