Nykaa SQL Developer Interview Questions and Answers

Write Fabonacci series code using storeproceduer

Q1. Some SQL query and basic DBMS theory questions
Add your answer

Q1. Questions on optimizations
Add your answer
Q2. Question on React Js
Add your answer

Medium level DSA question in JS

Graphs ,arrays , Hashmaps and Heaps

Q1. Graphs related dfs
Add your answer
Q2. Changes on graph structure
Ans. 
Changes on graph structure involve adding, removing, or modifying nodes and edges.
• Adding a new node to the graph

• Removing an existing node from the graph

• Modifying the weight of an edge in the graph
Answered by AI
Add your answer

Html coding, css coding, Javascript coding , bootstrap

Html coding , javascript coding ,css coding

Q1. Attended first round interview dec 2023
Add your answer
Q2. Asked some basic js and angular question
Add your answer
Q3. What is hoisting?
Ans. 
Hoisting is a JavaScript behavior where variable and function declarations are moved to the top of their scope during the compilation phase.
• Hoisting applies to both variable and function declarations.

• Variable declarations are hoisted but not their initializations.

• Function declarations are fully hoisted, allowing them to be called before they are defined.

• Hoisting does not apply to variables declared with let or const.

• Ho...read more
Answered by AI
Add your answer
Q4. Difference between display-block and inline-block
Ans. 
display-block takes up full width, while inline-block only takes up necessary width.
• display-block elements start on a new line and take up the full width available, like <div>

• inline-block elements do not start on a new line and only take up as much width as necessary, like <span>

• display-block elements can have margin and padding applied on all sides, while inline-block elements only have margin and padding
Answered by AI
Add your answer
Q5. Parent child communication in angular
Ans. 
Parent child communication in Angular is a way to pass data and trigger actions between components.
• Use @Input decorator to pass data from parent to child component

• Use @Output decorator and EventEmitter to emit events from child to parent component

• Use ViewChild decorator to access child component from parent component

• Use services to share data between unrelated components
Answered by AI
Add your answer

Provide three screenshot of matrimony app to create a angular application.

Q1. Dsa question on matrix
Add your answer
Q2. Dsa question on stack
Add your answer

Round duration - 150 minutes
Round difficulty - Medium

The interview was scheduled at 6 pm and the duration of the interview was 1.5 hrs but went for around 2.5 hrs. The interviewer started with a brief intro about me. Asked me some coding questions. After coding questions he started asking questions on dbms like difference between sql and no sql, what is horizontal and vertical scaling and when we use them. Then some questions on computer networks like how web browsers works, different between http and HTTPS, what is TCP. After this he asked about my projects and the technology I worked on during the intern.

Q1. 
Snake and Ladder Problem Statement
Given a Snake and Ladder Board with 'N' rows and 'N' columns filled with numbers from 1 to N*N starting from the bottom left of the board, and alternating direction each...read more
Add your answer
Q2. 
Deletion In Doubly Linked List
You are given a Doubly Linked List with 'N' positive integers. Your task is to delete a node at a given position 'POS' in this linked list.
Input:
The first line of input ...read more
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Round duration - 90 minutes
Round difficulty - Easy

The round was conducted on the HackerRank platform. It was conducted in the morning from 12:00 pm to 1:30 pm.
The only requirement was a stable internet connection.

Q1. 
Valid Parentheses Problem Statement
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
Input:
The first line contains an...read more
Add your answer
Q2. 
Date Reformatting
You have a string 'S' representing a date in the "Day Month Year" format, where:
• Day is one of {"1st", "2nd", "3rd", ..., "29th", "30th", "31st"}.
• Month is one of {"Jan", "Feb", "M...read more
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

It was conducted in the morning, at around 8 am, and was conducted on the Blue Jeans Platform. It was an online video interview, where the interviewer asked me 2 questions related to DSA.

Q1. 
Distinct Islands Problem Statement
Given a two-dimensional array/list consisting of integers 0s and 1s, where 1 represents land and 0 represents water, determine the number of distinct islands. A group of...read more
Add your answer
Q2. 
Count and Say Sequence Problem
The 'Count and Say' sequence is a series of strings in which each consecutive term is generated by describing the previous term. The sequence begins with '1'.
Your task is ...read more
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

This round was conducted after the first round in the morning. It was conducted at 10:00 am.

Q1. 
Distribute Items Problem Statement
Calculate the number of ways to distribute a given number of items 'N' among three people such that each person gets at least one item, and only one person receives the ...read more
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

This was an HR round and was conducted on the same day at around 12:00 pm