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?

1054

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?

1074

How to create additional tablespaces for an new database?

1028

How many categories of data types?

997

Can you assign multiple query result rows to a variable?

988

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?

1093

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle database 10g express edition?

1120

WHAT IS ecc 6.0

2148

What is oracle latest version?

1096

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

What is an oracle wallet?

942

How to end the current transaction in oracle?

1030

How many types of tables supported by oracle?

1077

Explain the use of parfile option in exp command.

1069

How to set a transaction to be read only in oracle?

1093

What is a snapshot in oracle database?

1025

What is a snapshot log?

1003

how to make an oracle object

2359

candidate key is subset of super key but not vice-verse explain

2068

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

State the difference between a primary key and foreign key?

935

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