Vionsys IT solutions Interview Questions and Answers

Q1. Tell me your self introduction
Ans. 
I am a dedicated and experienced Desktop Support Engineer with a strong background in troubleshooting and resolving technical issues.
• Experienced in providing technical support to end users

• Proficient in diagnosing and resolving hardware and software issues

• Skilled in setting up and configuring computer systems and networks
Answered by AI
Add your answer
Q2. What is DNS
Ans. 
DNS stands for Domain Name System, which translates domain names to IP addresses.
• DNS is like a phone book for the internet, translating human-readable domain names (like google.com) to IP addresses (like 172.217.3.206).

• It helps users access websites and other online services by translating domain names into IP addresses that computers can understand.

• DNS also helps with email delivery, ensuring that emails are sent to t...read more
Answered by AI
Add your answer
Q3. What is letest version of windows
Ans. 
The latest version of Windows is Windows 11.
• Windows 11 is the latest version of the Windows operating system.

• It was officially released on October 5, 2021.

• Windows 11 introduces a new design, improved performance, and new features like Snap Layouts and Snap Groups.
Answered by AI
Add your answer
Q4. How to be configured office 365
Ans. 
Office 365 can be configured by setting up user accounts, assigning licenses, configuring email settings, and setting up security measures.
• Set up user accounts by adding users in the admin portal

• Assign licenses to users based on their roles and needs

• Configure email settings such as setting up mailboxes, distribution lists, and email forwarding

• Set up security measures like enabling multi-factor authentication and settin
Answered by AI
Add your answer

6 question 1 hard, 3 med, 2 easy

Q1. Rainwater PRoblem and multisource bfs
Add your answer

Q1. Lru Cache leet problem in deep
Ans. 
Implement a Least Recently Used (LRU) cache
• Use a combination of a doubly linked list and a hashmap to efficiently implement the LRU cache

• When a new element is accessed, move it to the front of the linked list and update the hashmap

• When the cache is full, remove the least recently used element from the end of the linked list and the hashmap
Answered by AI
Add your answer

Q1. Multithreading is asked in deep
Add your answer

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Q1. Scenario based leadership questions
Add your answer
Q2. Revenue, margin, leadership skills
Add your answer
Q3. Conflict management, stakeholder management
Add your answer

Q1. Portfolio management
Add your answer
Q2. CI CD pipeline based questions, some other technical questions
Add your answer
Q3. Stakeholder management, project metrics, leadership, team upskilling, resource management, risk management
Add your answer

Q1. Solution architecture questions scenario based
Add your answer
Q2. DR activity scenario based questions
Add your answer

Q1. Cultural fit related
Add your answer
Q2. Leadership and team handling related questions
Add your answer

Q1. Questions about kubernetes and 5gc
Add your answer
Q2. Containers and implementation of pods for 5gc
Add your answer

Q1. Previous company and package negotiation
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced Senior Product Manager with a background in tech industry and a passion for driving product innovation.
• Over 8 years of experience in product management roles

• Strong background in the tech industry, with a focus on software development

• Proven track record of successfully launching and managing products from concept to market

• Passionate about driving product innovation and improving user experiences

• Skilled in cr...read more
Answered by AI
Add your answer
Q2. Aptitude Question
Add your answer

Q1. Experience Questions
Add your answer
Q2. Hobbies and Passion
Add your answer

Q1. Assignment Round with Review at the end
Add your answer
Q2. Pitch GoComet to the founder
Add your answer

Talk about a topic any topic its your wish

40 marks apitude test

Q1. Tell me about yourself
Add your answer
Q2. Situation based questions
Add your answer
Q3. Write email to a vendor ?
Ans. 
Email template for contacting a vendor
• Start with a greeting and introduce yourself/company

• Clearly state the purpose of the email

• Provide any necessary details or specifications

• Request pricing, availability, and terms

• Thank the vendor for their time and consideration

• Include contact information for further communication
Answered by AI
Add your answer

Q1. Basic question about yourself and family etc
Add your answer
Q2. Asking out box question ?
Add your answer

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer