Sequretek It Solutions Associate Consultant Interview Questions and Answers for Experienced

Duration: 1hr
Topics: Array, LinkedList,Stack

Q1. Write code for Insertion in a binary tree.
Ans. 
Code for insertion in a binary tree
• Create a new node with the given data

• If the tree is empty, make the new node as root

• Else, traverse the tree to find the appropriate position to insert the new node

• If the data is less than the current node, go to the left subtree

• If the data is greater than the current node, go to the right subtree

• Repeat until an appropriate position is found

• Set the new node as the child of the appropri
Answered by AI
Add your answer
Q2. Write code for quick sort
Ans. 
Quick sort is a divide-and-conquer algorithm that sorts an array by partitioning it into two sub-arrays.
• Choose a pivot element from the array

• Partition the array around the pivot element

• Recursively apply quick sort to the left and right sub-arrays

• Combine the sorted sub-arrays to get the final sorted array
Answered by AI
Add your answer

Q1. Various DBMS related question(JOINS, SORT, LIMIT)
Add your answer

Q1. Tell us about yourself.
Add your answer
Q2. Why do want to join the company
Add your answer

Q1. Leetcode 125: Valid Palindrome
Add your answer
Q2. Leetcode 1971: Find if path exists in graph
Ans. 
Check if a path exists between two nodes in a graph
• Use depth-first search (DFS) or breadth-first search (BFS) to traverse the graph

• Start from the source node and explore all connected nodes until the destination node is reached

• If the destination node is found during the traversal, return true; otherwise, return false
Answered by AI
Add your answer

Q1. How will you store passwords in DB
Ans. 
Store passwords securely using hashing algorithms and salt
• Use strong hashing algorithms like bcrypt or SHA-256

• Add a unique salt to each password before hashing

• Store only the hashed password in the database

• Regularly update hashing algorithms and salts for added security
Answered by AI
Add your answer
Q2. Explain "this" in JS
Ans. 
In JavaScript, 'this' refers to the current object that is executing the current function.
• The value of 'this' is determined by how a function is called.

• When a function is called as a method of an object, 'this' refers to the object itself.

• When a function is called in the global scope, 'this' refers to the global object (window in a browser, global in Node.js).

• Arrow functions do not have their own 'this' value and inste...read more
Answered by AI
Add your answer

Q1. Basic HR questions
Add your answer

Q1. Linear regression? python coding of lists.
Add your answer

Q1. Linear regression? python coding
Add your answer

Q1. Describe the Project Architecture End-to-End
Ans. 
The project architecture end-to-end includes the overall design and structure of the project from start to finish.
• The architecture should include the hardware and software components, as well as the communication protocols and data flow.

• It should also consider the scalability, security, and performance of the system.

• Examples of project architecture include client-server, microservices, and event-driven architectures.

• Th...read more
Answered by AI
Add your answer
Q2. Explain how will you implement SCD Type 2.
Ans. 
SCD Type 2 is implemented by creating a new record for each change and maintaining a history of changes.
• Identify the business key and version number for the dimension table.

• Create a new record with a new version number for each change to the dimension data.

• End-date the previous record and start-date the new record to maintain a history of changes.

• Use effective dates to determine which record is active at any given poin...read more
Answered by AI
Add your answer

Q1. Display only those elements which do not occur more than once.
Ans. 
Display non-repeated elements
• Iterate through the elements and count their occurrences

• Display only those elements with occurrence count of 1

• Use a hash table or dictionary to store the counts

• Time complexity: O(n)
Answered by AI
View 1 more answer
Q2. Difference between a list and a tuple. Explain a use case where you will use a tuple.
Ans. 
List vs Tuple and use case for Tuple
• List is mutable while Tuple is immutable

• List uses square brackets while Tuple uses parentheses

• Tuple is used when data needs to be protected from modification

• Tuple is also used for returning multiple values from a function
Answered by AI
Add your answer

It was easy asked about some basic concepts

Basic coding based on data structures

Q1. What are React Queries?
Ans. 
React Queries are a library for managing server state in React applications.
• React Queries provide a way to fetch and cache data from an API in React components.

• They offer features like caching, background fetching, and automatic refetching.

• React Queries can handle complex data fetching requirements, such as pagination and infinite scrolling.
Answered by AI
Add your answer
Q2. Can useEffect() hook run twice?
Ans. 
Yes, useEffect() hook can run twice under certain conditions.
• useEffect() hook can run twice if the dependencies array changes between renders.

• This can happen if the dependencies array contains values that change frequently.

• For example, if a state variable is included in the dependencies array and it is updated in the component, useEffect() will run again.
Answered by AI
Add your answer

Q1. Can you introduce yourself and describe the projects you have worked on, including any basic data structures and algorithms concepts and questions related to Python that you were asked?
Ans. 
I am a Software Developer with experience in projects involving data structures, algorithms, and Python.
• Worked on a project implementing a binary search tree data structure in Python.

• Implemented sorting algorithms like bubble sort and quicksort in a project.

• Answered questions related to Python concepts like list comprehensions and lambda functions.

• Solved algorithmic questions involving concepts like recursion and dynam
Answered by AI
Add your answer