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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to define a procedure inside another procedure?

1016

What to do if the binary spfile is wrong for the default instance?

1065

How to create a server parameter file?

1133

How to rename an existing table?

1123

What are the execution control statements?

1063

How to run create database statement?

1030

What happens if the update subquery returns multiple rows?

1114

How to use "startup" command to start default instance?

1025

What happens if the imported table already exists?

1030

How to create a stored program unit?

1222

How to call a stored function with parameters?

1035

How to turn on or off recycle bin for the instance?

1079

How to assign a table row to a record variable?

1038

How to define an anonymous procedure with variables?

1153

How to declare a local variable?

1109

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How can I combine multiple rows into a comma-delimited list in oracle?

1056

What are joins, explain all types of joins?

2297

What privilege is needed for a user to query tables in another schema?

969

How to create a single index for multiple columns?

1033

How to convert a date to char in oracle? Give one example.

1066

What is the quickest way to fetch the data from a table?

1056

How to create lov dynamically at runtime & attach to text field?

1178

Explain the difference between a procedure and a function? What do you understand by those terms?

1077

How a database is related to tablespaces?

1031

What are data pump export and import modes?

1062

What is Library Cache in Oracle?

1142

What are the predefined tablespaces in a database?

1079

what is the dual table in oracle?

989

How to convert times to characters in oracle?

1025

What is not equal to in oracle?

996

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