Orbit Techsol SQL Server Database Administrator Interview Questions and Answers

Trees, Arrays, DP, Graphs, Leetcode Questions

Q1. Personal Projects
Add your answer
Q2. System design interview, HP Products
Add your answer

Q1. What is Kubernetes ? why it is required? how it is different from Docker swarm?
Ans. 
Kubernetes is an open-source container orchestration platform that automates the deployment, scaling, and management of containerized applications.
• Kubernetes is required to manage and scale containerized applications efficiently.

• It provides features like automatic scaling, self-healing, load balancing, and rolling updates.

• Kubernetes uses a declarative approach to define the desired state of the application and ensures ...read more
Answered by AI
Add your answer
Q2. What is ECS? How it is different from EKS?
Ans. 
ECS is a container management service by AWS, while EKS is a managed Kubernetes service.
• ECS (Elastic Container Service) is a container management service provided by AWS.

• ECS allows you to easily run and scale containerized applications on AWS.

• EKS (Elastic Kubernetes Service) is a managed Kubernetes service by AWS.

• EKS simplifies the process of deploying, managing, and scaling containerized applications using Kubernetes.

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

Q1. It include basic questions regarding the framework, OOPS concepts, some behavioral questions, etc, They also asked to open a notepad and show how to create a singleton class, write a program related to cir...read more
Add your answer

Q1. Discussed on .net technologies
Add your answer

Q1. Discussed on dotnet technologies and lead activities
Add your answer

Simple codes was asked

2 aptitude questions were asked

Q1. Pointer related
Add your answer
Q2. Only 1 question was asked
Add your answer

Q1. System design round about ott
Add your answer
Q2. Leetcode rain water problem
Add your answer

Hacker rank coding test- It was an hour test. We need to optimize the code to run in the specific time limit

Q1. Implement Hashmap- Complete understanding of add, remove methods
Ans. 
Hashmap implementation with add and remove methods
• Hashmap is a data structure that stores key-value pairs

• Add method adds a key-value pair to the hashmap

• Remove method removes a key-value pair from the hashmap

• Hash collision can occur when two keys have the same hash value

• In case of collision, separate chaining or open addressing can be used
Answered by AI
Add your answer
Q2. Design elevators - How would you design how elevators work. How do you add different roles etc.
Ans. 
Designing elevators and adding different roles.
• Design a system that can handle multiple elevators and floors

• Implement a scheduling algorithm to optimize elevator usage

• Add roles such as maintenance, emergency, and security

• Incorporate safety features such as emergency stop buttons and sensors

• Consider accessibility for individuals with disabilities
Answered by AI
Add your answer

Q1. A scenario to create a new Android service
Ans. 
Creating a new Android service
• Define a class that extends Service class

• Override onStartCommand() method to handle service logic

• Register the service in AndroidManifest.xml file
Answered by AI
Add your answer
Q2. 2 puzzles. one was to find min no of weighs to find faulty item among 8 items and the other one was to min no of races required to find top three horses among 25 horses
Add your answer
Q3. How to manage gralloc buffers
Ans. 
Managing gralloc buffers involves allocating, locking, and freeing memory for graphics rendering in Android.
• Allocate gralloc buffer using gralloc_alloc() function

• Lock buffer for reading or writing using gralloc_lock() function

• Free buffer using gralloc_free() function

• Example: gralloc_alloc(usage, width, height, format, &handle)

• Example: gralloc_lock(handle, usage, left, top, width, height, &vaddr)
Answered by AI
Add your answer
Q4. What is HIDL vs AIDL
Ans. 
HIDL stands for Hardware Interface Definition Language and is used for communication between HAL and framework. AIDL stands for Android Interface Definition Language and is used for inter-process communication in Android.
• HIDL is used for communication between Hardware Abstraction Layer (HAL) and framework in Android

• AIDL is used for inter-process communication in Android

• HIDL is more efficient and faster than AIDL
Answered by AI
Add your answer
Q5. How Android buffers are passed from application to drivers.
Ans. 
Android buffers are passed from application to drivers through shared memory and buffer queues.
• Android applications communicate with drivers through the HAL (Hardware Abstraction Layer)

• Buffers are typically passed using shared memory regions

• Buffer queues are used to manage the flow of data between application and driver

• Example: Camera application passing image data to camera driver for processing
Answered by AI
Add your answer
Q6. What happens if LINUX faces a hardware interrupt
Ans. 
When LINUX faces a hardware interrupt, it stops executing the current code and jumps to a specific interrupt handler.
• LINUX stops executing the current code and jumps to a specific interrupt handler

• The interrupt handler processes the interrupt and resumes normal execution afterwards

• Different hardware interrupts are handled by different interrupt handlers
Answered by AI
Add your answer
Q7. What is the challenge while creating multiple services in Android
Ans. 
The challenge while creating multiple services in Android is managing communication between services and ensuring proper synchronization.
• Managing communication between services can be complex and error-prone.

• Ensuring proper synchronization between services to avoid race conditions and data inconsistencies.

• Handling dependencies between services and coordinating their interactions.

• Testing and debugging multiple services ...read more
Answered by AI
Add your answer
Q8. Boot up Android sequence
Ans. 
The Android boot up sequence involves several stages including power on, bootloader, kernel initialization, system server startup, and app launch.
• Power on the device

• Bootloader loads the Android OS kernel

• Kernel initializes the system and drivers

• System server starts up and launches essential services

• Apps are launched and user interface becomes accessible
Answered by AI
Add your answer
Q9. Describe about Permission files/SE Linux policy
Ans. 
Permission files/SE Linux policy control access to resources based on rules set by administrators.
• Permission files define who can access a file or directory and what actions they can perform.

• SE Linux policy is a security mechanism that enforces rules on how processes interact with resources.

• SE Linux policy is based on labels assigned to processes and resources, determining access permissions.

• SE Linux policy can be cust...read more
Answered by AI
Add your answer
Q10. What is manifestation file and how is it used?
Ans. 
A manifestation file is a configuration file used to define the properties and settings of a software application.
• Manifestation files typically include information such as the application's name, version, dependencies, and permissions.

• They are commonly used in software development to ensure that the application runs correctly and has access to necessary resources.

• Examples of manifestation files include AndroidManifest....read more
Answered by AI
Add your answer