AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Collabera Technologies Windows System Administrator Interview Questions and Answers
Collabera Technologies Windows System Administrator Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. DHCP DNS ADDS AZURE Related
- Q2. Complete structure of DHCP and dns
- Ans.
DHCP assigns IP addresses to devices, while DNS resolves domain names to IP addresses.
DHCP stands for Dynamic Host Configuration Protocol
DHCP server assigns IP addresses to devices on a network
DNS stands for Domain Name System
DNS resolves domain names to IP addresses
DNS server maintains a database of domain names and their corresponding IP addresses
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
5 Questions
- Q1. Cte vs temp table
- Ans.
CTE and temp tables are used to store intermediate results in SQL queries.
CTE stands for Common Table Expression and is defined within a query.
Temp tables are created in the tempdb database and can be accessed across sessions.
CTEs are generally faster and more readable than temp tables.
Temp tables are useful for complex queries with multiple steps or when data needs to be manipulated.
CTEs are useful for recursive queri
- Q2. Parameter sniffing
- Q3. Asynchronous programming in .net
- Ans.
Asynchronous programming in .NET allows for non-blocking execution of code, improving performance and responsiveness.
Async and Await keywords used to implement asynchronous programming
Allows for parallel execution of multiple tasks
Improves performance and responsiveness of applications
Examples include web applications, file I/O operations, and database queries
- Q4. Threading in .net
- Ans.
Threading in .NET allows for concurrent execution of code, improving performance and responsiveness.
Threading allows for multiple threads of execution to run concurrently
Thread class is used to create and manage threads
Thread synchronization is important to prevent race conditions and deadlocks
Async/await is a newer approach to concurrency in .NET
TPL (Task Parallel Library) provides higher-level abstractions for concur
- Q5. Performance tuning of SQL stored procedure
- Ans.
Performance tuning of SQL stored procedure involves optimizing query execution time and reducing resource usage.
Identify and optimize the most resource-intensive queries
Use appropriate indexing and partitioning techniques
Minimize network round trips and data transfers
Avoid using cursors and temporary tables
Use query hints and plan guides to influence query execution plan
Regularly monitor and analyze query performance u...
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Sep 2021. There were 5 interview rounds.
(1 Question)
- Q1. The round comprised of basic multiple choice questions from DBMS, networking, data structure, algorithms and Java/C++ coding.
This round consisted of flow diagram based aptitude questions. No multiple choices were present.
A simple group discussion on topics related to current affairs.
(1 Question)
- Q1. An interesting interaction with HR about the company's expectations on hiring you.
(1 Question)
- Q1. This was the final round where simple technical questions were asked from topics specified in applicant's resume. Also some basic questions from Networking and data structures.
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Jan 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Self introduction and technical what is data factory and explain about the project
- Q2. What is your goals and family background
- Ans.
My goal is to become a highly skilled software engineer and contribute to innovative projects. My family background is supportive and has encouraged my pursuit of a career in technology.
Goal: Become a highly skilled software engineer
Contribute to innovative projects
Family background: Supportive and encouraging
Pursuit of a career in technology
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Basic plsql concepts trigger inDexes for cursor loop
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.
Technical MCQ on concepts of Computer Science (Programming, Database, etc)
Flow Chart - Aptitude Round
(1 Question)
- Q1. Technical Interview. Technical questions based on resume. Some basic programming questions.
(2 Questions)
- Q1. What are your strengths and weaknesses?
- Q2. Tell me about yourself.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. What are your goals while looking to join our organization?
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 3 interview rounds.
They will ask you simple programs to check your logical abilities.
(2 Questions)
- Q1. Normal Salary discussion round
- Q2. Questions about family and location
Interview Preparation Tips
Senior Software Engineer Interview Questions & Answers
SS&C TECHNOLOGIES
Anonymous
posted on 10 Dec 2021
I applied via Recruitment Consultant and was interviewed before Dec 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. There were two round of technical Interview followed by HR discussion
- Q2. Questions were from OOPs, .Net Framework, Current Project, SQL
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2021. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Java Memory Management SPRING BOOT END TO END MICROSERVICES
- Q2. Docker commands
- Q3. Deployment
Interview Preparation Tips
Just be clear with your basic they only hit you there.
Collabera Technologies Interview FAQs
Tell us how to improve this page.
Collabera Technologies Interviews By Designations
- Collabera Technologies Software Developer Interview Questions
- Collabera Technologies Talent Specialist Interview Questions
- Collabera Technologies Technical Recruiter Interview Questions
- Collabera Technologies Talent Acquisition Specialist Interview Questions
- Collabera Technologies Software Engineer Interview Questions
- Collabera Technologies Senior Software Developer Interview Questions
- Collabera Technologies Senior Software Engineer Interview Questions
- Collabera Technologies Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Windows Administrator Interview Questions
- Windows Server Administrator Interview Questions
- IT Engineer Interview Questions
- NOC Engineer Interview Questions
- Information Technology Support Engineer Interview Questions
- Windows Vmware Administrator Interview Questions
- IT Administrator Interview Questions
- Senior Windows Administrator Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Collabera Technologies Windows System Administrator Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Software Engineer
347
salaries
|  ₹8 L/yr - ₹26.1 L/yr |
|
Software Engineer
242
salaries
| ₹3.6 L/yr - ₹14.7 L/yr |
|
Technical Recruiter
241
salaries
| ₹1.6 L/yr - ₹6 L/yr |
|
Software Developer
239
salaries
| ₹3.7 L/yr - ₹14.9 L/yr |
|
Talent Specialist
233
salaries
| ₹2 L/yr - ₹5.8 L/yr |
Synechron
Movate
Sopra Steria
SS&C TECHNOLOGIES
- Home >
- Interviews >
- Collabera Technologies Interview Questions >
- Collabera Technologies Windows System Administrator Interview Questions
