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 4038

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 4298

How to find locks exists in a table or not?

HCL,

1 3465

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 5413

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,

1786

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,

1603

Un-Answered Questions { Databases }

What is oracle dba role?

577

How you trouble shoot when any job fails

1937

what is cursor. write example of it. What are the attributes of cursor.

1391

Which dbms is best?

913

Can sql developer connect to db2?

1048

What are different types of statements supported by sql?

1165

What is pct free/pct used/pct increase parameter in segment?

576

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

885

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4008

Is mysql owned by oracle?

1017

How is myisam table stored?

964

How do we get field detail of a table?

1080

What are string functions in sql?

1240

What is the functionality and features provided by oracle clusterware?

What is the use of sql trace?

952

For More Un-Answered { Databases } Questions Click Here