Programador Sql Interview Questions

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.

710,358 programador sql interview questions shared by candidates

(following the previous one) You got only TWO baby bottle sample. You would like to know the max height you can drop it without breaking the bottle. Let set the unit as 1 foot. And the highest height you can reach is at N feet. So how would you find the (max) safe height? (This is the one I think is kind of brain-teaser one.)
avatar

Software Development Engineer Intern

Interviewed at Amazon

3.5
Jan 28, 2012

(following the previous one) You got only TWO baby bottle sample. You would like to know the max height you can drop it without breaking the bottle. Let set the unit as 1 foot. And the highest height you can reach is at N feet. So how would you find the (max) safe height? (This is the one I think is kind of brain-teaser one.)

Puzzle: There are 25 horses and 5 lanes for conducting a race among them. In a minimum of how many races, would be able to find out the 3 fastest horses among them? Assumption: Speed of horses are consistent enough across races.
avatar

Software Development Engineer

Interviewed at Scantron

2.8
Feb 2, 2012

Puzzle: There are 25 horses and 5 lanes for conducting a race among them. In a minimum of how many races, would be able to find out the 3 fastest horses among them? Assumption: Speed of horses are consistent enough across races.

Another was a puzzle: A king orders 100 bottles of wine for a celebration. A courtier who's angry with the king over something puts poison in one of those bottles. The king has a way of identifying the poisoned bottle by giving a few drops of wine to a monkey. Since the poison is fast acting, the monkey will die immediately. Whats the minimum number of monkeys needed to find the poisoned bottle?
avatar

Senior Software Developer

Interviewed at Tower Research Capital

4.1
Jun 7, 2010

Another was a puzzle: A king orders 100 bottles of wine for a celebration. A courtier who's angry with the king over something puts poison in one of those bottles. The king has a way of identifying the poisoned bottle by giving a few drops of wine to a monkey. Since the poison is fast acting, the monkey will die immediately. Whats the minimum number of monkeys needed to find the poisoned bottle?

Question Description: Write a function that, given a list of integers (both positive and negative) returns the sum of the contiguous subsequence with maximum sum. Thus, given the sequence (1, 2, -4, 1, 3, -2, 3, -1) it should return 5.
avatar

Software Engineer Intern

Interviewed at LinkedIn

3.8
Dec 4, 2014

Question Description: Write a function that, given a list of integers (both positive and negative) returns the sum of the contiguous subsequence with maximum sum. Thus, given the sequence (1, 2, -4, 1, 3, -2, 3, -1) it should return 5.

Write a program that given 4 coin denominations and a dollar amount finds the best way to express that amount using the coins given. I.e. you have coins with denominations of 1c, 7c, 13c,19c and you have to express $2.12 with the least number of coins. There is always a 1c coin but the other 3 are arbitrary.
avatar

Software Engineer

Interviewed at Tripadvisor

3.5
Apr 27, 2012

Write a program that given 4 coin denominations and a dollar amount finds the best way to express that amount using the coins given. I.e. you have coins with denominations of 1c, 7c, 13c,19c and you have to express $2.12 with the least number of coins. There is always a 1c coin but the other 3 are arbitrary.

Behavioral Why outreach The impact you hope to have from your next role?What is most important factor in your career/job What do you think about RSpec? How do you compare it with other frameworks What was the hardest/Challenging technical problem you faced and how did you resolve it Coding This problem concerns finding a time when we can do daily recurring maintenance on a server. You are to write a function that is given the following information: List of times when the server is busy every day Duration, in minutes, of the desired maintenance window The function should return the start time of a daily maintenance window when the server is not busy. In pseudo-code, the function signature would look something like this: maintWindowStart(busyTimes, durationMins) -> startTime The "busy times" should be time ranges like the following, and can be represented in whatever data structure you feel is appropriate. 0:05 to 0:30 = [5, 30] 2:00 to 4:01 = [120, 241] 13:10 to 16:55 = [790, 1015] [[5, 30], [120, 541], [790, 1015]] // requested duration -> expected start time // 10 -> 30 // 120 -> 541 // 4 -> 0 // 300 -> 1015
avatar

Senior Backend Software Engineer

Interviewed at Outreach

3.8
Jan 12, 2018

Behavioral Why outreach The impact you hope to have from your next role?What is most important factor in your career/job What do you think about RSpec? How do you compare it with other frameworks What was the hardest/Challenging technical problem you faced and how did you resolve it Coding This problem concerns finding a time when we can do daily recurring maintenance on a server. You are to write a function that is given the following information: List of times when the server is busy every day Duration, in minutes, of the desired maintenance window The function should return the start time of a daily maintenance window when the server is not busy. In pseudo-code, the function signature would look something like this: maintWindowStart(busyTimes, durationMins) -> startTime The "busy times" should be time ranges like the following, and can be represented in whatever data structure you feel is appropriate. 0:05 to 0:30 = [5, 30] 2:00 to 4:01 = [120, 241] 13:10 to 16:55 = [790, 1015] [[5, 30], [120, 541], [790, 1015]] // requested duration -> expected start time // 10 -> 30 // 120 -> 541 // 4 -> 0 // 300 -> 1015

Viewing 411 - 420 interview questions

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