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?

991

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

955

How to loop through data rows in the implicit cursor?

1015

How to create additional tablespaces for an new database?

969

How many categories of data types?

937

Can you assign multiple query result rows to a variable?

931

How to use fetch statement in a loop?

971

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

1019

How do I learn what codesets are available in oracle?

997

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

997

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

1006

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

1044

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

1013

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

932

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

1038

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the characteristics of oracle dba?

1068

What is a package ? What are the advantages of package ?

1033

Can we call procedure inside function in oracle?

1018

Explain a segment?

1018

What is an oracle user role?

937

How to define a procedure inside another procedure?

961

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.

2045

What is a synonym? What are its various types?

1043

what is difference between sql plus and sql*plus? (not sql and sql plus).

3813

How can you use check constraints for self referential integrity?

916

Is the After report trigger fired if the report execution fails ?

2877

Explain the use of rows option in imp command.

1041

What are the differences between char and nchar in oracle?

1021

What is oracle thin client?

973

Â How to use an oracle sequence generator in a mapping?

1018

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