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 db_recovery_file_dest in oracle? When do you need to set this value?

1125

What do you mean by Oracle MEDIA RECOVERY?

1232

What is the disk migration? what is the steps involved in oracle disk migration?

1225

Can a Tablespace hold objects from different Schemes in Oracle?

1048

What is an Oracle Rollback Segment?

1126

What is an Oracle Data Dictionary?

1119

What is an Oracle Data Segment?

1057

Can a View based on another View in Oracle?

1037

What is the function of Redo Log in Oracle?

1221

How to define Data Block size in Oracle?

1117

What is an Integrity Constrains in Oracle?

1192

What are Oracle Schema Objects?

1118

What is an oracle database schema?

1127

What are the uses of Oracle Rollback Segment?

1131

What is an Oracle Data Block?

1078

Un-Answered Questions { Oracle }

How to pass a cursor variable to a procedure?

1115

What is a cursor in oracle?

1186

Explain the difference between repeating frame and frame.

Why is oracle so popular?

1009

key flexfield structure

2183

How can we tune a sql query to optimize the performance of a database?

Why should I use oracle database?

1000

What is concurrency in oracle?

1013

difference of using cursor for loop and open,fetch,close.which one is better

1809

What is a nested table and how is it different from a normal table?

1061

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

614

What is oracle real application clusters?

How to load data through external tables?

1142

How many concurrent programs you have customized, can you name some of them?

What is the max number of columns in an oracle table?

1003

For More Un-Answered { Oracle } Questions Click Here