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 delete a column in an existing table?

1030

How to use an explicit cursor without open statements?

1020

Can multiple cursors being opened at the same time?

1026

How to invoke the data pump import utility?

1089

How to pass a cursor variable to a procedure?

1056

How to view the data files in the current database?

1053

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

1051

What are the logical operations?

1073

How to list all indexes in your schema?

1045

What is the data pump export utility?

1031

How to create a new table in your schema?

1046

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

1007

How to see free space of each tablespace?

984

How to use "out" parameter properly?

1036

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

979

Un-Answered Questions { Oracle }

What is bulk copy or bcp in oracle?

1063

What suggestions do you have to reduce the network traffic?

912

3. Steps in UAT?

2379

What is transactional trigger property?

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2153

Oracle Data Integrator Interview Questions and answers?

616

Can sub procedure/function be called recursively?

956

What is the difference between "as" and "is" in an oracle stored procedure?

952

Is oracle an open source?

1033

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1952

What is an artificial (derived) primary key?

571

What is the string concatenation operator in oracle?

1111

How to create an initialization parameter file?

998

How to write a query with a left outer join in oracle?

1013

What are the roles of dba?

1032

For More Un-Answered { Oracle } Questions Click Here