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?

1052

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

1015

How to loop through data rows in the implicit cursor?

1073

How to create additional tablespaces for an new database?

1027

How many categories of data types?

996

Can you assign multiple query result rows to a variable?

987

How to use fetch statement in a loop?

1019

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

1116

How do I learn what codesets are available in oracle?

1038

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

1051

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

1070

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

1087

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

1078

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

1003

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

1091

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

various types of hints and their usage

2699

How to use existing values in update statements using oracle?

1067

What do you mean by merge in oracle and how can you merge two tables?

948

what are steps for interface? where is exchange rate defined in which table?

2159

What are the advantages of oracle 12c?

1180

what are the default admin accounts in Oracle 10g ?

967

What is the relationship among database, tablespace and data file?

989

why dont we assign not null constraint as table level constraint.

2738

What is hash cluster in oracle?

1174

What is an oracle data file?

1103

Is insert autocommit in oracle?

1068

What are the execution control statements in oracle?

1095

What are the different types of database objects?

1062

How to download oracle database 10g xe?

1018

How do we represent comments in oracle?

1048

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