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

How to find the date and time of last updated table?

4 6998

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2227

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 4775

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 16865

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6954

Could you please let me know the interfaces in OM / FA??

Oracle,

2254

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com

5 7825

how to display last 5 letters from a name (take emp table ename )

IBM,

6 10197

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

IBM,

6 10115

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

2015

How can we create the complete backup of data in the oracle.

IPEC, Satyam, SunTec,

2151

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

Satyam,

3 7023

How the log writer writes the data into database

Baidu, Satyam,

4 7754

what is the role of archiever

Baidu, Satyam, TCS,

4 8588

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 10779

Un-Answered Questions { Oracle }

What are a query and state the different types of queries and their uses?

1011

What is a package ? What are the advantages of package ?

1085

What are the types of partitions in oracle?

1034

What is an oracle wallet?

937

What happens to the indexes if a table is recovered?

989

Explain master-detail relationship with some examples.

1003

How to assign values to variables?

1095

How to set a transaction to be read only in oracle?

1091

How many memory layers are in the oracle shared pool?

1176

What degree do database administrators need?

544

Explain the different levels at which oracle form services interact.

1045

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2185

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4613

what we specify the in XML data server and parameters for to connect to xml file?

696

how to write the sub-queries in odi?

701

For More Un-Answered { Oracle } Questions Click Here