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 3954

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

1587

How collections are improve the performance?

Polaris,

1 4227

How to find locks exists in a table or not?

HCL,

1 3396

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

1567

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

Ardee Technologies, HCL,

2 5310

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,

1726

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

TCS,

1595

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

TCS,

1556

Un-Answered Questions { Databases }

What is max_used_connections in mysql?

914

If any stored procedure is encrypted, then can we see its definition in activity monitor?

953

How to define Data Block size in Oracle?

1084

What is Data Independence?

865

What are the ways on commenting in a pl/sql code?

1081

How to prevent firebird.log file from filling up the disk partition?

881

List some comparisons operators used in mysql?

947

What is a file in a database?

827

What is the federation in sql azure?

What is a raid and what are different types of raid configurations?

1226

What is the master or primary key in mongodb?

when All datafiles related to a Tablespace are removed ?

1865

What are date and time data types in mysql?

975

How does a database store data?

899

What is difference between index and primary key?

1059

For More Un-Answered { Databases } Questions Click Here