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 find & delete duplicate rows from two different tables?

3 11994

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

3053

plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example

2 16052

• What is oracle Architecture?

3 6564

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

Amazon, HCL,

3 8878

how to hide the scroll bar in forms 6i

2 13608

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 3524

How can I sum column wise in Oracle excel report?

1 5888

how to retrieve 1st and last row of table without using group functions??

6 8931

How to Identify the previously inserted/updated records in already populated table.

2776

Which is the cheapest and quality Oracle Education provider in Bangladesh?

1 3771

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

TCS,

2 5152

without using count(*) and rownum how can we count total record in a table

AC, HP,

5 10410

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

BirlaSoft,

2 5953

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2312

Un-Answered Questions { Oracle }

What is primefaces used for?

1102

Why we use bulk collect in oracle?

1121

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

1068

What is the Tune Query

2347

What is connection pooling in oracle?

1021

Explain the use of full option in exp command.

1179

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2764

How to invoke the data pump export utility?

1260

What do you understand by redo log file mirroring?

Explain procedure to change characterset of a database.

683

How to do clean up if create database failed?

1073

What privilege is needed for a user to delete rows from tables in another schema?

1142

Is insert autocommit in oracle?

1134

How to unlock the sample user account in oracle?

1079

Explain mutating triggers.

1091

For More Un-Answered { Oracle } Questions Click Here