Skip to contentSkip to footer

Programador Sql Interview Questions

Salaries
Interviews

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,068 programador sql interview questions shared by candidates

A rustic village contains one million married couples and no children. Each couple has exactly one child per year. Each couple wants a girl, but also wants to minimize the number of children they have, so they will continue to have children until they have their first girl. Assume that children are equally likely to be born male or female. Let p(t) be the percentage of children that are female at the end of year t. What is p(t)? "Can't tell" is a potential answer if you don't have sufficient information.
avatar

Senior Java Developer

Interviewed at Acuitus

4.4★
Apr 6, 2010

A rustic village contains one million married couples and no children. Each couple has exactly one child per year. Each couple wants a girl, but also wants to minimize the number of children they have, so they will continue to have children until they have their first girl. Assume that children are equally likely to be born male or female. Let p(t) be the percentage of children that are female at the end of year t. What is p(t)? "Can't tell" is a potential answer if you don't have sufficient information.

-given a binary tree, and a number in each node. Select the nodes that will maximize the overall sum such that if a node is selected its parent and children cannot be selected. Return the sum of the selected nodes. - The buildings in a a city can be represented in 2D by linear array. Given an array that represents the heights of the buildings such that the value in a specific index in the array indicates the height of the building at that location in the city. How much rain will gather in the city if it rains?
avatar

Software Engineer

Interviewed at Altera

3.4★
May 6, 2015

-given a binary tree, and a number in each node. Select the nodes that will maximize the overall sum such that if a node is selected its parent and children cannot be selected. Return the sum of the selected nodes. - The buildings in a a city can be represented in 2D by linear array. Given an array that represents the heights of the buildings such that the value in a specific index in the array indicates the height of the building at that location in the city. How much rain will gather in the city if it rains?

This wasn't incredibly difficult, but one guy asked me to design Facebook (at a high level) and another asked me to design Twitter. I thought these were really cool questions because they tested overall design smarts instead of obscure algorithmic stuff.
avatar

Software Engineer

Interviewed at Zocdoc

3.6★
Nov 16, 2014

This wasn't incredibly difficult, but one guy asked me to design Facebook (at a high level) and another asked me to design Twitter. I thought these were really cool questions because they tested overall design smarts instead of obscure algorithmic stuff.

Viewing 1291 - 1300 interview questions

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