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?

841

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

824

How to loop through data rows in the implicit cursor?

852

How to create additional tablespaces for an new database?

822

How many categories of data types?

792

Can you assign multiple query result rows to a variable?

788

How to use fetch statement in a loop?

811

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

825

How do I learn what codesets are available in oracle?

810

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

828

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

839

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

887

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

820

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

779

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

876

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a single index for multiple columns?

796

What are the differences between char and varchar2 in oracle?

851

How to create a new user account in oracle?

817

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

779

What is oracle server autotrace in oracle?

889

Explain what are the uses of rollback segment?

810

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2026

Whats the benefit of dbms_stats over analyze?

1739

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

827

How to delete multiple rows from a table in oracle?

833

What is ordinary table in oracle?

860

Explain self joins in oracle?

789

How to export data to a csv file?

889

what are actual and formal parameters?

826

Explain what are the type of synonyms?

878

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