Preguntas de entrevistas para Analista de datos sql

30

Preguntas de entrevista para Analista De Datos Sql compartidas por los candidatos

Preguntas de entrevista principales

Ordenar: Relevancia|Popular|Fecha
Heights Finance
Se le preguntó a SQL Report Developer/Data Analyst…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

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

Numerator

A Behavioral evaluation. Nothing difficult

Conduent

How many years of ex you have with Sql queries ?

Conduent

A couple of small sql queries to check skills ?

Viendo 1 - 10 de 30 preguntas de entrevista