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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to add a new column to an existing table in oracle?

1139

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

1052

What is a server parameter file in oracle?

1058

How to use subqueries with the exists operator in oracle?

1027

How to use values from other tables in update statements using oracle?

1079

How to recover a dropped table in oracle?

1048

How to convert characters to times in oracle?

1023

Where are the settings stored for each instance in oracle?

1105

What is an oracle cursor variable?

1075

How to change user password in oracle?

1029

How to create a new user account in oracle?

1020

How to start a specific oracle instance?

1037

What is a dead lock in oracle?

1122

What are the differences between char and varchar2 in oracle?

1170

How to pass a parameter to a cursor in oracle?

1178

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a table index in oracle?

1131

How to get a list of all background sessions in the database?

993

What is a directory object?

1097

How to pass a cursor variable to a procedure?

1109

What is a trace file and how is it created in oracle?

1058

What is procedure overloading in oracle?

1061

What are the differences between blob and clob in oracle?

1089

Can I create users through internet explorer in oracle 10g?

1084

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

1065

What is the difference between formal parameters and actual parameters?

1088

What is the difference between postgresql and oracle?

1048

What is a named program unit?

1082

How does one get the view definition of fixed views/tables?

1021

How to speed up webrick?

1076

what is the difference between functional dependecy and multilevel dependency?

2462

For More Un-Answered { Oracle General } Questions Click Here