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?

811

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

811

How to loop through data rows in the implicit cursor?

826

How to create additional tablespaces for an new database?

802

How many categories of data types?

770

Can you assign multiple query result rows to a variable?

768

How to use fetch statement in a loop?

793

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

804

How do I learn what codesets are available in oracle?

795

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

800

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

824

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

873

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

800

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

763

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

854

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle wallet?

692

How to drop an existing view in oracle?

760

How to drop an index?

744

What is the relation of a user account and a schema in oracle?

857

How to insert a new row into a table in oracle?

861

Explain an index?

895

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

892

What are the tools for Oracle ?

827

How do I reset a sequence in oracle?

853

How do I uninstall oracle client from windows?

757

Explain alias?

914

Explain about integrity constraint?

887

State some uses of redo log files?

776

What is java oracle used for?

781

Can you assign multiple query result rows to a variable?

768

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