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

What are the differences between number and binary_float in oracle?

1155

How to write date and time interval literals in oracle?

1087

How to drop a stored procedure in oracle?

1111

How to lock and unlock a user account in oracle?

1165

How to convert characters to numbers in oracle?

1116

What are the differences between blob and clob in oracle?

1139

What privilege is needed for a user to create tables in oracle?

1000

How to drop an existing view in oracle?

995

What happens if you set the sga too low in oracle?

1229

How to delete multiple rows from a table in oracle?

1119

How to create a table index in oracle?

1186

What is an oracle function?

1246

How to use subqueries in the from clause in oracle?

1170

What privilege is needed for a user to create indexes in oracle?

1086

How to create a new table in oracle?

1239

Un-Answered Questions { Oracle }

Explain oracle’s system global area (sga).

1189

What do you mean by redo log file mirroring?

1072

What is the difference between truncate and delete? Why is one faster?

704

How to start your 10g xe server from command line?

1133

How to assign values to data fields in record variables?

1084

What is the function of having virtual internet protocol address (vip) in oracle rac?

What do you mean by oracle database?

608

what are actual and formal parameters?

1166

What do you mean by a tablespace?

1092

How to start instance with a minimal initialization parameter file?

1085

How to clone the database using RMAN back

2322

How remove data files before opening a database?

1135

What do you understand by the term 'normalization'? Explain the various modes of normalization?

598

How can windows applications connect to oracle servers?

1122

In topology manager where the data are stored?

728

For More Un-Answered { Oracle } Questions Click Here