Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How to run create database statement again?

799

How to run queries on external tables?

768

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

759

How to rename a column in an existing table?

788

How to view existing locks on the database?

770

How much memory your 10g xe server is using?

809

How to recover a dropped index?

1 1177

How to assign values to data fields in record variables?

764

How to create a new table by selecting rows from another table?

824

How to create tables for odbc connection testing?

707

What is a named program unit?

782

How to open a cursor variable?

780

What happens to indexes if you drop a table?

907

How to test null values?

838

How to define a data source name (dsn) in odbc manager?

748

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is primary key indexed by default in oracle?

738

How to convert characters to numbers in oracle?

793

Is it possible to insert comments into sql statements return in the data model editor ?

2323

How to execute a stored program unit?

786

What are the tools for Oracle ?

799

How to bring a tablespace online?

735

Use of an integrity constraint is better to validate data. Explain

769

What exactly do quotation marks around the table name do?

720

if you ctreate table identity

2110

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

858

How many data types are supported?

812

How to empty your oracle recycle bin?

764

How to export several tables together?

777

How to synchronize 2 schema's objects?

1881

How to get maxsal , minsal, ename department wise in single query

1295

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