Databases Interview Questions
Questions Answers Views Company eMail

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 890

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

1 1498

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 994




4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 757

7. Where would you look for errors from the database design?

Fintellix,

1 1044

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

316

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

296

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

341

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

236

Whis is not false in primary key?

Fintellix,

297

Can we call a function that has out parameter in select statement

Nagarro,

175

Call by value and call by reference in procedure and function, with NOCOPY.

Nagarro,

242

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

267

Delete duplicate rows without using rowid.

Nagarro,

285

What is Histogram?

NIIT,

390







Un-Answered Questions { Databases }

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

877


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

912


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

736


defination of bitmap index

964


How do you tell what your machine name is and what is its IP address?

811






in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1090


What would you do with an "in-doubt" distributed transaction?

794


how to do daily transactions with out sql* loader control file regesterd in apps?

527


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

983


What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

383


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1118


1 01 101 01010

845


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1275


how to handle exceptions in post production

316


How can we check whether A S M instance is up or down?

1460