10+ SMC Global Securities Software Developer Interview Questions and Answers

Constructor is a special method used to initialize objects in a class.

• Constructors have the same name as the class and no return type.

• They are called automatically when an object is created.

• They can be used to set default values for object properties.

• Multiple constructors can be defined with different parameters.

• Example: public class Person { public Person() { // constructor code } }

WHERE clause filters rows before grouping, HAVING clause filters groups after grouping.

• WHERE clause is used with SELECT, UPDATE, DELETE statements.

• HAVING clause is used with GROUP BY clause.

• WHERE clause filters rows based on a condition.

• HAVING clause filters groups based on a condition.

• WHERE clause is executed before GROUP BY clause.

• HAVING clause is executed after GROUP BY clause.

A function in SQL is a pre-written code that performs a specific task and returns a value.

• SQL functions can be categorized into scalar, aggregate, and table-valued functions.

• Scalar functions return a single value based on the input parameters.

• Aggregate functions return a single value based on a group of rows.

• Table-valued functions return a table as output.

• Examples of SQL functions include COUNT, SUM, AVG, MAX, MIN, and CONCAT.

Action filter is a feature in ASP.NET MVC that allows you to execute code before or after an action method is executed.

• Action filters are attributes that can be applied to an action method or controller.

• There are four types of action filters: Authorization filters, Action filters, Result filters, and Exception filters.

• Authorization filters are used to authenticate users and restrict access to actions.

• Action filters are used to perform some action before or after an action met...read more

A transaction is a unit of work that is performed against a database.

• A transaction is a sequence of one or more SQL operations that are treated as a single logical unit of work.

• It ensures that either all the operations are completed successfully or none of them are.

• The four properties of a transaction are Atomicity, Consistency, Isolation, and Durability (ACID).

• Types of transactions include Implicit and Explicit transactions, Distributed transactions, and Autonomous transacti...read more

An interface is a contract that defines the methods and properties that a class must implement.

• Interfaces provide a way to achieve abstraction in programming.

• They allow for loose coupling between components.

• Interfaces can be used to define a common set of methods that multiple classes can implement.

• Interfaces can be used to achieve polymorphism.

• Examples of interfaces in Java include Serializable, Comparable, and Runnable.

Static class cannot be instantiated and sealed class cannot be inherited.

• Static class members are accessed using the class name itself.

• Sealed class can be used to prevent further inheritance of a class.

• Example of static class: Math class in C#.

• Example of sealed class: String class in C#.

Serialisation is the process of converting an object into a stream of bytes to store or transmit it over a network.

• Serialisation is used to save the state of an object and recreate it later.

• It is commonly used in network communication to transmit data between different systems.

• Serialisation can be done in different formats such as XML, JSON, or binary.

• Deserialisation is the opposite process of converting a stream of bytes back into an object.

Link button is a button that looks like a hyperlink but behaves like a button, while a hyperlink is a clickable text or image that redirects to another page.

• Link button is styled like a button and typically used for actions like submitting a form or triggering a function.

• Hyperlink is styled like regular text or an image and is used to navigate to another webpage or location.

• Example: <button>Link Button</button> vs <a href='https://www.example.com'>Hyperlink</a>