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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create a new view in oracle?

1078

How to insert a new row into a table in oracle?

1165

What is a database schema in oracle?

1110

What is open database communication (odbc) in oracle?

1003

How to drop an index in oracle?

1076

What is a read only transaction in oracle?

1029

How to insert multiple rows with one insert statement in oracle?

1086

How to connect ms access to oracle servers?

1007

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

Un-Answered Questions { Oracle }

When should you increase copy latches?

644

What is the difference between PFILE and SPFILE in Oracle?

1060

What is the anchoring in reports?

Explain how can you use the same lov for 2 columns?

1130

What is a server parameter file in oracle?

1058

How to change system global area (sga) in oracle?

1013

is there a tool to trace queries, like profiler for sql server?

1141

What is an oracle recycle bin?

1009

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

1084

What operating systems are supported by oracle database 10g xe?

1034

What is transport network substrate (tns) in oracle?

1047

What is table partitioning?

Is it possible to insert comments into sql statements return in the data model editor ?

2559

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

1072

What is the use of the drop option in the alter table command?

596

For More Un-Answered { Oracle } Questions Click Here