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

Explain can a view based on another view?

1 1515

Explain what are the advantages of views?

1069

Explain what are clusters?

1108

Explain a data segment?

1067

Explain what are the uses of rollback segment?

1013

What is sequence?

1081

Explain what are the characteristics of data files?

1084

Explain how are indexes update?

1064

Explain table?

1114

Explain what are the type of synonyms?

1111

Explain what are synonyms used for?

1034

Explain a segment?

1084

Explain database link?

1119

Explain an integrity constrains?

1147

Explain the use of control file?

1113

Un-Answered Questions { Oracle }

Difference between negative and positive adjustments : oracle accounts receivable

1104

How to delete multiple rows from a table in oracle?

1060

How to list all indexes in your schema?

1093

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1090

What Are Cross Validation & Adi?

1157

How to pass a parameter to a cursor in oracle?

1178

How to run create database statement again?

1154

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2327

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

1035

How can Oracle users be audited?

1115

How would you identify the shared_pool_size parameter that needs to be adjusted?

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

1156

What is Sequences?

630

What are the varoius components of physical database structure of oracle database?

1006

What is a table in oracle?

980

For More Un-Answered { Oracle } Questions Click Here