Nextworld Solution SQL Developer Interview Questions and Answers

Create a movie app which fetches data from an API

Q1. General questions from Android development.
Add your answer
Q2. DSA round + project discussion
Add your answer
Q3. Stock span problem (leetcode)
Ans. 
Stock span problem is a financial problem where we have a series of n daily price quotes for a stock and we need to calculate the span of stock's price for all n days.
• Use a stack to keep track of the previous days' prices and their spans.

• For each day, pop the stack until a price greater than the current day's price is found, then calculate the span.

• Push the current day's price and span onto the stack.
Answered by AI
Add your answer
Q4. Search in a list of strings
Ans. 
Use a loop to search for a specific string in an array of strings.
• Iterate through each string in the array

• Use a conditional statement to check if the current string matches the search string

• Return the index of the matching string or -1 if not found
Answered by AI
Add your answer

Q1. 1. what is react 2.create a tab strcture like when u click add css and open that tab
Ans. 
React is a JavaScript library for building user interfaces.
• React is a popular JavaScript library for building user interfaces.

• To create a tab structure in React, you can use components like Tabs and TabPanels.

• When a tab is clicked, you can use state to show or hide the content of that tab.
Answered by AI
Add your answer

There was aptitude and coding question essy to medium

There was some aptitude question and coding question easy to medium

Dsa predict the output

One medium problem. Based on that the students are selected. And modifications in code has been asked

Q1. Coding related questions
Add your answer

Create a small appilcation and send the code via email

Q1. Questions related to javascript
Add your answer

20 questions,mcq type

Q1. Sql commands,join query
Add your answer

No of Questions : 4 questions
Difficulty : Difficult
Topics : Sieve of eratosthenis, DP, Hashing

Q1. Search in the rotated Sorted array. (Binary Search - pivot)
Ans. 
Search for an element in a rotated sorted array using binary search with pivot.
• Find the pivot element using binary search.

• Compare the target element with the first element of the array to determine which half to search.

• Perform binary search on the selected half of the array.

• Repeat until the target element is found or the array is exhausted.
Answered by AI
Add your answer
Q2. Sort the array which consists of 0's, 1's , 2's. (Two Pointer approach)
Ans. 
Sort an array of 0's, 1's, and 2's using two pointer approach.
• Initialize two pointers, one at the beginning and one at the end of the array.

• Traverse the array and swap 0's to the beginning and 2's to the end using the pointers.

• Stop when the pointers meet or cross each other.
Answered by AI
Add your answer
Q3. Tell me about id selector in CSS
Ans. 
ID selector is used to select an element with a specific ID attribute in CSS.
• ID selector is denoted by '#' followed by the ID name.

• ID should be unique on a page.

• ID selector has higher specificity than class selector.

• Example: #header { color: blue; }
Answered by AI
Add your answer

Q1. Differences between ShallowCopy & DeepCopy
Ans. 
ShallowCopy copies only the reference of an object while DeepCopy creates a new object with a new reference.
• ShallowCopy creates a new reference to the same object, so changes made to the copy will reflect in the original object.

• DeepCopy creates a new object with a new reference, so changes made to the copy will not reflect in the original object.

• ShallowCopy is faster and less memory-intensive than DeepCopy.

• DeepCopy is ...read more
Answered by AI
Add your answer
Q2. Define Copy Constructor
Ans. 
Copy constructor is a special constructor that creates a new object by copying an existing object.
• It is used to create a new object with the same values as an existing object.

• It takes an object of the same class as a parameter.

• It is automatically called when a new object is created from an existing object.

• It creates a deep copy of the object, meaning that all the member variables are copied.

• Example: class MyClass { pub...read more
Answered by AI
Add your answer
Q3. Define Operator overloading
Ans. 
Operator overloading allows operators to have different meanings based on the context of their usage.
• Operator overloading is a feature in object-oriented programming languages.

• It allows operators to be redefined for custom classes.

• For example, the '+' operator can be overloaded to concatenate strings or add numbers.

• It can improve code readability and reduce the amount of code needed for certain operations.
Answered by AI
Add your answer
Q4. Differences between struct and class
Ans. 
Struct is a value type while class is a reference type in C#.
• Structs are stored on the stack while classes are stored on the heap.

• Structs cannot be inherited while classes can be inherited.

• Structs do not support destructors while classes do.

• Structs are used for small data structures while classes are used for larger, more complex objects.

• Example of struct: struct Point { public int X; public int Y; }

• Example of class: c...read more
Answered by AI
Add your answer
Q5. DSA : Search an element in infinite soted array
Ans. 
Search an element in an infinite sorted array using binary search.
• Initialize low as 0 and high as 1.

• Double the high index until arr[high] is greater than the target element.

• Perform binary search between low and high indexes.
Answered by AI
Add your answer