Planetcast
10+ Genstrive Interview Questions and Answers
Q1. Difference between clustered and non clustered index
Clustered index determines the physical order of data in a table, while non-clustered index has a separate structure.
Clustered index sorts and stores the data rows in the table based on their key values, while non-clustered index has a separate structure that contains the key values and a pointer to the data row.
A table can have only one clustered index, while it can have multiple non-clustered indexes.
Clustered index is faster for retrieving large amounts of data, while non-...read more
Q2. Difference between execute scalar and execute nonquery
ExecuteScalar returns single value while ExecuteNonQuery does not return any value.
ExecuteScalar is used for retrieving a single value from the database, such as a count or sum.
ExecuteNonQuery is used for executing SQL statements that do not return any value, such as INSERT, UPDATE, DELETE.
ExecuteScalar returns the first column of the first row of the result set, while ExecuteNonQuery returns the number of rows affected by the query.
ExecuteScalar is faster than ExecuteNonQuer...read more
Q3. Difference between rank and dense rank in c#
Rank assigns unique numbers to each distinct value, while dense rank assigns consecutive numbers to each distinct value.
Rank and DenseRank are used to assign a unique number to each distinct value in a sorted list.
Rank assigns a unique number to each distinct value, but leaves gaps for ties.
DenseRank assigns consecutive numbers to each distinct value, without leaving gaps for ties.
In C#, Rank and DenseRank are available as LINQ extension methods.
Example: Given a list of score...read more
Q4. Difference between function and Stored procedure
Functions return a value while stored procedures do not.
Functions are used to perform a specific task and return a value to the caller.
Stored procedures are used to execute a set of statements and do not return a value.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions can be used in expressions while stored procedures cannot.
Q5. Difference between ienumerable and iqueryable
IEnumerable is read-only and forward-only while IQueryable is queryable and can be filtered.
IEnumerable is used for in-memory collections while IQueryable is used for querying databases.
IQueryable is more efficient for large datasets as it allows for server-side filtering.
IQueryable extends IEnumerable and adds additional functionality for querying data sources.
Example: IEnumerable
numbers = new List { 1, 2, 3 }; IQueryable queryableNumbers = numbers.AsQueryable();
Q6. Reflection and indexers in c#
Reflection and indexers in C#
Reflection allows inspecting and manipulating metadata of types, objects, and assemblies at runtime
Indexers provide a way to access elements of a class or struct using array-like syntax
Reflection can be used to dynamically access and invoke indexers
Q7. What is difference between interface and abstract class
An interface is a contract that defines the methods that a class must implement, while an abstract class can provide some implementation.
An interface can only have abstract methods, while an abstract class can have both abstract and non-abstract methods.
A class can implement multiple interfaces, but can only inherit from a single abstract class.
Interfaces are used to achieve multiple inheritance in Java.
Abstract classes can have instance variables, constructors, and static me...read more
Q8. How react works and how javascript works
React is a JavaScript library for building user interfaces, while JavaScript is a programming language used for web development.
React is a library for building UI components that update dynamically based on data changes.
React uses a virtual DOM to efficiently update the actual DOM.
JavaScript is a programming language used to create interactive elements on web pages.
JavaScript can be used to manipulate HTML elements, handle events, and interact with APIs.
React can be used with...read more
Q9. what are your key strength and area for improvement?
Key strength is leadership and area for improvement is delegation.
Key strength: Strong leadership skills demonstrated through successful team management and project execution.
Area for improvement: Delegation skills can be further developed to empower team members and improve efficiency.
Example: Successfully led a cross-functional team to launch a new product, but could have delegated tasks more effectively to streamline the process.
Q10. life cycle of UIview controller
The life cycle of a UIView controller includes methods for initialization, appearance, disappearance, and deallocation.
ViewDidLoad - called when the view controller's view is loaded into memory
ViewWillAppear - called before the view is added to the view hierarchy
ViewDidAppear - called after the view is added to the view hierarchy
ViewWillDisappear - called before the view is removed from the view hierarchy
ViewDidDisappear - called after the view is removed from the view hierar...read more
Q11. What is enum
Enum is a data type that consists of a set of named values.
Enums are used to define a set of constants that can be assigned to a variable.
They make code more readable and maintainable.
Example: enum Color { RED, GREEN, BLUE }
Enums can also have values assigned to them, like enum Size { SMALL = 1, MEDIUM = 2, LARGE = 3 }
Q12. How to deal with complicated Network.
Q13. Dictation on Shorthand
Dictation on shorthand involves transcribing spoken words into shorthand symbols for efficient note-taking.
Practice listening skills to accurately transcribe spoken words
Familiarize yourself with common shorthand symbols and abbreviations
Use shorthand techniques like omitting vowels and using phonetic spelling
Transcribe the dictation accurately and efficiently to ensure clarity and understanding
Top HR Questions asked in Genstrive
Interview Process at Genstrive
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month