Wissen Infotech SQL Server Developer Interview Questions and Answers

Q1. Window functions, optimization, normalization
Add your answer
Q2. Index and types, constraints
Add your answer

Q1. 3 SYNTAX TESTS, CONSTRAINTS, INDEX, OPTIMIZATION, NORMALIZATION
Add your answer

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

Q1. I was received a call directly from Talent Acquisition of Cybage . Then a Technical round was scheduled. I was interviewed for SQL developer role. All basics from SQL was asked and a scenario question w...read more
Add your answer

Q1. HR discussion about Company, salary etc
Add your answer
Q2. Why do you want to join Cybage?
Add your answer

Q1. Explain locks and latches
Ans. 
Locks and latches are mechanisms used in database management systems to control access to data and ensure data integrity.
• Locks are used to control access to data by preventing multiple users from modifying the same data simultaneously.

• Latches are lightweight synchronization mechanisms used to protect data structures in memory.

• Locks can be of different types such as shared locks, exclusive locks, and update locks.

• Latche...read more
Answered by AI
Add your answer
Q2. Isolation level in DB
Ans. 
Isolation level determines how transactions interact with each other in a database.
• Isolation levels include Read Uncommitted, Read Committed, Repeatable Read, Serializable.

• Higher isolation levels provide more data consistency but may lead to more locking and potential performance issues.

• Example: Using Read Uncommitted isolation level allows reading uncommitted data, while Serializable ensures data integrity but may lea...read more
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

Ask questions on Android and java

Given small easy project for test given in few hours.

Q1. Threading kotlin
Add your answer
Q2. Play services security
Add your answer