Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

1172

What do you mean by Oracle MEDIA RECOVERY?

1286

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

1272

Can a Tablespace hold objects from different Schemes in Oracle?

1088

What is an Oracle Rollback Segment?

1168

What is an Oracle Data Dictionary?

1165

What is an Oracle Data Segment?

1100

Can a View based on another View in Oracle?

1075

What is the function of Redo Log in Oracle?

1276

How to define Data Block size in Oracle?

1172

What is an Integrity Constrains in Oracle?

1239

What are Oracle Schema Objects?

1163

What is an oracle database schema?

1168

What are the uses of Oracle Rollback Segment?

1179

What is an Oracle Data Block?

1121

Un-Answered Questions { Oracle }

What should a dba know?

573

Can a formula column be obtained through a select statement ?

2382

What do you mean by database normalization and why is it important?

What is the Tune Query

2347

What are the limitations oracle database 10g xe?

1099

Why cursor variables are easier to use than cursors?

1147

How many databases should a dba manage?

697

You see a wait on lms process in statspack, what does that mean?

617

What is BBED in Oracle?

1201

What are the Types of Scd's?

630

Why we use bulk collect in oracle?

1121

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1793

How do we create privileges in oracle?

1103

What are the types of locks in database?

660

How to create a stored procedure in oracle?

1156

For More Un-Answered { Oracle } Questions Click Here