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

First round was online test which contains 75 aptitude,reasoning and english questions and 5 programs you have to execute either in c++ or java.Online test is conducted by deselect.this pattern is similar to the amcat pattern.
avatar

Software Engineer

Interviewed at Carelon Global Solutions

3.8
Sep 25, 2018

First round was online test which contains 75 aptitude,reasoning and english questions and 5 programs you have to execute either in c++ or java.Online test is conducted by deselect.this pattern is similar to the amcat pattern.

Recently I attended the interview at Google and I was asked "You are given a sorted list of disjoint intervals and an interval, e.g. [(1, 5), (10, 15), (20, 25)] and (12, 27). Your task is to merge them into a sorted list of disjoint intervals: [(1, 5), (10, 27)]."
avatar

Software Engineer, Google Fiber

Interviewed at Google

4.4
Sep 12, 2012

Recently I attended the interview at Google and I was asked "You are given a sorted list of disjoint intervals and an interval, e.g. [(1, 5), (10, 15), (20, 25)] and (12, 27). Your task is to merge them into a sorted list of disjoint intervals: [(1, 5), (10, 27)]."

one question was as under - "Symmetric Difference of Arrays" Input: two arrays of integers Output: one array of integers which occur in only one (not both) arrays Test case: Input: [ 1, 7, 8, 2, 4, 5 ] [ 3, 5, 1, 7, 6, 9 ] Output: [ 8, 2, 4, 3, 6, 9 ]
Apr 15, 2014

one question was as under - "Symmetric Difference of Arrays" Input: two arrays of integers Output: one array of integers which occur in only one (not both) arrays Test case: Input: [ 1, 7, 8, 2, 4, 5 ] [ 3, 5, 1, 7, 6, 9 ] Output: [ 8, 2, 4, 3, 6, 9 ]

You are given a fixed number of 5 rupee, 10 rupee, 20 rupee and 50 rupee stamps. Now given an amount for sending a parcel, you should design an algorithm to come out with the minimum number of stamps that should be used for attaining that amount. For example, if the parcel costed 30 rupees, it could be attained using one 20 rupee stamp and one 10 rupee stamp OR using three 10 rupee stamps OR using one 20 rupee stamp and two 5 rupee stamps OR using one 10 rupee stamp and four 5 rupee stamps OR using two 10 rupee stamps and two 5 rupee stamps. However, the minimum number of stamps is the case of one 20 rupee stamp and one 10 rupee stamp where only two stamps are used. The case where no solution is possible should also be handled, for example, a parcel amount of exactly 33 rupees cannot be attained.
avatar

Senior Software Engineer

Interviewed at Amazon

3.5
Oct 13, 2012

You are given a fixed number of 5 rupee, 10 rupee, 20 rupee and 50 rupee stamps. Now given an amount for sending a parcel, you should design an algorithm to come out with the minimum number of stamps that should be used for attaining that amount. For example, if the parcel costed 30 rupees, it could be attained using one 20 rupee stamp and one 10 rupee stamp OR using three 10 rupee stamps OR using one 20 rupee stamp and two 5 rupee stamps OR using one 10 rupee stamp and four 5 rupee stamps OR using two 10 rupee stamps and two 5 rupee stamps. However, the minimum number of stamps is the case of one 20 rupee stamp and one 10 rupee stamp where only two stamps are used. The case where no solution is possible should also be handled, for example, a parcel amount of exactly 33 rupees cannot be attained.

Viewing 261 - 270 interview questions

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