Premium Employer

i

This company page is being actively managed by Smart Energy Water Team. If you also belong to the team, you can get access from here

Smart Energy Water Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Smart Energy Water Database Developer Interview Questions and Answers

Updated 7 Jun 2024

Smart Energy Water Database Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Apti + Basic Coding and SQL questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. What are DBMS? how do you manage them?
  • Ans. 

    DBMS stands for Database Management System. It is a software that allows users to interact with databases.

    • DBMS is used to create, update, and manage databases.

    • It provides tools for data storage, retrieval, and manipulation.

    • Examples of DBMS include MySQL, Oracle Database, and Microsoft SQL Server.

  • Answered by AI
  • Q2. What are indexes? How are they built
  • Ans. 

    Indexes are data structures that improve the speed of data retrieval in databases.

    • Indexes are built on columns in database tables to quickly locate rows based on the indexed column values.

    • They are typically implemented using B-tree or hash data structures.

    • Examples of indexes include primary keys, unique keys, and non-unique indexes.

    • Creating an index involves sorting the values of the indexed column and storing pointers

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Its easy just keep calm

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview before May 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 90 minutes
Round difficulty - Easy

Timing - 10AM-11:30AM
Online proctored test

  • Q1. 

    Binary Tree Right View Problem Statement

    Given a binary tree of integers, your task is to print the right view of it. The right view represents a set of nodes visible when the tree is viewed from the righ...

  • Ans. 

    The task is to print the right view of a binary tree, representing nodes visible from the right side in top-to-bottom order.

    • Traverse the tree level by level and keep track of the rightmost node at each level

    • Print the rightmost node of each level to get the right view of the tree

    • Use a queue for level order traversal and a map to store the rightmost nodes

  • Answered by AI
  • Q2. 

    0/1 Knapsack Problem Statement

    A thief is planning to rob a store and can carry a maximum weight of 'W' in his knapsack. The store contains 'N' items where the ith item has a weight of 'wi' and a value of...

  • Ans. 

    Yes, the 0/1 Knapsack problem can be solved using dynamic programming with a space complexity of not more than O(W).

    • Use a 1D array to store the maximum value that can be stolen for each weight from 0 to W.

    • Iterate through each item and update the array based on whether including the item would increase the total value.

    • The final value in the array at index W will be the maximum value that can be stolen.

  • Answered by AI
Round 2 - Video Call 

(2 Questions)

Round duration - 45 minutes
Round difficulty - Medium

Timing : 4PM-5PM
Environment - Online

There was a panel of 3 interviewers

  • Q1. How can you find the size of an array in C or C++ without using sizeof or any standard function?
  • Ans. 

    You can find the size of an array in C or C++ by dividing the total size of the array by the size of one element.

    • Calculate the total size of the array by multiplying the number of elements by the size of each element.

    • Divide the total size by the size of one element to get the size of the array.

    • For example, if you have an array of strings arr[] = {'hello', 'world', 'example'}, you can find the size by dividing the total

  • Answered by AI
  • Q2. Explain how indexing in a database works using B+ trees.
  • Ans. 

    B+ trees are used for indexing in databases to efficiently search and retrieve data.

    • B+ trees are balanced trees where each node can have multiple keys and child pointers.

    • Data is stored in leaf nodes, while non-leaf nodes are used for navigation.

    • B+ trees are commonly used in databases because of their ability to efficiently search and retrieve data.

    • Example: In a database table with an index on a specific column, B+ tree...

  • Answered by AI
Round 3 - Video Call 

(1 Question)

Round duration - 45 mintues
Round difficulty - Easy

Timing - 11AM-12:15PM
Environment - online video call

Again there was a panel of 2 senior engineers

  • Q1. 

    Maximum Path Sum Problem Statement

    You are given an n-ary tree consisting of 'N' nodes. Your task is to determine the maximum sum of the path from the root to any leaf node.

    Example:

    Input:
    For the giv...
  • Ans. 

    Find the maximum sum of the path from the root to any leaf node in an n-ary tree.

    • Traverse the tree from root to leaf nodes while keeping track of the sum of each path.

    • At each node, calculate the sum of the path from the root to that node and update the maximum sum found so far.

    • Consider using depth-first search (DFS) or breadth-first search (BFS) for tree traversal.

    • Handle cases where nodes have negative values or where

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Netaji Subhas University Of Technology. I applied for the job as SDE - 1 in NoidaEligibility criteria7.5 CGPAANSYS, Inc. interview preparation:Topics to prepare for the interview - System Design, core C++, Algorithms, Data Structures, DBMSTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Brush Up on Computer Science Fundamentals
Tip 2 : Prepare a Brief Self-Introduction

Application resume tips for other job seekers

Tip 1 : Do not put fake resume
Tip 2 : Writing internship project helps.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Project based backend and frontend
  • Q2. How to connect to backend
  • Ans. 

    To connect to the backend, you can use APIs, database connections, or web services.

    • Use APIs to send and receive data between the frontend and backend

    • Establish database connections to retrieve and store data

    • Utilize web services for communication between different systems

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for project

Skills evaluated in this interview

Round 1 - Technical 

(1 Question)

  • Q1. Based on c# ,oops and SQL server
Round 2 - Technical 

(1 Question)

  • Q1. Technical and director round
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good experience to interview with CIS . The process was smooth and easy.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself Tell me about your final year project Your family background
Round 3 - Technical 

(1 Question)

  • Q1. Tell me about yourself Class and object Constructor Polymorphism Multithreading Exception handling
Round 4 - Coding Test 

Pattern program
Multithreading program
And overriding program

Interview Preparation Tips

Interview preparation tips for other job seekers - They only want experience candidates overall interview is good .
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Laravel based questions, badabase questions
  • Q2. Database query joins , having cluuase javascript jQuery

Interview Preparation Tips

Interview preparation tips for other job seekers - Awesome, this company is really good for learning and career.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is class what is object what is different between private protected and public and default
  • Ans. 

    A class is a blueprint for creating objects, while an object is an instance of a class. Private, protected, public, and default are access modifiers in object-oriented programming.

    • A class is a template or blueprint that defines the properties and behaviors of objects.

    • An object is an instance of a class, created using the class blueprint.

    • Private access modifier restricts access to class members within the same class.

    • Pro...

  • Answered by AI
  • Q2. What is object ?
  • Ans. 

    An object is a self-contained entity that consists of both data and behavior.

    • Objects are instances of classes in object-oriented programming.

    • They encapsulate data and provide methods to manipulate that data.

    • Objects can interact with each other through method calls and message passing.

    • Examples of objects include a car, a person, or a bank account.

  • Answered by AI
  • Q3. What is public?
  • Ans. 

    Public is a keyword in programming languages that denotes the accessibility of a class, method, or variable.

    • Public is one of the access modifiers in object-oriented programming.

    • It allows the class, method, or variable to be accessed from any other class or package.

    • Public members are part of the public API of a software component.

    • Example: public class MyClass { ... }

    • Example: public void myMethod() { ... }

    • Example: public

  • Answered by AI
  • Q4. What is private?
  • Ans. 

    In programming, private is an access modifier that restricts the visibility of a class member to within its own class.

    • Private is used to encapsulate data and prevent direct access from outside the class.

    • Private members can only be accessed through public methods or properties.

    • Private variables are often used to store internal state or implementation details.

    • Private methods are used for internal logic and are not meant

  • Answered by AI
  • Q5. What is protected
  • Ans. 

    protected is an access modifier in object-oriented programming that restricts access to members within the same package or subclasses.

    • protected is one of the four access modifiers in Java, along with public, private, and default.

    • Members declared as protected can be accessed within the same package or by subclasses.

    • Protected members are not accessible outside the package unless accessed through inheritance.

    • Example: prot...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cyber Infrastructure Software Developer interview:
  • OOPS
  • Java
Interview preparation tips for other job seekers - Know what you have written in your resume

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About payment method integration
  • Q2. Oops concept,

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident,

Be polite and honest to them,

Answered to questions

I applied via LinkedIn and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Pattern Programs SQL Queries
Round 2 - Coding Test 

Interview Preparation Tips

Interview preparation tips for other job seekers - More focus on OOPS concepts
Pattern Programs
SQL queries
Project
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

That was conducted in my College and it was online assessment for aptitude

Round 2 - Technical 

(1 Question)

  • Q1. Difference between == and ===
  • Ans. 

    The == operator checks for equality, while the === operator checks for strict equality (including data type).

    • The == operator only checks for equality of values, not data types.

    • The === operator checks for both equality of values and data types.

    • Example: 5 == '5' would return true, but 5 === '5' would return false.

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Describe your final year project
  • Q2. What was your role in your final year project
Round 4 - HR 

(1 Question)

  • Q1. Salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company and environment

Skills evaluated in this interview

Smart Energy Water Interview FAQs

How many rounds are there in Smart Energy Water Database Developer interview?
Smart Energy Water interview process usually has 2 rounds. The most common rounds in the Smart Energy Water interview process are Coding Test and One-on-one Round.
How to prepare for Smart Energy Water Database Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Smart Energy Water. The most common topics and skills that interviewers at Smart Energy Water expect are ETL Testing, Indexing, Performance Tuning, SQL and SQL Server.
What are the top questions asked in Smart Energy Water Database Developer interview?

Some of the top questions asked at the Smart Energy Water Database Developer interview -

  1. What are indexes? How are they bu...read more
  2. What are DBMS? how do you manage th...read more

Tell us how to improve this page.

Smart Energy Water Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Smart Energy Water Global Energy & Water AI Platform

Interview Questions from Similar Companies

Apisero Interview Questions
4.3
 • 65 Interviews
TestingXperts Interview Questions
3.9
 • 41 Interviews
Credera Interview Questions
3.8
 • 40 Interviews
Stefanini Interview Questions
2.9
 • 35 Interviews
GlobalStep Interview Questions
2.7
 • 28 Interviews
SpanIdea Interview Questions
3.7
 • 24 Interviews
View all
Smart Energy Water Database Developer Salary
based on 18 salaries
₹5.5 L/yr - ₹11.3 L/yr
41% more than the average Database Developer Salary in India
View more details
Product Engineer
105 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Senior Product Engineer
72 salaries
unlock blur

₹7.5 L/yr - ₹27 L/yr

Senior Software Engineer
63 salaries
unlock blur

₹6.6 L/yr - ₹21.2 L/yr

Production Analyst
54 salaries
unlock blur

₹7 L/yr - ₹9.8 L/yr

Technical Lead
37 salaries
unlock blur

₹9.8 L/yr - ₹24 L/yr

Explore more salaries
Compare Smart Energy Water with

Apisero

4.3
Compare

Actalent Services

3.5
Compare

Cyber Infrastructure

3.5
Compare

TestingXperts

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview