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?

1226

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

1222

Can a Tablespace hold objects from different Schemes in Oracle?

1044

What is an Oracle Rollback Segment?

1119

What is an Oracle Data Dictionary?

1111

What is an Oracle Data Segment?

1044

Can a View based on another View in Oracle?

1029

What is the function of Redo Log in Oracle?

1219

How to define Data Block size in Oracle?

1111

What is an Integrity Constrains in Oracle?

1188

What are Oracle Schema Objects?

1113

What is an oracle database schema?

1124

What are the uses of Oracle Rollback Segment?

1127

What is an Oracle Data Block?

1062

Un-Answered Questions { Oracle }

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

What is the easiest method to create a file on unix?

570

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

Is oracle a programming language?

986

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2123

What is the maximum limit on the number of columns in a table?

1086

How to write date and time interval literals in oracle?

1035

Give the advantages and disadvantages of clusters.

1050

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1126

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How to open a cursor variable?

1035

did u received a single file or multiple files

2019

What are the extensions used by oracle reports?

1037

What is the oracle implicit cursor?

1063

What is a staging area? Do we need it?

For More Un-Answered { Oracle } Questions Click Here