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?

1079

How to run queries on external tables?

990

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

1020

How to rename a column in an existing table?

972

How to view existing locks on the database?

999

How much memory your 10g xe server is using?

1051

How to recover a dropped index?

1 1487

How to assign values to data fields in record variables?

975

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

1019

How to create tables for odbc connection testing?

1011

What is a named program unit?

1021

How to open a cursor variable?

974

What happens to indexes if you drop a table?

1112

How to test null values?

1044

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

968

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

1056

What is a cursor and what are the steps need to be taken?

1118

What is an oracle user role?

939

Who developed oracle & when?

945

what is Single Byte Overhead...?

2500

Can we store images in oracle database?

948

How can I see all tables in oracle?

951

IS it possible to built the oracle database without setting the kernal parameters?

2272

What is a sub query and what are the different types of subqueries?

1075

Explain the use of ignore option in imp command.

977

Does facebook use oracle?

981

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

How many file formats are supported to export data?

1139

What are the benefits of ordbms?

1024

What are the oracle differences between nvl and coalesce

1068

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