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 Server Process?

2 6012

What is Cursor?

Virtusa,

2 6053

How many Dispatcher Processes are created?

1 4379

What constitute an ORACLE Instance?

2 6402

What is the function of checkpoint(CKPT)?

4 9346

What is function of RECO?

1 4544

Name the ORACLE Background Process?

3 14627

What do Redo Log Buffers contain?

2 5378

What Does DBWR do?

Honeywell,

2 7104

When Does DBWR write to the database?

6 22754

What is SGA?

3 6459

What is PGA?

5 8276

When does LGWR write to the database?

3 10652

What is a Parallel Server option in ORACLE?

1 4103

What is User Process?

1 4381

Un-Answered Questions { Oracle }

What are object group?

Explain a synonym?

1028

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

When should the default values for oracle initialization parameters be used as is?

672

How do you set up tablespaces during an oracle installation?

606

Is a rollback possible to any savepoint?

1094

Write a syntax for update query in oracle?

1034

What exactly do quotation marks around the table name do?

963

Which environment variables are absolutely critical in order to run the OUI?

2118

How to define an explicit cursor in oracle?

1039

How to drop an index in oracle?

1074

What are the variable types?

610

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

791

What are the types of data contol?

613

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2067

For More Un-Answered { Oracle } Questions Click Here