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 4043

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

1639

How collections are improve the performance?

Polaris,

1 4300

How to find locks exists in a table or not?

HCL,

1 3467

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

1617

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

Ardee Technologies, HCL,

2 5418

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,

1788

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

TCS,

1642

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

TCS,

1605

Un-Answered Questions { Databases }

How many types of triggers exist in pl/sql?

1075

What are the advantages of mongodb?

What is a record in a database?

1065

What does it mean to manipulate data?

1002

what is meant by urlencode and urldocode? : Sql dba

1178

How do I view tables in mysql?

986

Explain unique key in sql server?

1013

Does varchar need length?

999

What do you mean by catalog?

868

How to create table show example

981

What is dbcc command in sql server?

1096

What are the data management skills?

555

What are the steps you can take to avoid “deadlocks”?

978

When would you use a before or after trigger?

912

how can you initialize log miner?

1150

For More Un-Answered { Databases } Questions Click Here