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?

1005

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

966

How to loop through data rows in the implicit cursor?

1024

How to create additional tablespaces for an new database?

982

How many categories of data types?

947

Can you assign multiple query result rows to a variable?

938

How to use fetch statement in a loop?

988

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

1040

How do I learn what codesets are available in oracle?

1013

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

1009

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

1018

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

1054

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

1029

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

947

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

1051

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4304

How do you find current date and time in oracle?

997

Difference between inner join vs where ?

989

What are the differences between primary key and unique key?

955

What is a data dictionary and how can it be created?

1075

What are the differences between char and varchar2 in oracle?

1091

Explain how are indexes update?

1032

What are group functions in oracle?

987

What are the differences between date and timestamp in oracle?

996

What is sequence?

1021

How to define a variable to match a table column data type?

943

How to use an explicit cursor without open statements?

1020

Respected sir, Please send me technical questions related to oracle apps..

1771

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2063

How do we display rows from the table without duplicates?

930

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