Databases Interview Questions
Questions Answers Views Company eMail

write a query that displays every Friday in a year with date?

Flipkart, TCS, HCL,

5 2564

display null value rows with out using null function?

Infosys,

8 3741

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

HCL,

1 2077




How to find the count of letter "L" in HELLO

HP,

6 3226

What is Temp Table and type of temp table?

HP, SLK,

683

What is user define exception and example

HP, KP,

1 1736

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

Polaris, Metric Stream,

1 1879

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

565

How collections are improve the performance?

Polaris,

1 1937

How to find locks exists in a table or not?

HCL,

1 1252

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

490

If we update a complex view, is base table will get update ?

HCL, Ardee Technologies,

2 2641

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

TCS,

592

What the is the diff between local index and global index. give some example.

TCS,

513

What is snapshot is too old? Give and example for better understand.

TCS,

501







Un-Answered Questions { Databases }

What packages(if any) has oracle provided for use by developers?

3863


What is AUTH_ID and AUTH_USER in pl/sql ?

764


Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

751


What is snapshot is too old? Give and example for better understand.

501


What is format trigger?

973






code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1131


in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

1865


Which is the best place or learning center for MS SQL?????In Bangladesh?????

962


can u plz provide me oca sql dumps please i need them

807


Can anybody give me link for BOXI R3.1 Key please

1591


what is difference between view and Dip.

1287


what exactly u write in when_new_form_instance

2318


as a technical developer in oracle applications which type errors feced in your experience sofar

1247


what are bitmap indexes? How does they work?

1094


How can you plan the logshipping before processing?

1268