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?

1072

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

1039

How to connect the oracle server as sysdba?

1076

What is a cursor in oracle?

1172

How to calculate date and time differences in oracle?

1041

What is a select query statement in oracle?

967

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?

1071

How to write numeric literals in oracle?

1182

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

1 1472

Un-Answered Questions { Oracle }

What happens to indexes if you drop a table?

1169

How to display employee records who gets more salary than the average salary in the department?

1065

How to convert characters to times in oracle?

1023

How many segment are present in Oracle Manufacturing

2320

Explain the use of log option in exp command.

1120

How to create sequence in odi?

649

How to create a table index in oracle?

1133

When do we use group by clause in a sql query?

1035

What is the relation between database and instance?

644

Does my odi infrastructure require an oracle database?

557

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

How to sort output in descending order in oracle?

1044

How to list all tables in your schema?

1053

What is max rowid in oracle?

1025

What is the difference between alert log file and tarce file ?

2172

For More Un-Answered { Oracle } Questions Click Here