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

The first round comprised of 4 sections online questions including aptitude, logical, Coding questions, and technical portions (Test Duration: 90 mins):

Debugging: We had to choose a language and debug up to 7 questions most probably. Codes were very basic like sorting, etc. I completed 6 of them.

Coding: There were two medium-hard level questions.

Work-style Assessment: Just try to answer as an ideal employee. Make sure you answers don’t contradict each other.

Aptitude: Around 25 questions.

Q1. Find diameter of tree
Add your answer
Q2. Count inversion
Add your answer

Q1. Find n’th node from the end of a Linked List
Add your answer
Q2. Find shortest distance between 2 points in a matrix, where 2 points can be anywhere
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. Build system for Tiny URL
Ans. 
Build a system for generating and managing Tiny URLs
• Use a unique identifier for each long URL to generate a short URL

• Store the mapping of short URL to long URL in a database

• Implement a redirect mechanism to redirect users from short URL to long URL

• Consider adding expiration dates for short URLs to manage storage

• Implement analytics to track usage of short URLs
Answered by AI
Add your answer

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