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 the restrictions on external table columns?

1107

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

1056

How to loop through data rows in the implicit cursor?

1116

How to create additional tablespaces for an new database?

1073

How many categories of data types?

1038

Can you assign multiple query result rows to a variable?

1034

How to use fetch statement in a loop?

1066

How do I call oracle stored procedures that take no parameters?

1194

How do I learn what codesets are available in oracle?

1075

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

1095

How do I limit the number of oracle database connections generated by weblogic server?

1113

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1124

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1121

Why does for update in oracle 8 cause an ora-01002 error?

1043

How to find the duplicate rows count from employees table in oracle?

1141

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I find the database name in oracle?

1084

Give the advantages and disadvantages of clusters.

1096

What is a database table in oracle?

1067

Explain an exception?

1053

How can we find out the duplicate values in an oracle table?

1110

Will you be able to store pictures in the database?

1169

What is the difference between truncate & delete command?

1232

What is bulk copy or bcp in oracle?

1181

What do you know about normalization? Explain in detail?

996

How to invoke the data pump export utility?

1250

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

1161

How to write date and time interval literals in oracle?

1076

What are the predefined tablespaces in a database?

1140

How to load data from external tables to regular tables?

1099

How will you write a query to get a 5th rank student from a table student_report?

1918

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