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

Oracle General Interview Questions

Questions Answers Views Company eMail

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 10200

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2366

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

Polaris,

1 5298

structural difference between bitmap and btree index ?

Infosys,

1 12132

What is format trigger?

2066

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 7336

How can we Update a table with out using UPDATE command?

1 5953

what is exact difference between drop and truncate table.

3 7212

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

10 15401

what are corelated subqueries

Global Infotech,

1 2802

who is the father of oracle and send chodd rules

ME,

4 18978

query to find the maximum no persons with same age(age colomn) from emp table

1 4804

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

4 7005

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

NIC,

2229

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 4777

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is PL/SQL ?

2051

What is a partition in oracle?

1118

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2101

How do I recompile a procedure in oracle?

962

What is merge in oracle?

1052

What is program global area (pga) in oracle?

1025

What is the string concatenation operator in oracle?

1175

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1106

How to define an explicit cursor in oracle?

1034

How different is ms access and oracle?

1036

What is a server parameter file in oracle?

1055

In oracle there is column command, how will you explain that?

1049

What is recovery manager in Oracle?

1052

What is the difference between "as" and "is" in an oracle stored procedure?

987

How will you identify oracle database software release?

1005

For More Un-Answered { Oracle General } Questions Click Here