Databases Interview Questions
Questions Answers Views Company eMail

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

Fintellix,

1 751

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 1182

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 828




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 635

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

Fintellix,

1 943

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?

257

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.

228

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

287

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

191

Whis is not false in primary key?

Fintellix,

249

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

Nagarro,

116

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

Nagarro,

187

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

Nagarro,

210

Delete duplicate rows without using rowid.

Nagarro,

232

What is Histogram?

NIIT,

339







Un-Answered Questions { Databases }

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

1049


what is the full procedure for using store procedure in informatica7.1?

1137


There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

1013


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1090


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

1222






You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

735


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1067


how can you attach more than 20 ldf files in sql server

867


WHAT KIND OF TOOL BO IS?

1148


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

141


How would you best determine why your MVIEW couldn't FAST REFRESH?

1154


Explain the Normalized Relations?

1612


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1097


if some data is not transfered where it will get stored

816


if i want to display the name of students such that to which city they belong must have count greaer than two

1044