1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

write a query that displays every Friday in a year with date?

Flipkart, HCL, TCS,

5 4768

display null value rows with out using null function?

Infosys,

8 7939

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

HCL,

1 3381

How to find the count of letter "L" in HELLO

HP,

7 6299

What is Temp Table and type of temp table?

HP, SLK,

1 1997

What is user define exception and example

HP, KP,

1 3193

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 3205

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

 1148

How collections are improve the performance?

Polaris,

1 3509

How to find locks exists in a table or not?

HCL,

1 2526

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

 1098

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

Ardee Technologies, HCL,

2 4295

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,

1250

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

TCS,

1124

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

TCS,

1088

Un-Answered Questions { Databases }

What is oracle in java?

515

What is the main purpose of triggers in database?

443

What is mysql used for?

510

Can I create table without primary key?

520

Which are the two editions in which SQL Azure database available?

99




How to backup encryption key ?

123

what is a record in a database ? : Sql dba

560

How to bring a tablespace online?

508

Tell me what is a linked server?

556

What is rank () in sql?

522

What is data set in report?

95

Define concurrency control. : Transact sql

579

What is difference between rownum and row_number?

506

Explain vdl (view definition language)?

634

How to load a csv file into a table

536

For More Un-Answered { Databases } Questions Click Here