Programador Sql Interview Questions

SQL son las siglas de Structured Query Language (lenguaje de consulta estructurado) y un programador SQL es la persona encargada de crear bases de datos SQL y las aplicaciones que funcionan con ellas. Por lo general, utilizan tablas de diseño y recursos de almacenamiento para mayor estabilidad, fiabilidad y rendimiento. En una entrevista para un puesto de programador SQL, pueden hacerte preguntas sobre tus conocimientos de programación y habilidades de resolución de problemas.

Preguntas de entrevista más frecuentes para programador/a SQL y cómo responderlas

Question 1

Pregunta n.º 1: ¿Qué tipos de claves existen en SQL y cuándo las usarías?

How to answer

Respuesta recomendada: Esta pregunta te permite mostrar tus conocimientos de SQL. Explica los tipos más comunes de claves en SQL e indica cómo pueden identificar filas y columnas en las tablas. Las claves funcionan como identificadores únicos, lo que permite que los usuarios recuperen los datos con facilidad.

Question 2

Pregunta n.º 2: ¿Qué tipos de normalización existen en SQL y cuándo los usas?

How to answer

Respuesta recomendada: La normalización en SQL suele utilizarse para organizar datos y reducir redundancias. Puedes demostrar tu experiencia explicando los métodos de normalización que más usas. Por ejemplo, muchos programadores dividen una tabla grande en varias más pequeñas para facilitar la lectura.

Question 3

Pregunta n.º 3: ¿Con qué lenguajes de programación estás familiarizado?

How to answer

Respuesta recomendada: Muchos desarrolladores usan además JavaScript, HTML, Python, PL/SQL y otros lenguajes. Enumera los lenguajes que conoces y explica cómo los has usado en tu empleo anterior. Además, menciona los títulos de programación que posees.

711,030 programador sql interview questions shared by candidates

Write a function to find the maximum sum of sub array where the array can have negative and positive numbers.

Software Development Engineer In Test (SDET)

Interviewed at Microsoft

4★

Nov 30, 2009

Write a function to find the maximum sum of sub array where the array can have negative and positive numbers.

find duplicated item from an array, output the duplicated item with their times

Software Development Engineer In Test (SDET)

Interviewed at Microsoft

4★

Feb 1, 2012

find duplicated item from an array, output the duplicated item with their times

what was a technical difficulty and how have you overcome it.

Software Engineer Internship

Interviewed at Microsoft

4★

Jun 12, 2012

what was a technical difficulty and how have you overcome it.

if you have a linked list ordered like : n1-n2-n3-n4-n5-n6-n7-NULL. how to sort it to be at the order : n2-n1-n4-n3-n6-n5-n7-NULL

Software Developer

Interviewed at Microsoft

4★

Jun 26, 2012

if you have a linked list ordered like : n1-n2-n3-n4-n5-n6-n7-NULL. how to sort it to be at the order : n2-n1-n4-n3-n6-n5-n7-NULL

Given an array of items of three different colors red, green, blue. How would you sort the items in the array so that all the items with a certain color would be grouped together.

Software Development Engineer (SDE) II

Interviewed at Microsoft

4★

Oct 22, 2015

Given an array of items of three different colors red, green, blue. How would you sort the items in the array so that all the items with a certain color would be grouped together.

Give me 5 different ways of finding the median (middle element) of a linked list. For the sake of simplicity, assume the list has odd number of ints. Also mention the runtime for each. Follow up: What's the fastest way you could find the median? What is the runtime? Oh.. and yes, code your answer(s) in any language of your preference.

Software Developer Intern

Interviewed at Expedia Group

3.7★

Aug 27, 2012

Print a binary tree level by level in zigzag order

Software Development Engineer Intern

Interviewed at Microsoft

4★

Jan 5, 2013

Print a binary tree level by level in zigzag order

You have a box of red balls, a box of blue balls, and a box of red and blue balls. What is the minimum number of boxes you can open and know what is the contents of each box?

Software Development Engineer Intern

Interviewed at Microsoft

4★

Feb 11, 2013

You have a box of red balls, a box of blue balls, and a box of red and blue balls. What is the minimum number of boxes you can open and know what is the contents of each box?

Given a point to an array of 12 bits in a graphics buffer where each 4 bits represented red green and blue respectively, flip the color of the array to blue.

Software Developer Intern

Interviewed at Microsoft

4★

Apr 7, 2013

Given a point to an array of 12 bits in a graphics buffer where each 4 bits represented red green and blue respectively, flip the color of the array to blue.

The numbers 1-5 are inserted, in order, into a stack. Numbers are removed from the stack one-by-one and pushed into another array (numbers could be removed at any time, even before all the numbers have been added to the stack). What order of numbers in the array could NOT be produced by this scenario? Write code to determine if a sequence of numbers could have been produced by this scenario.

Software Development Engineer

Interviewed at Microsoft

4★

Mar 8, 2016

Viewing 1141 - 1150 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 711,030 interview questions and reports from Programador sql interviews. Prepare for your interview. Get hired. Love your job.