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

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 17630

Describe the P2P cycle ?

1 3655

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 6101

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

Oracle,

2040

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

Oracle,

1 4566

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

1 3028

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

2 10506

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

3 7073

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

2326

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 4978

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

1 3476

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

2 8514

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 5432

HCL,

2 5251

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

5 7637

Un-Answered Questions { Oracle }

Is rowid unique in oracle?

996

How to create a new table in your schema?

1078

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2057

What is oracle archived redo log?

586

What are the functions of administration?

549

What is the most common database language that a db administrator needs to know?

566

How to rebuild an index in oracle?

1023

Can we call procedure inside function in oracle?

1078

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

596

How can you determine if an index needs to be dropped and rebuilt?

560

Explain the process of recievables in oracle financials. : oracle accounts receivable

1151

What is the max number of columns in an oracle table?

994

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2022

Is oracle an open source?

1073

What is the purpose of a staging area?

For More Un-Answered { Oracle } Questions Click Here