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?

1070

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?

1039

What is a recycle bin in oracle?

1 1579

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?

1045

How to open and close an explicit cursor in oracle?

1058

Un-Answered Questions { Oracle }

What is an Oracle SYSTEM tablespace and when is it Created?

1115

How view is different from a table?

1035

What does >> do?

585

What is data store? How to create data store?

633

What are the uses of Oracle Rollback Segment?

1125

How do you use automatic pga memory management with oracle 9i and above?

589

What is an oracle transaction?

1145

How do I know if oracle is installed on windows?

931

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

What privilege is needed for a user to connect to oracle server?

994

how to write the procedures in odi?

726

How to call a sub procedure?

1093

What is the use of the Service Knowledge module?

588

Explain mutating triggers.

1028

How to Truncate Table in Oracle

1154

For More Un-Answered { Oracle } Questions Click Here