10+ Planetcast Interview Questions and Answers

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

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

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

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.

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();

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

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

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

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.

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

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 }