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 are transaction isolation levels supported by oracle?

1015

How to write a query with an inner join in oracle?

993

How to connect the oracle server as sysdba?

1030

What is a cursor in oracle?

1125

How to calculate date and time differences in oracle?

1003

What is a select query statement in oracle?

917

What is a initialization parameter file in oracle?

998

How to unlock the sample user account in oracle?

945

How to rollback the current transaction in oracle?

1001

What are the differences between date and timestamp in oracle?

999

How to pass parameters to procedures in oracle?

1009

What is system global area (sga) in oracle?

946

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

1028

How to write numeric literals in oracle?

1141

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

1 1421

Un-Answered Questions { Oracle }

What is a tns service name?

960

what is a Nested Loop join?

2057

Why is oracle used?

897

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2304

did u p prepared complex report

1960

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

536

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2143

How to create Drill down report?

2085

What do you understand by format trigger?

What is oracle partial backup?

544

How many types of tables supported by oracle?

1033

What is a server parameter file in oracle?

1019

How many types of knowledge Modules? Where are used in km?

580

Explain a segment?

1039

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2120

For More Un-Answered { Oracle } Questions Click Here