Add office photos
Filter interviews by
BQE Software Interview Questions, Process, and Tips
BQE Software Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
7 Questions
- Q1. Wht is a recursive cte
- Ans.
A recursive CTE is a Common Table Expression that references itself.
It is used to perform recursive operations on hierarchical data.
It consists of two parts: the anchor member and the recursive member.
The anchor member is the base case and the recursive member is the recursive case.
It can be used to traverse a tree structure or to calculate running totals.
It can improve performance and simplify complex queries.
- Q2. What r output parameters
- Ans.
Output parameters are variables used to return values from a function or stored procedure.
Output parameters are declared with the OUTPUT keyword in SQL Server.
They can be used to return a single value or a table of values.
Output parameters are useful for passing data between stored procedures or functions.
They can also be used to return status codes or error messages.
- Q3. What r the advantages of using transactions
- Ans.
Transactions ensure data consistency and integrity in a database.
Allows multiple operations to be treated as a single unit of work
Ensures that all operations are either committed or rolled back as a whole
Prevents data inconsistencies and corruption
Provides ACID properties to the database
Example: transferring funds between bank accounts
Example: updating inventory levels after a purchase
- Q4. Wht are file groups
- Ans.
File groups are logical containers for database files that can be used to manage storage and backup operations.
File groups allow for the organization of database files into logical units.
They can be used to manage storage and backup operations.
A database can have multiple file groups, each with its own set of files.
File groups can be used to control the placement of data and indexes on different physical disks.
File gro...
- Q5. What are magic tables
- Ans.
Magic tables are temporary tables created by SQL Server during DML operations.
Magic tables are used to access the data before and after an INSERT, UPDATE, or DELETE operation.
They are created automatically by SQL Server and cannot be modified by the user.
The inserted and deleted tables are examples of magic tables.
They are useful for auditing and logging changes to a database.
- Q6. Explain use of merg
- Ans.
MERGE is a SQL command used to combine INSERT, UPDATE, and DELETE operations into a single statement.
MERGE is used to synchronize two tables by inserting, updating, or deleting rows based on a specified condition.
It is useful for data warehousing and ETL processes.
MERGE can improve performance by reducing the number of round trips between the client and server.
Syntax: MERGE INTO target_table USING source_table ON condi...
- Q7. Types and scope of temptables
- Ans.
Temp tables are used to store intermediate results during query processing.
Temp tables are created in tempdb database.
They can be local or global.
Local temp tables are only visible to the current session.
Global temp tables are visible to all sessions.
They can be created using SELECT INTO or CREATE TABLE statements.
They can be used to store intermediate results during complex queries.
They are automatically dropped when ...
Interview Preparation Tips
Skills evaluated in this interview
Top BQE Software Database Developer Interview Questions and Answers
Database Developer Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
I applied via Job Fair and was interviewed in Dec 2024. There was 1 interview round.
(7 Questions)
- Q1. Activity Lifecycle when screen rotate.
- Q2. Why do we use Viewmodel?
- Q3. Difference betwwen MVVM and Clean architecture?
- Q4. Design a Image loading library?
- Q5. How Viewmodel work?
- Q6. What is immutable class?
- Q7. What is SharedViewmode?
Technical Program Manager Interview Questions & Answers
Decimal Technologies
Shreya Mishra
posted on 14 Dec 2024
Selected
I applied via LinkedIn and was interviewed in Nov 2024. There were 6 interview rounds.
(1 Question)
- Q1. Technical and process related
(1 Question)
- Q1. Technical and scenario based
(1 Question)
- Q1. Project and process related
(1 Question)
- Q1. With Solution architect
(1 Question)
- Q1. Manager round with complete SDLC
(1 Question)
- Q1. HR round generic questions and salary discussion
Interview Preparation Tips
Data Analyst Interview Questions & Answers
Nineleaps Technology Solutions
Anonymous
posted on 17 Dec 2024
I applied via Instahyre and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. Coalesce, SQL Order of Execution
- Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
- Ans.
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
Write a SQL query to count number of reportees for each manager using GROUP BY clause
Add HAVING clause to filter out managers with atleast 5 reportees
Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
- Q3. How to manage large datasets in python
- Ans.
Use libraries like pandas and dask to efficiently manage large datasets in Python.
Use pandas library for data manipulation and analysis.
Use dask library for parallel computing and out-of-core processing.
Optimize memory usage by loading data in chunks or using data types efficiently.
Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
- Q4. Name few of the commonly used python libraries used by DA
- Ans.
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
Pandas - used for data manipulation and analysis
NumPy - used for numerical computing and working with arrays
Matplotlib - used for data visualization
Scikit-learn - used for machine learning and data mining
Interview Preparation Tips
- SQL
- Python
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
(3 Questions)
- Q1. What are Agile Values? Scrum Values? Scrum Ceremonies? Story Points?
- Ans.
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
Agile values prioritize individuals and interactions over processes and tools
Scrum values include commitment, courage, focus, openness, and respect
Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective
Story points are a unit of...
- Q2. As project manager what docs do you prepare? How do you contribute as a PM?
- Ans.
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
Prepare project plans outlining scope, objectives, deliverables, and timelines
Create schedules to allocate tasks and track progress
Develop budgets to manage project costs effectively
Conduct risk assessments...
- Q3. Capacity? Velocity? etc Agile/Scrum-based questions (bookish) this round was taken by Rajni
(6 Questions)
- Q1. Megha took my final round and asked me questions about Agile/Scrum, Stroy Points (estimation).
- Q2. Ques on explaining Sprint Planning, Retro, Review, using Doc/Excel (screen sharing)
- Q3. Ques on Conflict and Resource Management, some scenario-based question.
- Q4. How will you make a low-performing resource a high-performing one?
- Ans.
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
Clearly communicate expectations and goals to the resource.
Offer support and training to help the resource improve their skills and knowledge.
Provide regular feedback and recognition for progress made.
Set specific goals and milestones to track improvement.
Create a development plan with the resource to addr...
- Q5. Megha did not hire me because she felt I had adequate knowledge and practical experience. (insecurities) Anyway, good luck with your interview.
- Q6. What is Scrum of Scrums? What is PI planning?
- Ans.
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.
PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...
Interview Preparation Tips
- Agile Methodology
- Waterfall
- Scrum
- Project Management
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Sep 2024. There were 4 interview rounds.
Pretty standard GD on topics around working remotely and country's macroeconomic
(2 Questions)
- Q1. Derivative Knowledge Check
- Q2. Alternate Investment Knowledge Check
(2 Questions)
- Q1. Scenario Based and financial instrument level
- Q2. Deep dive into derivative and alternative investment
- Ans.
Derivative and alternative investments involve complex financial instruments and strategies beyond traditional stocks and bonds.
Derivatives are financial contracts whose value is derived from an underlying asset, index, or rate. Examples include options, futures, and swaps.
Alternative investments are non-traditional assets such as private equity, hedge funds, real estate, and commodities.
Both derivative and alternative...
(2 Questions)
- Q1. General HR Question
- Q2. Strength and Weakness
Interview Preparation Tips
Steon Carvalho
(3 Questions)
- Q1. Favorite UPI App, and why?
- Ans.
My favorite UPI app is PhonePe because of its user-friendly interface and wide range of services.
User-friendly interface makes transactions quick and easy
Wide range of services like bill payments, recharges, and shopping
Offers cashback and rewards for transactions
Secure and reliable platform for financial transactions
- Q2. Develop two features to help Paytm cope up with loosing users?
- Ans.
Implement personalized recommendations and loyalty rewards program.
Implement personalized recommendations based on user behavior and preferences to increase user engagement.
Introduce a loyalty rewards program to incentivize users to continue using Paytm and earn rewards for their transactions.
- Q3. Estimate the number of UPI transactions per day in Mumbai?
- Ans.
It is difficult to provide an accurate estimate without specific data, but the number of UPI transactions in Mumbai is likely to be high due to the city's large population and high digital adoption rate.
Mumbai is one of the largest cities in India with a high population density, leading to a high volume of transactions.
UPI (Unified Payments Interface) has gained significant popularity in India as a convenient and secur...
Python Developer Intern Interview Questions & Answers
Vinove Software & Services
Anonymous
posted on 3 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. WHAT IS PANDAS LIBRARY
- Q2. HOW TO DO DATA WRANGLING IN PYTHON
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Oct 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Explain the architecture of transformer models.
- Q2. What's the role of attention in transformers? Additionally, which one of the two networks has a faster training process - RNNs or transformers?
Duration was 1 hour. First asked verbal technical questions based on deep learning concepts, then asked me to code an easy leet code problem.
This round was with the hiring manager. It was mostly like a technical discussion, but he started by discussing the projects that I had worked on from my resume. Then it eventually turned into a system design type of a round.
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
(2 Questions)
- Q1. What is vlookup?
- Ans.
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'vertical lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. What do you know about us health care?
(2 Questions)
- Q1. What is the difference between vlookup and index match?
- Ans.
VLOOKUP searches for a value in the first column of a range and returns a value in the same row. INDEX MATCH is more flexible and can search in any column.
VLOOKUP searches vertically in a table and returns a value from the same row.
INDEX MATCH can search horizontally or vertically and is more versatile.
VLOOKUP requires the lookup value to be in the first column of the table.
INDEX MATCH can search for the lookup value i...
- Q2. Us health care domain specific questions?
(2 Questions)
- Q1. Questions on commitment towards the company, general team behaviour and typical scenario based questions to test your emotional intelligence?
- Q2. Sallery discussion
Interview Preparation Tips
As a fresher you are good to go with this advice
Skills evaluated in this interview
BQE Software Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
BQE Software Reviews and Ratings
based on 43 reviews
Rating in categories
|
Software Developer
22
salaries
|  ₹3 L/yr - ₹11.2 L/yr |
|
Software Engineer
7
salaries
| ₹4.1 L/yr - ₹10.5 L/yr |
|
Database Developer
7
salaries
| ₹4 L/yr - ₹5 L/yr |
|
Senior Software Developer
6
salaries
| ₹8.2 L/yr - ₹12.2 L/yr |
|
Team Lead
5
salaries
| ₹8 L/yr - ₹11.4 L/yr |
DELK
Procore
Trimble
Sage Group
- Home >
- Interviews >
- BQE Software Interview Questions
