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 create a stored program unit?

1321

How to call a stored function with parameters?

1098

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

1132

How to assign a table row to a record variable?

1097

How to define an anonymous procedure with variables?

1244

How to declare a local variable?

1178

What is a table index?

1172

How a database is related to tablespaces?

1084

How to define a specific record type?

1140

How to estimate disk space needed for an export job?

1110

How to use "if" statements on multiple conditions?

1219

What is the data pump import utility?

1081

How to update a table row with a record?

1070

What is an index associated with a constraint?

1094

What are the numeric comparison operations?

1170

Un-Answered Questions { Oracle }

How to select all columns of all rows from a table in oracle?

1105

What are the conditions kept in mind while connecting the oracle rac with the network?

Explain the purpose of forms_ddl.

Explain about the analyze command in oracle?

1113

what is Single Byte Overhead...?

2616

What is ODI console?

717

How to create a new oracle data file?

1078

Whats the benefit of dbms_stats over analyze?

2068

Can a parameter be passed to a cursor?

1183

How to use subqueries with the in operator using oracle?

1141

how do u setup a replication site?

2035

Can group functions be mixed with non-group selection fields?

1073

What is an oracle?

1069

Is there a combination of "like" and "in" in sql?

1124

What do you mean by merge in oracle?

1035

For More Un-Answered { Oracle } Questions Click Here