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

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

1034

How data locks are respected in oracle?

1072

What is program global area (pga) in oracle?

1031

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

1047

How to list all user accounts in oracle?

1029

What are dml statements in oracle?

1095

How to end the current transaction in oracle?

1031

What is the implicit cursor in oracle?

1108

How to use like conditions in oracle?

1059

How to define an explicit cursor in oracle?

1041

What is a recycle bin in oracle?

1 1584

How to select an oracle system id (sid)?

1064

What is a user role in oracle?

1132

How to omit columns with default values in insert statement in oracle?

1049

How to open and close an explicit cursor in oracle?

1058

Un-Answered Questions { Oracle }

Point out the difference between user tables and data dictionary?

986

How can you use check constraints for self referential integrity?

971

How to synchronize 2 schema's objects?

2183

Mention what is the function of cache fusion in oracle rac?

what are bitmap indexes? How does they work?

2259

What is save point in oracle database?

1298

what is load plans and types of load plans?

620

Can we write dml statement in function in oracle?

1087

What is ole activation style property?

What is system tablespace?

1101

What are the execution control statements?

1069

how to do daily transactions with out sql* loader control file regesterd in apps?

1687

What are the IKM types?

679

What does a senior database administrator do?

611

Can we create trigger on materialized view in oracle?

995

For More Un-Answered { Oracle } Questions Click Here