Databases Interview Questions
Questions Answers Views Company eMail

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

HCL, TCS, Flipkart,

5 2479

display null value rows with out using null function?

Infosys,

8 3617

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

HCL,

1 2014




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

HP,

6 3098

What is Temp Table and type of temp table?

HP, SLK,

653

What is user define exception and example

HP, KP,

1 1673

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 1795

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

536

How collections are improve the performance?

Polaris,

1 1835

How to find locks exists in a table or not?

HCL,

1 1205

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

453

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

HCL, Ardee Technologies,

2 2540

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,

549

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

TCS,

486

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

TCS,

470







Un-Answered Questions { Databases }

what is a package n what r the packages availbla in report

912


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

840


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

794


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

233


what is the scripts in data base?

898






How to do Stored procedure testing? Who does this testing (Developer or tester)?

759


What is the sql query to find the employee who has Nth maximum salary?

2660


What does GEQO stands for in PostgreSQL?

439


How to create Drill down report?

1008


internal architecture

1032


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1167


what is data access layer?

1232


I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

560


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

676


How do you use collections in procedure to return the resultset?

1119