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 is an oracle transaction?

1075

How to find out what privileges a user currently has in oracle?

1 1442

What are the limitations oracle database 10g xe?

994

How to start an oracle instance?

968

How to find out what oracle odbc drivers are installed?

993

How to empty your oracle recycle bin?

997

How to add a new column to an existing table in oracle?

1100

How to select all columns of all rows from a table in oracle?

1015

What is a server parameter file in oracle?

1019

How to use subqueries with the exists operator in oracle?

984

How to use values from other tables in update statements using oracle?

1041

How to recover a dropped table in oracle?

996

How to convert characters to times in oracle?

977

Where are the settings stored for each instance in oracle?

1076

What is an oracle cursor variable?

1026

Un-Answered Questions { Oracle }

What is oracle open database communication (odbc)?

981

Explain the use of compress option in exp command.

982

What is oracle used for?

986

What is CDC and explain complete CDC process flow?

545

What would you do with an in-doubt distributed transaction?

1932

Explain the wait events in statspack report 'enqueue'?

538

Mention what is the difference between single instance environment and rac environment?

Discuss row chaining, how does it happen? How do you correct it?

505

Why are recursive relationships bad? How do you resolve them?

537

Why do you use stored procedures and state some of its disadvantages?

984

What is blob data type in oracle?

1061

How can windows applications connect to oracle servers?

1007

Differentiate between function and procedure in oracle.

1032

How to select some columns from a table in oracle?

1023

Why is oracle so popular?

947

For More Un-Answered { Oracle } Questions Click Here