Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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..

Metric Stream, Polaris,

1 4036

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

1634

How collections are improve the performance?

Polaris,

1 4295

How to find locks exists in a table or not?

HCL,

1 3462

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

1610

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

Ardee Technologies, HCL,

2 5411

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,

1785

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

TCS,

1638

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

TCS,

1602

Un-Answered Questions { Databases }

How would you convert date into julian date format?

1004

Does varchar need length?

991

What is file manager?

908

What is inner join? Explain with an example?

1221

Can we insert data into a view?

1136

what is a self join? : Sql server database administration

1038

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1044

What would happen if the both source and destination have the same name?

801

Can mongodb used for cache management?

Which are the third-party tools used in sql server and why would you use them?

911

I have applied the following commands: now what will happen, will the database will give an error / it will work?

548

What happens if strings are casted into wrong code pages in ms sql server?

1113

why not null is not allowed at table level

2759

What is model database? : sql server architect

884

What is __ v in mongoose?

For More Un-Answered { Databases } Questions Click Here