AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Nsight Inc SQL Developer Interview Questions, Process, and Tips for Experienced
Nsight Inc SQL Developer Interview Experiences for Experienced
1 interview found
I applied via Naukri.com
Interview Questionnaire
6 Questions
- Q1. 1. Use of with cluse
- Ans.
WITH clause is used to define a temporary result set that can be used in a subsequent SQL statement.
WITH clause is also known as Common Table Expression (CTE)
It improves the readability and maintainability of complex SQL queries
It can be used to simplify complex queries by breaking them down into smaller, more manageable parts
It can be used to create recursive queries
Example: WITH sales AS (SELECT * FROM sales_data) SE...
- Q2. Use of NTILE in sql
- Ans.
NTILE is a SQL function used to divide a result set into a specified number of groups.
NTILE requires an integer argument that specifies the number of groups to divide the result set into.
It assigns a group number to each row in the result set based on the specified number of groups.
NTILE is often used in conjunction with the ORDER BY clause to divide the result set based on a specific column.
NTILE can be used to calcul...
- Q3. Difference between AS and IS in Procedure
- Ans.
AS is used to assign an alias to a column or table in SQL, while IS is used to compare values or check for null values.
AS is used in SELECT statements to assign a temporary name to a column or table
AS can also be used in JOIN statements to assign aliases to tables
IS is used in WHERE clauses to compare values or check for null values
IS NULL is used to check if a value is null
IS NOT NULL is used to check if a value is no
- Q4. Use of Case condition
- Ans.
Case condition is used to perform conditional logic in SQL queries.
It allows for conditional statements in SELECT, WHERE, and ORDER BY clauses.
Syntax: CASE WHEN condition THEN result ELSE alternative END
Can be nested for complex logic
Useful for data transformation and reporting
- Q5. Package
- Q6. Pivote Query , How to use with ex.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Team Lead Interview Questions & Answers
Deutsche Telekom Digital Labs
Anonymous
posted on 20 Sep 2023
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2023. There were 3 interview rounds.
(2 Questions)
- Q1. Have you worked on swift
- Q2. What is a class
- Ans.
A class is a blueprint for creating objects in object-oriented programming.
Classes define the properties and behaviors of objects.
Objects are instances of classes.
Classes can inherit properties and behaviors from other classes.
Encapsulation, inheritance, and polymorphism are key concepts in class-based programming.
(4 Questions)
- Q1. Write code for star paattern
- Ans.
Code for star pattern using nested loops
Use nested loops to print the desired pattern
Outer loop controls the number of rows and inner loop controls the number of stars in each row
Example: for a pattern with 5 rows, the code would involve two nested loops to print stars in a pyramid shape
- Q2. What is linked list
- Ans.
A linked list is a data structure where each element is a separate object, connected to the next element by a pointer.
Consists of nodes where each node contains data and a reference to the next node
Dynamic in size and can grow or shrink during execution
Common operations include insertion, deletion, and traversal
Example: Singly linked list, Doubly linked list, Circular linked list
- Q3. Differnce between public private
- Ans.
Public and private sectors differ in ownership, funding, and management.
Public sector is owned and operated by the government, while private sector is owned and operated by individuals or companies.
Public sector is funded by taxpayer money, while private sector is funded by investors or owners.
Public sector is managed by government officials, while private sector is managed by business owners or executives.
- Q4. Whats is oops and protcols
- Ans.
OOPs stands for Object-Oriented Programming and protocols are a set of rules for communication between devices.
OOPs is a programming paradigm that uses objects and classes to design applications.
Protocols are a set of rules that define how data is transmitted between devices.
In OOPs, objects have attributes and methods that define their behavior.
Examples of OOPs languages include Java, C++, and Python.
Examples of proto
(2 Questions)
- Q1. Total time waste quesrtions
- Q2. Basic programing questions as em was having very less knowledge
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
Questions were asked about my on my education background, my family, and why do I want to join this company?
Lokansha
(1 Question)
- Q1. Past experience
(2 Questions)
- Q1. Tell me about your experience
- Ans.
I have extensive experience in business development, focusing on strategic partnerships and market expansion.
Developed strategic partnerships that increased revenue by 30% within a year.
Conducted market research to identify new opportunities, leading to the launch of two successful products.
Led a team to negotiate contracts with key clients, resulting in long-term relationships and repeat business.
Implemented a CRM sys...
- Q2. Background
I applied via Recruitment Consulltant and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. When do you prefer Decision Tree better than Random Forest model if model outputs are similar
- Ans.
Decision Tree is preferred over Random Forest when interpretability is important.
Decision Tree is easier to interpret and visualize than Random Forest.
Decision Tree is better suited for small datasets with few features.
Random Forest is better suited for large datasets with many features.
Random Forest is less prone to overfitting than Decision Tree.
Decision Tree can be used as a building block for Random Forest.
If inter...
(1 Question)
- Q1. Why do you want to work here
Interview Preparation Tips
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Deutsche Telekom Digital Labs
Anonymous
posted on 8 Dec 2022
Core Java , DS and Algo
(2 Questions)
- Q1. LLD Spotify only structure
- Q2. Shortest path algorithm
- Ans.
Shortest path algorithm finds the shortest path between two nodes in a graph.
Dijkstra's algorithm is a popular shortest path algorithm that uses a priority queue to find the shortest path in a weighted graph.
A* algorithm is another popular shortest path algorithm that uses heuristics to guide the search towards the goal node.
Bellman-Ford algorithm is used for finding the shortest path in a graph with negative edge weig
(2 Questions)
- Q1. Reason for the change
- Q2. What you bring to the table
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Deutsche Telekom Digital Labs
Anonymous
posted on 19 Jun 2024
Selected
I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.
Start of The Loop in LinkedList.
Length of Loop in LinkedList
API Contract for Notification sending via SMS and Email
Array duplicates and burn binary tree
(1 Question)
- Q1. Project specific
I applied via Job Fair and was interviewed in Mar 2024. There were 2 interview rounds.
Basic questions were asked from topics like time, cost, profits-losses, patterns etc
Questions on microprocessors , networking and sorting algorithms
Nsight Inc Interview FAQs
Tell us how to improve this page.
Nsight Inc Interviews By Designations
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Technical Lead
38
salaries
|  ₹9.2 L/yr - ₹36.4 L/yr |
|
Senior Software Engineer
31
salaries
| ₹8 L/yr - ₹21 L/yr |
|
Software Engineer
20
salaries
| ₹3 L/yr - ₹6.5 L/yr |
|
Associate Software Engineer
14
salaries
| ₹3 L/yr - ₹5 L/yr |
|
Consultant
12
salaries
| ₹15 L/yr - ₹20 L/yr |
Fractal Analytics
Subex
MathCo
Innovatiview India Ltd
- Home >
- Interviews >
- Nsight Inc Interview Questions >
- Nsight Inc SQL Developer Interview Questions for Experienced
