Databases Interview Questions
Questions Answers Views Company eMail

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

Flipkart, TCS, HCL,

5 2428

display null value rows with out using null function?

Infosys,

8 3529

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

HCL,

1 1977




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

HP,

6 3025

What is Temp Table and type of temp table?

HP, SLK,

634

What is user define exception and example

HP, KP,

1 1638

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 1744

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

512

How collections are improve the performance?

Polaris,

1 1790

How to find locks exists in a table or not?

HCL,

1 1177

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

433

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

HCL, Ardee Technologies,

2 2490

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,

524

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

TCS,

465

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

TCS,

445







Un-Answered Questions { Databases }

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

1154


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

743


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

802


How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?

1827


whats the maximum size of view state??

986






3. Steps in UAT?

1060


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

905


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

838


where the dff data will be stored

1100


dear sir please provide what question will be asked in CWE in bank it officer

1209


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4828


default triggers available for reports

1028


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

1408


give a simple example of physical and logical data independence

1369


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2528