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 insert multiple rows with one insert statement in oracle?

1086

How to connect ms access to oracle servers?

1006

How to delete all rows a table in oracle?

1068

What is a parameter file in oracle?

1134

Can the query output be sorted by multiple columns in oracle?

992

Can group functions be used in the order by clause in oracle?

998

What is a static data dictionary in oracle?

1112

How to assign a tablespace to a users in oracle?

1048

How to drop an existing table in oracle?

1058

What is an oracle data file?

1103

How to revoke create session privilege from a user in oracle?

1018

What is a database table in oracle?

1022

What is an oracle recycle bin?

1009

How to use existing values in update statements using oracle?

1067

Can multiple columns be used in group by in oracle?

988

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use fetch statement in a loop?

1019

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

982

What are oracle functions?

1030

Explain cascading triggers.

1073

What are a cluster and non-cluster index?

1018

What is an Oracle index?

1655

what is port in oracle? how is it related to database application.

1949

State some uses of redo log files?

1007

How to define a procedure inside another procedure?

1024

How to define and use table alias names in oracle?

943

In oracle there is column command, how will you explain that?

1055

What is a trigger and what are its types in oracle?

1072

What is the difference between pre-select and pre-query?

1219

types of indexes and the rationale behind choosing a particular index for a situation.

2510

Explain the use of consistent option in exp command.

1066

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