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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a initialization parameter file in oracle?

1035

How to unlock the sample user account in oracle?

1016

How to rollback the current transaction in oracle?

1054

What are the differences between date and timestamp in oracle?

1046

How to pass parameters to procedures in oracle?

1042

What is system global area (sga) in oracle?

991

How to delete an existing row from a table in oracle?

1072

How to write numeric literals in oracle?

1182

How to write a query with a full outer join in oracle?

1 1472

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

1034

How data locks are respected in oracle?

1071

What is program global area (pga) in oracle?

1030

How to write an inner join with the where clause in oracle?

1044

How to list all user accounts in oracle?

1027

What are dml statements in oracle?

1095

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is there an oracle sql query that aggregates multiple rows into one row?

978

What do you mean by redo log file mirroring?

1032

How different is ms access and oracle?

1038

Explain the use of Merge statement in oracle 11g

1027

What is the usage of merge statement?

1154

Please explain joins in oracle?

1062

Explain the use of analyse option in exp command.

1128

What happens to the data files if a tablespace is dropped?

1059

What is the difference between count (*), count (expression), count (distinct expression)?

1005

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

Explain mutating triggers.

1029

What are the components of logical database structure in oracle database?

1088

What is the implicit cursor in oracle?

1105

What are the various constraints used in oracle?

1045

how to join query for one source type is oracle another source type is sql server ?

2425

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