i
Bse Institute
Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Different types of joins include inner join, outer join, left join, and right join. Self join is when a table is joined with itself.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched row...
A view is a virtual table created by a query. It can be used to simplify complex queries, provide security, and improve performance.
Views can hide complexity by encapsulating multiple tables into a single virtual table.
Views can restrict access to certain columns or rows, providing security.
Views can improve performance by pre-computing joins or aggregations.
Example: CREATE VIEW vw_employee AS SELECT emp_id, emp_name F
Optimizing SQL queries involves using indexes, minimizing data retrieval, and avoiding unnecessary joins.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using subqueries or temporary tables
Top trending discussions
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
posted on 15 Sep 2022
posted on 2 May 2023
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
Pattern prg on stair case of building
posted on 30 Sep 2024
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
SOLID is a set of principles for object-oriented programming to make software more maintainable, flexible and understandable.
S - Single Responsibility Principle
O - Open/Closed Principle
L - Liskov Substitution Principle
I - Interface Segregation Principle
D - Dependency Inversion Principle
CURD stands for Create, Update, Read, and Delete. It is a set of basic operations used in database management.
Create - inserting new data into the database
Update - modifying existing data in the database
Read - retrieving data from the database
Delete - removing data from the database
Marker interface is an interface with no methods, used to mark a class as having a certain property or behavior.
Marker interfaces are used to provide metadata to the JVM or other tools.
Examples of marker interfaces in Java include Serializable, Cloneable, and Remote.
Marker interfaces can be used to enforce design patterns or conventions.
Marker interfaces can also be used to indicate that a class should be processed in
Array is a fixed-size data structure while LinkedList is a dynamic data structure.
Arrays have a fixed size while LinkedLists can grow dynamically.
Arrays are faster for accessing elements while LinkedLists are faster for inserting and deleting elements.
Arrays store elements in contiguous memory locations while LinkedLists store elements in nodes with pointers to the next node.
Arrays can be multi-dimensional while Linked
posted on 10 Jan 2022
I applied via Referral and was interviewed before Jan 2021. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Jun 2023. There was 1 interview round.
posted on 2 Feb 2022
I applied via Approached by company and was interviewed in Aug 2021. There was 1 interview round.
No, I am not interested in trading as my focus will be on my role as Assistant Manager.
My primary responsibility as Assistant Manager will be to support the manager in achieving the company's goals.
I will be focused on managing the team, ensuring smooth operations, and delivering excellent customer service.
While I may have an interest in trading, it will not be my priority as an Assistant Manager.
I will be committed to...
posted on 7 Nov 2022
I applied via Recruitment Consulltant and was interviewed in May 2022. There were 3 interview rounds.
I am a dedicated and experienced professional with strong leadership skills and a passion for achieving results.
Experienced in managing teams and driving performance
Skilled in problem-solving and decision-making
Excellent communication and interpersonal skills
Proven track record of meeting targets and exceeding expectations
Passionate about delivering exceptional customer service
Strong organizational and time management
I want to change because I am seeking new challenges and opportunities for growth.
Seeking new challenges and opportunities for growth
Want to expand my skill set and knowledge
Looking for a more dynamic and fast-paced work environment
Desire to take on more responsibilities and contribute to the success of a larger team
Want to work for a company with a strong vision and values that align with my own
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Academic Coordinator
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Marketing Executive
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Counsellor
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Student Relationship Executive
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Content Writer
11
salaries
| ₹0 L/yr - ₹0 L/yr |
National Stock Exchange of India
Bombay Stock Exchange
Multi Commodity Exchange of India
Securities and Exchange Board of India