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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to define a data field as not null?

1071

How to enter a new row into a table interactively?

971

How to build data dictionary view an new database?

968

How to get a create statement for an existing table?

918

How to pass parameters to procedures?

983

How to use "in" parameter properly?

1011

How to run create database statement again?

1090

How to run queries on external tables?

996

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

1027

How to rename a column in an existing table?

983

How to view existing locks on the database?

1005

How much memory your 10g xe server is using?

1059

How to recover a dropped index?

1 1501

How to assign values to data fields in record variables?

979

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

1030

Un-Answered Questions { Oracle }

What is not equal to in oracle?

959

Explain an integrity constrains?

1092

How does one coalesce free space?

514

Explain how can you use the same lov for 2 columns?

1088

How can you merge two tables in oracle?

943

Can we create database in oracle using command line ?

1039

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

1108

Are These Dff's Flexible?

1128

How to start a specific oracle instance?

1000

In the oracle version 9.3.0.5.0, what does each number shows?

1240

What do you understand by recovery catalog?

530

What is bulk copy or bcp in oracle?

1060

Can a formula column be obtained through a select statement ?

2274

Which is better Oracle or MS SQL? Why?

4844

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2217

For More Un-Answered { Oracle } Questions Click Here