Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 7140

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

2289

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 4930

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

5 17095

why pl sql doesn't support retrieving multiple records

Mphasis,

1 7061

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

Oracle,

2346

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 7988

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

IBM,

6 10480

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

IBM,

6 10356

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

2072

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

IPEC, Satyam, SunTec,

2206

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

Satyam,

3 7179

How the log writer writes the data into database

Baidu, Satyam,

4 7952

what is the role of archiever

Baidu, Satyam, TCS,

4 8791

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

1 10884

Un-Answered Questions { Oracle }

How to increment dates by 1 in oracle?

1140

What is oracle rowcount?

1152

You have taken a manual backup of a datafile using os. How rman will know about it?

600

How can I get column names from a table in oracle?

1108

What does a dba do all day?

602

Can we insert data in view oracle?

1122

How to load data through external tables?

1192

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

663

What is an oracle cursor variable?

1133

How to make the project as .exe file in oracle forms & reports(d2k)?

What is dump destination? What are bdump, cdump and udump?

622

What are the predefined tablespaces in a database?

1150

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

742

How to select some rows from a table in oracle?

1130

What happens to the indexes if a table is recovered?

1050

For More Un-Answered { Oracle } Questions Click Here