Preguntas de entrevista de Sql data analyst

30

Preguntas de entrevista para Sql Data Analyst compartidas por los candidatos

Principales preguntas de entrevista

Ordenar: Relevancia|Popular|Fecha
Heights Finance
A un SQL Report Developer/Data Analyst le preguntaron...31 de mayo de 2016

What is the difference between DELETE and TRUNCATE?

1 respuestas

Truncate is faster and there is no logging.

American Power and Gas

Write Queries using Join

1 respuestas

SELECT A.id, A.firstName, A.LastName , B. address1, B.address2. B.city FROM Person A JOIN Address B on A.id=B.id A.id is primary key on table Person and B.id is foreign key in table Address B Menos

Heights Finance

What do you do to optimize sql queries?

1 respuestas

Review nodes in execution plans on high cost. Review IO and Time statistics to get an idea of how many times a table is getting hit. Menos

CareerBuilder

They asked me the order of operations for an SQL query

1 respuestas

FROM clause WHERE clause GROUP BY clause HAVING clause SELECT clause ORDER BY clause Menos

Clover Imaging Group

Do you know SSRS reports

1 respuestas

Yes

Conduent

How many years of ex you have with Sql queries ?

Conduent

A couple of small sql queries to check skills ?

Institutional Shareholder Services

What are your experiences with SQL

Ipsos

If you have two excel sheets with this columns, how would you map it with the master excel sheet so that data can be extracted at that granular level

Locaria

How would you respond to a certain client request?

Viendo 1 - 10 de 30 Preguntas de entrevista

Consultar preguntas de entrevista para empleos similares

sql analystbusiness data analystsql server developerdata mining analyst