CAMS SQL Server Database Administrator Interview Questions and Answers

Medium leetcode question on array list

Q1. Core java and collections, exceptions and threading
Add your answer
Q2. Core java collections
Add your answer
Q3. Multi threading
Add your answer
Q4. Executor framework
Add your answer

Q1. Threading related questions
Add your answer

Hackathon Test with 2 medium level coding question.

Technical Video Interview- Java concepts mostly related to Java 8, 1 coding program and some db questions were asked.

Q1. Questions related to System Design.
Add your answer

Q1. Questions related to my projects . Some questions related to my current role and responsibilities.
Add your answer

Q1. Basic java questions and 2 DSA medium level problems
Add your answer
Q2. Two sum leet code problem
Add your answer

Q1. Design round. Design a system that send notification’s to all the passengers of trains just when the train arrives at the station next to it. And one question on tree LCA
Ans. 
Design a system to send notifications to train passengers when the train arrives at the next station.
• Use GPS tracking to determine train location in real-time

• Implement a notification system that sends alerts to passengers' devices

• Integrate with train schedule data to know when the train is approaching the next station
Answered by AI
Add your answer

Asked basic questions .... To check concept and logic

Q1. SQL query for------ deleting duplicate from table
Add your answer
Q2. SQL query for second highest salary
Ans. 
SQL query to find second highest salary
• Use ORDER BY and LIMIT to get the highest salary

• Use subquery to exclude the highest salary and get the second highest
Answered by AI
Add your answer

Q1. Basic information and documents verification
Add your answer

Q1. Roles and responsibilities and queries solving .
Add your answer

Medium leetcode problem on array and linked list. And some theoretical questions

Q1. Core java , collections, object oriented principles . Some small coding questions based on usage of overriding and overloading
Add your answer

Q1. Multi treading and 1 problem solving question.
Add your answer

Q1. Discussion with ED : expectations and managerial questions
Add your answer

Q1. Typical HR questions
Add your answer

Q1. Array related problem
Add your answer

Q1. C# oops related deep question
Add your answer

Q1. Project Design related questions
Add your answer

Q1. SQL Linq mvc net core related questions
Add your answer

Some questions that range from easy to medium level.

Q1. General questions around your resume, the tech stacks you worked on, fundamentals and deepdive into that.
Add your answer
Q2. High level system design
Ans. 
High level system design involves creating an overall architecture for a software system.
• Identify the main components of the system

• Define the interactions between components

• Consider scalability, reliability, and performance

• Use diagrams like UML to visualize the design
Answered by AI
Add your answer

Q1. Can you describe your experience, the projects you have worked on, challenges you solved and other stuffs around that.
Ans. 
I have extensive experience working on various software projects, overcoming challenges and delivering successful solutions.
• Developed a web application for a healthcare company to streamline patient data management

• Implemented a real-time messaging feature in a social media platform to improve user engagement

• Optimized database queries to improve performance of an e-commerce website

• Collaborated with cross-functional team...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer

How would you approach performance issues in an application module

Q1. How would you process millions of records in an excel file
Ans. 
Use programming language to read and process data from Excel file efficiently.
• Use a programming language like Python, Java, or C# to read the Excel file.

• Utilize libraries like pandas in Python or Apache POI in Java for efficient data processing.

• Implement batch processing or parallel processing to handle millions of records efficiently.

• Optimize code for memory management and performance to avoid crashes or slowdowns.

• Con...read more
Answered by AI
Add your answer