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

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

Oracle Interview Questions

Questions Answers Views Company eMail

How to delete a column in an existing table?

1134

How to use an explicit cursor without open statements?

1103

Can multiple cursors being opened at the same time?

1119

How to invoke the data pump import utility?

1235

How to pass a cursor variable to a procedure?

1160

How to view the data files in the current database?

1154

How to turn on or off recycle bin for the session?

1180

What are the logical operations?

1174

How to list all indexes in your schema?

1148

What is the data pump export utility?

1137

How to create a new table in your schema?

1134

What happens to the data files if a tablespace is dropped?

1110

How to see free space of each tablespace?

1084

How to use "out" parameter properly?

1128

Can you drop an index associated with a unique or primary key constraint?

1074

Un-Answered Questions { Oracle }

material view and view disadvantages?

1130

What are the constraints in odi?

664

What is recovery manager in Oracle?

1115

Is a rollback possible to any savepoint?

1160

How to commit the current transaction in oracle?

1191

What is translate in oracle?

1147

Explain the use of parfile option in exp command.

1146

If you are working Microsoft excel, which type of file you used .excel or .csv?

683

How do I connect to oracle database?

1204

How to sort the query output in oracle?

1077

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2337

Explain force logging feature in 9i.

654

What is a table in oracle?

1024

How to drop an index in oracle?

1122

did u p prepared complex report

2054

For More Un-Answered { Oracle } Questions Click Here