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

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

HP,

3 17798

Describe the P2P cycle ?

1 3751

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 6218

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

Oracle,

2094

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

Oracle,

1 4688

How many Flexfields are there in AR and what are they ?

1 3106

What are User Exits and what are different types of User Exits in Oracle Apps ?

2 10667

What is an Invoice ? How many types of invoices are there in AP and AR ?

3 7240

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2373

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

Ion Exchange,

2 5090

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 3585

I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 8676

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

HCL,

3 5586

HCL,

2 5387

select * from emp what happened internally when we write this query in the sql prompt?

5 7867

Un-Answered Questions { Oracle }

How to convert characters to numbers in oracle?

1117

What is a nested table and how is it different from a normal table?

1115

Mention what is the difference between instance recovery and crash recovery?

Tell me step by step to enable Journalization?

680

What are the steps involved in instance recovery in oracle?

594

How to end the current transaction in oracle?

1077

What do we mean by record group in oracle forms?

1138

What to do if dba lost the system password?

1251

How does oracle handle read consistency?

1153

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2051

How to define an oracle cursor variable?

1094

20. Using a set operator, display the client number of all clients who have never placed an order.

2252

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What do you understand by row chaining?

Write a syntax for update query in oracle?

1076

For More Un-Answered { Oracle } Questions Click Here