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 define a procedure inside another procedure?

1067

What to do if the binary spfile is wrong for the default instance?

1108

How to create a server parameter file?

1188

How to rename an existing table?

1217

What are the execution control statements?

1107

How to run create database statement?

1079

What happens if the update subquery returns multiple rows?

1169

How to use "startup" command to start default instance?

1101

What happens if the imported table already exists?

1077

How to create a stored program unit?

1320

How to call a stored function with parameters?

1095

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

1124

How to assign a table row to a record variable?

1091

How to define an anonymous procedure with variables?

1239

How to declare a local variable?

1173

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is IDE,DMV in sql server?

2880

How to define default values for formal parameters?

1094

What is the difference between primary key and unique key and foreign key in oracle?

1035

What is oracle and what are its different editions?

1119

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

interview questions with answer for cts

2635

Differentiate between translate and replace?

1188

What are the oracle differences between nvl and coalesce

1233

What is connection pool in oracle?

1036

Explain the use of indexes option in imp command.

1261

How many types of auditing in Oracle?

1086

What is a package ? What are the advantages of package ?

1136

How do I spool in oracle?

1062

How to set up autotrace for a user account?

1112

What is format trigger?

2120

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