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 to do if dba lost the system password?

1172

How to define a record variable to store a table row?

1058

What happens if variable names collide with table/column names?

1191

How to start instance with a minimal initialization parameter file?

1040

How to start your 10g xe server?

1041

How to establish administrator authentication to the server?

1042

What is the quickest way to export a table to a flat file?

968

How to loop through a cursor variable?

1084

How to do clean up if create database failed?

1028

What happens if you lost a data file?

1034

How remove data files before opening a database?

1072

How to export data with a field delimiter?

1039

How to create an initialization parameter file?

1049

What to do if the startbd.bat failed to start the xe instance?

1080

How to view the tablespaces in the current database?

978

Un-Answered Questions { Oracle }

How to write text literals in oracle?

1068

What is oracle thin client?

1023

how to dynamically change the page size of d2k reports?

How to get execution statistics reports on query statements?

1094

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2195

what is the difference between restoring and recovering?

1011

What is oracle log switch?

619

Difference between bind parameter and lexical parameter.

What is a subquery in oracle?

1109

what is insert all statement in sql

6513

Explain constraining triggers.

1094

A scenario for amount correction & how to use amount correction functionality in AP invoices

2134

How to loop through a cursor variable?

1084

How to declare a local variable?

1115

How to shutdown your 10g xe server from command line?

1086

For More Un-Answered { Oracle } Questions Click Here