Vishleshan Software Solutions Interview Questions and Answers

Q1. How to connect to database?
Ans. 
To connect to a database, use a database driver and provide connection details.
• Choose a database driver that is compatible with your database management system.

• Provide the necessary connection details such as host, port, username, and password.

• Use the driver's connect() method to establish a connection to the database.

• Close the connection when done using the close() method.
Answered by AI
Add your answer
Q2. What is MVC in django?
Ans. 
MVC stands for Model-View-Controller, a design pattern used in Django to separate the application into three interconnected components.
• Model represents the data and business logic of the application.

• View handles the presentation layer and interacts with the user.

• Controller acts as an intermediary between the Model and View, handling user input and updating the Model and View accordingly.

• Django's implementation of MVC i...read more
Answered by AI
Add your answer

Q1. The interview lasted for 1.5 hours, during which three interviewers asked numerous detailed questions related to my resume, covering every technology listed. They posed inquiries regarding SQL and data str...read more
Add your answer
Q2. How were you asked about Lambda in relation to the information presented in your resume, and how do you call a Lambda function?
Add your answer
Q3. Is AWS Lambda considered serverless, and if an object is stored in your S3 bucket, how can a person in a different region access that object?
Ans. 
Yes, AWS Lambda is considered serverless. To access an object in a different region, you can use S3 Cross-Region Replication or make the object public.
• AWS Lambda is a serverless computing service that allows you to run code without provisioning or managing servers.

• To access an object in a different region stored in an S3 bucket, you can use S3 Cross-Region Replication to automatically replicate objects across different...read more
Answered by AI
Add your answer
Q4. What are the SQL queries to find the names of employees that start with the letter 'S' and to count the number of employees in each department?
Ans. 
SQL queries to find employees starting with 'S' and count employees in each department.
• Use SELECT statement with WHERE clause to find employees starting with 'S': SELECT name FROM employees WHERE name LIKE 'S%'

• Use GROUP BY clause with COUNT function to count employees in each department: SELECT department, COUNT(*) FROM employees GROUP BY department
Answered by AI
Add your answer
Q5. What is the difference between the `get` and `filter` methods in query sets, how can you retrieve data for a person whose name starts with 'S', and what are the return types of `get` and `filter`?
Ans. 
The difference between get and filter methods in query sets in Django.
• get method retrieves a single object that matches the query criteria, while filter method retrieves a queryset containing all objects that match the query criteria.

• To retrieve data for a person whose name starts with 'S', you can use filter method with the query {'name__startswith': 'S'}.

• The return type of get method is a single object or raises a Do...read more
Answered by AI
Add your answer
Q6. What are the different types of search algorithms, and what is their time complexity?
Ans. 
Different types of search algorithms with their time complexity
• Linear Search - O(n)

• Binary Search - O(log n)

• Depth First Search (DFS) - O(V + E)

• Breadth First Search (BFS) - O(V + E)

• A* Search - O(b^d)

• Greedy Best First Search - O(b^m)
Answered by AI
Add your answer
Q7. Can you provide an example of code for an API that implements the same logic using different methods, such as GET, POST, PUT, and DELETE, to retrieve all details from a model?
Ans. 
Example code for an API implementing CRUD operations on a model using different HTTP methods
• Use Django REST framework to create API views for each HTTP method (GET, POST, PUT, DELETE)

• Define URL patterns in Django's urls.py to map to the corresponding API views

• Implement logic in the API views to interact with the model and perform CRUD operations

• Use serializers to convert model instances to JSON data and vice versa
Answered by AI
Add your answer
Q8. They provided two problems: one required printing a pattern, and the other asked for the implementation of the bubble sort algorithm. They also inquired about the time complexity of these algorithms.
Add your answer
Q9. Why do you prefer using ViewSet over ModelSet when writing APIs?
Ans. 
ViewSets provide a simple way to create CRUD APIs with less code compared to ModelSets.
• ViewSets reduce boilerplate code by providing default implementations for common actions like create, retrieve, update, and delete.

• ViewSets allow for more flexibility and customization compared to ModelSets, as they can be easily extended and customized to fit specific requirements.

• ViewSets are more concise and readable, making it ea...read more
Answered by AI
Add your answer
Q10. What is your motivation for transitioning from a product-based company to a service-based company?
Ans. 
I am motivated to transition from a product-based company to a service-based company because I enjoy working directly with clients and providing personalized solutions.
• I value the opportunity to work closely with clients to understand their unique needs and provide tailored solutions.

• I am excited about the prospect of continuously learning and adapting to new challenges in a service-based environment.

• I believe that wor...read more
Answered by AI
Add your answer
Q11. What projects are you currently working on in your role, and can you provide a detailed discussion on how you arrived at the solutions, why you chose those specific projects, and any additional insights?
Add your answer
Q12. Explain the architecture of Django Project. then asked question on asgi, wsgi
Add your answer

Q1. SQL queries like joins, indexes, DML
Add your answer

Basic question of manual testing

Q1. Regression testing
Add your answer
Q2. Explain difference in Smoke testing and sanity testing
Ans. 
Smoke testing is a subset of regression testing, while sanity testing is a subset of acceptance testing.
• Smoke testing is done to check if the critical functionalities of the software are working fine after changes.

• Sanity testing is done to check if the specific functionalities are working fine after bug fixes or minor changes.

• Smoke testing is a broad and shallow approach, while sanity testing is a narrow and deep appro...read more
Answered by AI
Add your answer