i
SMC Global Securities
Filter interviews by
I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 5 interview rounds.
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 by
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...
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 transa...
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#.
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.
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 Runnab
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
Link button is a button that navigates to a different page, while hyperlink is a clickable text or image that navigates to a different page.
Link button is a button element that triggers an action when clicked.
Hyperlink is an anchor element that redirects to a different page or section of the same page.
Link button can be styled like a button with CSS.
Hyperlink is usually styled with an underline and a different color.
Li...
A cursor is a database object that allows traversal over the rows of a result set.
A cursor is used to retrieve and manipulate data row by row.
It is commonly used in database management systems.
There are two types of cursors: implicit and explicit.
An example of using a cursor is iterating through a result set to perform calculations or updates.
Cursors can be used to improve performance by reducing the amount of data tra...
Noramal basic algorithm and ,fetch api
Find the sum of kth to bth largest numbers in a huge array efficiently.
Sort the array in descending order to easily find the kth and bth largest numbers.
Use a priority queue or min heap to efficiently find the kth and bth largest numbers without sorting the entire array.
Once you have the kth and bth largest numbers, iterate through the array and sum the numbers between them.
I applied via Naukri.com
UNION combines the results of two or more SELECT statements, while UNION ALL includes duplicates.
UNION removes duplicate rows, while UNION ALL retains all rows including duplicates
UNION is slower than UNION ALL as it performs a distinct operation
UNION requires the same number of columns in the SELECT statements, while UNION ALL does not have this restriction
Generic collections allow storing any type of data, while non-generic collections are type-specific.
Generic collections can store any type of data, such as List
Non-generic collections are type-specific, like ArrayList or HashTable.
Generic collections provide type safety and better performance compared to non-generic collections.
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
Medium to hard dsa problem
A pn junction diode is a semiconductor device that allows current to flow in one direction only.
Consists of p-type and n-type semiconductor materials
When forward biased, allows current to flow easily
When reverse biased, blocks current flow
posted on 13 Dec 2024
posted on 1 Feb 2024
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
Find min and max from List of Integers using Java 8 streams.
Use the `stream()` method on the List to create a stream of integers.
Use the `min()` method to find the minimum value.
Use the `max()` method to find the maximum value.
Find 2nd largest element using Java 8 streams from a list of integers.
Sort the list of integers in descending order using streams.
Skip the first element to get the second largest element.
Increase the values of a list of integers by 2 and create a new list.
Iterate through the list of integers
For each integer, add 2 to its value
Create a new list with the updated values
Java has introduced several new features in recent versions.
Java 8 introduced lambda expressions, which allow for functional programming.
Java 8 also introduced the Stream API for processing collections of data.
Java 9 introduced the module system, which provides better encapsulation and modularity.
Java 10 introduced local variable type inference, allowing the omission of explicit type declarations.
Java 11 introduced the...
The @Component and @Repository annotations are used in Spring Framework for different purposes.
Both annotations are used to define beans in the Spring container.
@Component is a generic stereotype annotation for any Spring-managed component.
@Repository is a specialization of @Component used for DAO classes.
The @Repository annotation provides additional exception translation for data access exceptions.
Using @Repository i...
The @Entity annotation is used in Java to mark a class as an entity, which represents a table in a relational database.
The @Entity annotation is part of the Java Persistence API (JPA) and is used in object-relational mapping (ORM) to map Java objects to database tables.
It is typically used in conjunction with other JPA annotations like @Table, @Column, and @Id.
The @Entity annotation is used to define the entity name, s...
The database is configured by setting up the necessary parameters and configurations to ensure proper functioning and performance.
Database configuration involves defining the database schema, tables, and relationships.
It includes setting up indexes and constraints for data integrity.
Configuring database security measures like user access control and permissions.
Tuning database performance by optimizing query execution ...
Dockerfile is a text file that contains instructions to build a Docker image.
Dockerfile is used to automate the creation of Docker images.
It specifies the base image, dependencies, environment variables, and commands to run.
Each instruction in the Dockerfile creates a new layer in the image.
Dockerfile can be version controlled and shared to ensure consistent builds.
Example: FROM ubuntu:latest RUN apt-get update && apt-...
CI/CD is a software development practice that enables frequent and automated code integration, testing, and deployment.
CI/CD stands for Continuous Integration and Continuous Deployment.
It involves automating the process of integrating code changes, running tests, and deploying the application.
CI/CD helps in reducing manual errors, improving code quality, and increasing development speed.
Tools like Jenkins, GitLab CI/CD...
Mutable classes in Java are classes whose state can be modified after creation.
Mutable classes allow changing their internal state
They can have mutable fields or methods that modify their state
To create a mutable class, define fields with non-final modifiers
Provide public methods to modify the state of the class
I applied via Campus Placement and was interviewed in Jul 2024. There was 1 interview round.
Java OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction. Exceptions are used for error handling. Java 8 features include lambda expressions, streams, and functional interfaces.
OOPs concepts: Inheritance (e.g. class B extends class A), Polymorphism (e.g. method overloading, overriding), Encapsulation (e.g. private variables with public methods), Abstraction (e.g. abstract classes, interfaces...
based on 3 reviews
Rating in categories
Relationship Manager
211
salaries
| ₹1.5 L/yr - ₹5.8 L/yr |
Assistant Manager
79
salaries
| ₹2.7 L/yr - ₹9.5 L/yr |
Executive
71
salaries
| ₹1.6 L/yr - ₹4 L/yr |
Sales Executive
64
salaries
| ₹1.5 L/yr - ₹3.6 L/yr |
Senior Executive
63
salaries
| ₹1.8 L/yr - ₹4.7 L/yr |
Angel One
Kotak Securities
Sharekhan
ICICI Securities