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 do a full database export?

1108

How to bring a tablespace online?

1079

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

1020

What is the relation of a user account and a schema?

1134

How many file formats are supported to export data?

1220

Why cursor variables are easier to use than cursors?

1094

How to insert a record into a table?

1070

How to define a variable to match a table column data type?

988

How to invoke the original export import utilities?

1064

What is the difference between formal parameters and actual parameters?

1088

How to view the dropped tables in your recycle bin?

1 1480

How to define an anonymous procedure without variables?

1107

How many data types are supported?

1079

How to connect to the server with user account: sys?

1017

How to define default values for formal parameters?

1044

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is object data modeling?

965

How to create a new oracle data file?

1032

Explain the use of show option in imp command.

1098

How to concatenate two text values in oracle?

1113

How to update a table row with a record?

1008

What is analyze command used for?

1072

Design database draw er diagram for a certain scenario ?

4579

How can you use check constraints for self referential integrity?

969

Explain integrity constraints?

1104

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4594

What are nested tables?

1174

State the various uses of dbcc command?

1060

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

1065

What happens if you use a wrong connect identifier?

1065

How to rename a column in an existing table?

1035

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