Database Marketing Analyst Interview Questions
5K
Database Marketing Analyst interview questions shared by candidates
Explain to me what NPV means?
1 Answers↳
Net present value - sum of the present values of individual cash flows
Write an efficient stored procedure to allocate unique integer ids.
1 Answers↳
CREATEPROCEDURE [dbo].[AllocateUniqueIntIds] AS BEGIN SelectABS(CAST(CAST(NEWID()ASVARBINARY(5))ASBigint))as UniqueIntegerId END Go /* Test the store proc */ Exec [dbo].[AllocateUniqueIntIds] //Not sure if this is the correct answer Less
What are four economic factors used to mark economic progress
1 Answers↳
physical capital, natural capital, hum,an capital, and technological advancement
There were a lot of questions in relation to the inner workings of the files and file groups.
5 Answers↳
Thanks for your inputs. I feel very confident about SQL Server questions with 9 + years of experience.My worry is about the 1 hour online analytical test which is part of the f2f. Did you had them and any inputs you have on how to prepare for same. Less
↳
This was a pretty straight forward SQL test where you have to determine the output of some code or write some basic code based on table examples provide. There are a few pattern recognition questions as well. Less
↳
Was this position for MSSQL or Mysql?
How do java deal with hash collision?
4 Answers↳
link them
↳
There's quite an extended back and forth in actual interviews for questions like this, so there's no real replacement for actual practice. The Prepfully Comscore Database Developer experts have actually worked in this role, so they're able to do a propermock, which really puts you through the paces and lets you assess your readiness level. prepfully.com/practice-interviews Less
↳
By chaining
Remove duplicates from table
4 Answers↳
Using Rowid or Having clause
↳
hdfs dfs -rm /table/duplicates
↳
Delete from table group by empID having count(empID)>1
1.find second max salary hint using count
4 Answers↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Less
↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Less
↳
select max(Emp_Sal) from Employee a where 1 = ( select count(*) from Employee b where b.Emp_Sal > a.Emp_Sal) Less