People Tech Group SQL Server Developer Interview Questions and Answers

Q1. Depth of my experience, every skill associated with the role.
Add your answer

Q1. Breadth of my experience, across various projects i had executed that were in my resume.
Add your answer

Totally irrelevant to the role and to my experience.

Q1. What is static in Java?
Add your answer
Q2. What is singleton?
Add your answer
Q3. What is Coroutines?
Add your answer
Q4. What is dispatcher?
Add your answer
Q5. What is with context in Coroutines?
Add your answer
Q6. How to raise request parallel in Coroutines?
Add your answer
Q7. Scoped functions in Kotlin.
Add your answer
Q8. Background task in Android.
Add your answer
Q9. What is the difference between interface and abstract class in Java?
Add your answer
Q10. What is let function?
Add your answer

Q1. Tell me about ur self
Add your answer
Q2. And some sql queries and questions
Add your answer

Sum two int number without class

My Gd topic is AI normal structure

Q1. Few questions about powercenter
Add your answer

Q1. When we are use interface and abstract class in Android
Ans. 
Interfaces and abstract classes are used in Android to achieve abstraction, modularity, and code reusability.
• Interfaces are used to define a contract that classes must implement, allowing for polymorphism and loose coupling.

• Abstract classes provide a base implementation for subclasses, allowing for code reuse and providing common functionality.

• Interfaces are commonly used for event handling, callbacks, and defining con...read more
Answered by AI
Add your answer

Q1. Tell me about fluter bloc,
Ans. 
Flutter Bloc is a state management library for Flutter that helps manage the state of a widget.
• Flutter Bloc helps separate the presentation layer from the business logic

• It uses streams to handle state changes

• It provides a way to handle events and map them to states

• Example: BlocProvider, BlocBuilder, BlocListener
Answered by AI
Add your answer
Q2. What is provider
Ans. 
A provider is a component in Android that allows apps to access data from other apps or share their own data.
• Providers are used to manage access to a structured set of data.

• They are typically used to store and retrieve data from a database.

• Content providers are a type of provider that allows apps to share data with other apps.
Answered by AI
Add your answer

Q1. Explain MVVM architecture
Ans. 
MVVM is an architectural pattern that separates the UI, business logic, and data layers in an Android app.
• Model: Represents the data and business logic of the application.

• View: Represents the UI components of the application.

• ViewModel: Acts as a mediator between the Model and View, handling communication and logic.

• Data binding: MVVM uses data binding to synchronize the View and ViewModel.

• Example: In an Android app, the...read more
Answered by AI
Add your answer
Q2. Explain Java Basic concept
Ans. 
Java is a high-level programming language known for its simplicity and versatility.
• Java is an object-oriented language

• It is platform-independent due to its 'write once, run anywhere' principle

• Java uses a virtual machine (JVM) to execute code

• It supports multithreading for concurrent programming

• Java has automatic memory management through garbage collection
Answered by AI
Add your answer
Q3. Explain Kotlin modifiers
Ans. 
Kotlin modifiers are keywords used to modify classes, properties, functions, and other elements in Kotlin programming language.
• Kotlin modifiers include 'public', 'private', 'protected', 'internal', 'open', 'final', 'abstract', 'override', 'lateinit', 'const', 'companion', 'inline', 'data', 'sealed', 'inner', etc.

• Modifiers like 'public', 'private', 'protected', and 'internal' control the visibility of classes, functions...read more
Answered by AI
Add your answer
Q4. Explain RXJava networking library
Ans. 
RXJava is a popular Java library for composing asynchronous and event-based programs using observable sequences.
• RXJava provides a powerful way to handle asynchronous operations by using observables and subscribers.

• It simplifies complex asynchronous code by allowing developers to chain operations and handle errors more easily.

• RXJava is commonly used in Android development for handling network requests and background tas...read more
Answered by AI
Add your answer
Q5. Explain Git commit , merge and rebase command
Ans. 
Git commit records changes to the repository, merge combines changes from different branches, and rebase moves changes to a new base commit.
• Git commit saves changes to the local repository with a message describing the changes made.

• Git merge combines changes from different branches into the current branch.

• Git rebase moves changes from one branch to another by applying each commit from the source branch to the target br
Answered by AI
Add your answer