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

How to create a stored program unit?

1149

How to call a stored function with parameters?

985

How to turn on or off recycle bin for the instance?

1022

How to assign a table row to a record variable?

980

How to define an anonymous procedure with variables?

1085

How to declare a local variable?

1067

What is a table index?

1026

How a database is related to tablespaces?

995

How to define a specific record type?

1046

How to estimate disk space needed for an export job?

1001

How to use "if" statements on multiple conditions?

1123

What is the data pump import utility?

987

How to update a table row with a record?

975

What is an index associated with a constraint?

996

What are the numeric comparison operations?

1067

Un-Answered Questions { Oracle }

Can we use bind variables in oracle stored procedure?

911

What is the difference between cold backup and hot backup?

550

How many types of database software are there?

546

What is an external table?

969

How long does it take to learn database administration?

520

What is tns entry?

1073

Explain the difference between sap and oracle?

993

How do you install statspack?

645

How to name query output columns in oracle?

1145

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

519

What do you understand by the term 'normalization'?

633

How to start instance with a minimal initialization parameter file?

1000

Can we create database in oracle using command line ?

1039

How to download oracle database 10g xe?

966

How to define an anonymous block?

1091

For More Un-Answered { Oracle } Questions Click Here