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?

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

How to end the current transaction in oracle?

1030

What is the implicit cursor in oracle?

1105

How to use like conditions in oracle?

1055

How to define an explicit cursor in oracle?

1040

What is a recycle bin in oracle?

1 1582

How to select an oracle system id (sid)?

1064

What is a user role in oracle?

1129

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

1046

How to open and close an explicit cursor in oracle?

1058

Un-Answered Questions { Oracle }

what systems can odi extract and load data into?

592

what are bind variables?

1087

Explain table?

1115

Give the different types of rollback segments.

1031

Step by step explain for the Flat file?

673

What is variable? What is Flow of variable?

620

What is oracle data type?

963

What is responsibility and how u attach How to create user and how u attach with responsibility.

2041

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

571

How to define default values for formal parameters?

1044

Differentiate between post-database commit and post-form commit?

1041

Explain the purpose of oracle real application clusters (rac)?

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

What is procedure overloading in oracle?

1061

What is set verify off in oracle?

1103

For More Un-Answered { Oracle } Questions Click Here