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?

1093

What do you mean by Oracle MEDIA RECOVERY?

1186

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

1186

Can a Tablespace hold objects from different Schemes in Oracle?

999

What is an Oracle Rollback Segment?

1077

What is an Oracle Data Dictionary?

1065

What is an Oracle Data Segment?

1007

Can a View based on another View in Oracle?

995

What is the function of Redo Log in Oracle?

1154

How to define Data Block size in Oracle?

1084

What is an Integrity Constrains in Oracle?

1154

What are Oracle Schema Objects?

1067

What is an oracle database schema?

1090

What are the uses of Oracle Rollback Segment?

1092

What is an Oracle Data Block?

1020

Un-Answered Questions { Oracle }

Explian File steps in ODI?

593

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

1003

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1868

Explain database link?

1072

What are the different types of database objects?

1016

key flexfield structure

2128

How to view the tablespaces in the current database?

936

How to declare a local variable?

1071

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1995

Explain the use of record option in exp command.

957

How to check database size in Oracle?

1147

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2306

What are four common errors found in an alert .log?

519

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2070

Explain what are the different type of segments?

923

For More Un-Answered { Oracle } Questions Click Here