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 4039

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

1636

How collections are improve the performance?

Polaris,

1 4298

How to find locks exists in a table or not?

HCL,

1 3466

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

1611

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

Ardee Technologies, HCL,

2 5414

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,

1787

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

TCS,

1640

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

TCS,

1603

Un-Answered Questions { Databases }

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1042

What stored by the msdb? : sql server database administration

1003

What is triggers in ms sql server?

1119

What is the command which are use to drop database in mongodb?

How do you run ms_batch file in forms?

What is considered a database?

1000

What is onf in normalization form?

1056

How do I find the database name in mysql?

953

Is sql open source?

979

How many types of database triggers exist?

1135

How to find the source of a table in sql server?

997

What are the column comparisons operators?

1238

Explain the terms specialization and generalization.

949

What is "scheduled jobs" or "scheduled tasks"?

979

What is a native sql query?

1072

For More Un-Answered { Databases } Questions Click Here