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 merge in oracle?

1058

What is a proxy class?

1059

What is a proxy object?

1071

What is dynamic proxy?

1012

What is proxy method?

976

What is primefaces used for?

1053

Can we insert data in view oracle?

1045

Is oracle an operator?

932

What is not equal to in oracle?

1004

What is set operator oracle?

987

What is where clause in oracle?

1032

Which is faster join or subquery in oracle?

999

What is a lookup table in oracle?

974

How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base

1 1663

How to resolve the ORA-39133 error in Oracle?

1126

Un-Answered Questions { Oracle }

How to load data from external tables to regular tables?

1063

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1170

Explain the use of full option in exp command.

1117

List five most important parameter in 9i affecting performance?

571

What is control file used for?

1214

how to join query for one source type is oracle another source type is sql server ?

2429

How to create additional tablespaces for an new database?

1031

How can you find all the processes on your system?

576

What are the uses of Oracle Rollback Segment?

1131

Is oracle an operator?

932

Can we use bind variables in oracle stored procedure?

957

Explain compound trigger in oracle?

1047

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1396

Can we protect our pl/sql source code?

1049

Explain the use of record option in exp command.

1007

For More Un-Answered { Oracle } Questions Click Here