Silverpush Category Manager Interview Questions and Answers

Create a Full Stack App

Online or offline classes which is better

Q1. Sql and excel and the company is good
Add your answer

Q1. Design Least recently used cache.
Ans. 
Design a Least Recently Used cache system.
• Implement a doubly linked list to keep track of the order of usage of cache items.

• Use a hashmap to store key-value pairs for quick access to cache items.

• When a new item is accessed, move it to the front of the linked list. If the cache is full, remove the least recently used item from the end of the list.
Answered by AI
Add your answer

A general topic was provided.

Basic aptitude questions.

Q1. Sql and dbms questions
Add your answer

Q1. Write a query to extract unique values?
Ans. 
Query to extract unique values
• Use the SELECT DISTINCT statement in SQL to retrieve unique values from a table

• For example, SELECT DISTINCT column_name FROM table_name;

• In Python, you can use the set() function to extract unique values from a list or array
Answered by AI
Add your answer

Q1. Previous role and projects
Add your answer

Q1. Difference between null and object.
Ans. 
Null is absence of value while object is a collection of properties and methods.
• Null is a primitive value while object is a complex data type.

• Null is used to indicate absence of value while object is used to represent real-world entities.

• Null cannot have properties or methods while object can have both.

• Example of null: let x = null; Example of object: let person = { name: 'John', age: 30 };
Answered by AI
Add your answer

Q1. DSA question (Competitive programming)
Add your answer
Q2. LLD question (Competetive)
Add your answer