AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Nanubhai Education Foundation Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Selected
I was interviewed in Jan 2025.
(14 Questions)
- Q1. Queries on joins using inner join, left join, right join, outer join
- Q2. What are the definitions of case and decode, what are the differences between them, and can you explain the logic for each?
- Ans.
Case and decode are conditional expressions in PL/SQL used for data manipulation.
CASE is used for conditional logic in SQL statements, while DECODE is used for conditional logic in SELECT statements.
CASE is more flexible and can handle multiple conditions, while DECODE is limited to one condition.
CASE can be used in both SQL and PL/SQL, while DECODE is specific to SQL.
Example of CASE: SELECT CASE WHEN condition1 THEN r...
- Q3. What are the primary key and foreign key in database design, and can you provide examples of each?
- Ans.
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
Primary key ensures uniqueness and cannot have null values
Foreign key establishes a relationship between tables based on the primary key of another table
Example of primary key: EmployeeID in an Employee table
Example of foreign key: DepartmentID in an Employee table linking to DepartmentID in a Department tabl
- Q4. What are the differences between Rank and Dense Rank in SQL?
- Ans.
Rank assigns unique ranks to each distinct row, while Dense Rank assigns consecutive ranks without gaps.
Rank may have gaps in the ranking sequence, while Dense Rank does not.
Rank assigns the same rank to rows with the same values, while Dense Rank assigns different ranks.
Rank function is non-consecutive, while Dense Rank function is consecutive.
- Q5. What is the difference between procedures and functions?
- Ans.
Procedures are used to perform an action, while functions return a value.
Procedures do not return a value, while functions do.
Functions can be called from SQL queries, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
- Q6. Is it possible to use a package body without a package specification?
- Ans.
No, a package body cannot be used without a package specification.
A package body must always be associated with a package specification.
The package specification defines the public interface of the package, while the package body contains the implementation details.
Attempting to use a package body without a corresponding package specification will result in compilation errors.
- Q7. What is a SQL query that can be used to find duplicate values in a database?
- Ans.
Use a SQL query with GROUP BY and HAVING clause to find duplicate values in a database.
Use GROUP BY clause to group the values that are duplicated.
Use HAVING clause to filter out the groups that have more than one occurrence.
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
- Q8. Queries using group by and having clause
- Ans.
Group by and having clause are used together to filter groups based on specified conditions.
Group by clause is used to group rows that have the same values into summary rows.
Having clause is used to filter groups based on specified conditions.
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;
- Q9. What are the definitions of the Substr and Instr functions?
- Ans.
Substr function extracts a substring from a string, while Instr function returns the position of a substring within a string.
Substr function syntax: SUBSTR(string, start_position, length)
Example: SUBSTR('Hello World', 7, 5) will return 'World'
Instr function syntax: INSTR(string, substring)
Example: INSTR('Hello World', 'World') will return 7
- Q10. What is the process for writing a SQL query that includes a subquery?
- Ans.
Writing a SQL query with a subquery involves nesting one query inside another to retrieve specific data.
Start by writing the main query that will retrieve the primary data
Identify the criteria for the subquery to filter the results
Enclose the subquery within parentheses and use it in the WHERE or FROM clause of the main query
Ensure that the subquery returns a single value or a single column result
- Q11. What is the difference between char, varchar, and varchar2 data types?
- Ans.
Char is fixed length, varchar is variable length with max 4000 bytes, varchar2 is variable length with max 32767 bytes.
Char is fixed length and always right-padded with spaces, while varchar and varchar2 are variable length.
Varchar can store up to 4000 bytes of data, while varchar2 can store up to 32767 bytes.
Char is less efficient in terms of storage compared to varchar and varchar2.
- Q12. Queries using Trunc and round
- Q13. Is it possible to combine two tables with differing data and columns without utilizing joins?
- Ans.
No, it is not possible to combine two tables with differing data and columns without utilizing joins.
Joins are necessary to combine tables based on a common column or key.
Different data and columns require a join to match and merge the data properly.
Examples of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Q14. Is it possible to update data in a view?
- Ans.
Yes, it is possible to update data in a view using INSTEAD OF triggers.
Views are virtual tables that display data from one or more tables.
By using INSTEAD OF triggers, you can update data in a view by specifying the logic to handle the update operation.
The trigger intercepts the update operation on the view and executes the specified logic to update the underlying tables.
For example, you can create an INSTEAD OF trigge...
(6 Questions)
- Q1. Can you describe yourself and provide details about your project, including the brief questions that were asked about it?
- Q2. Why TCS?
- Ans.
TCS is a global IT services company known for its innovative solutions and commitment to employee growth.
TCS has a strong reputation in the IT industry for delivering high-quality services.
TCS offers opportunities for professional growth and development through training programs and career advancement.
TCS has a diverse and inclusive work culture that values teamwork and collaboration.
- Q3. What is a dynamic cursor in database management?
- Ans.
A dynamic cursor in database management allows for the execution of different SQL queries at runtime.
Dynamic cursors are used when the SQL query to be executed is not known until runtime.
They allow for flexibility in querying the database based on user input or other conditions.
Dynamic cursors can be used to handle varying result sets or conditions in a more efficient manner.
Example: Using a dynamic cursor to search fo...
- Q4. Did you perform performance tuning, and if so, what steps did you take?
- Ans.
Yes, I have performed performance tuning by identifying bottlenecks and optimizing queries.
Identified slow queries using tools like SQL Trace, Explain Plan, and AWR reports.
Optimized queries by adding indexes, rewriting SQL statements, and reducing unnecessary data retrieval.
Tuned PL/SQL code by using bulk processing, minimizing context switches, and optimizing loops.
Utilized database features like partitioning and mat
- Q5. What is the definition of a package, and is it possible to use a package body without a package specification?
- Ans.
A package in PL/SQL is a collection of related procedures, functions, variables, and other constructs.
A package consists of two parts: package specification and package body.
The package specification defines the public interface of the package, including declarations of variables, constants, cursors, procedures, and functions.
The package body contains the actual implementation of the procedures and functions declared i...
- Q6. I got more questions from my project related
(6 Questions)
- Q1. What are your reasons for wanting to join TCS?
- Ans.
I am excited about the opportunity to work with a global leader like TCS and contribute to innovative projects.
TCS is a renowned global company with a strong reputation in the IT industry
I am impressed by TCS's commitment to innovation and cutting-edge technology
I believe TCS offers great opportunities for professional growth and development
I am excited about the chance to work on diverse and challenging projects at TC
- Q2. What is your current salary package?
- Ans.
I prefer to discuss my salary expectations based on the responsibilities and requirements of the position.
Focus on discussing salary expectations based on the job responsibilities and requirements.
Avoid disclosing specific current salary package.
Emphasize the importance of fair compensation based on market rates and skills.
Provide examples of successful projects or achievements that demonstrate your value.
Discuss oppor...
- Q3. What is your expected salary package?
- Ans.
I am looking for a competitive salary package based on my experience and skills.
I am open to discussing salary based on the responsibilities and requirements of the role.
I have researched the average salary range for Plsql Developers in this location.
I am looking for a package that includes benefits such as healthcare, retirement plans, and professional development opportunities.
- Q4. Are you comfortable with shift work?
- Ans.
Yes, I am comfortable with shift work and have experience working various shifts.
I have previous experience working different shifts in my current/previous roles.
I am flexible with my schedule and can easily adapt to changing shift patterns.
I understand the importance of shift work in ensuring 24/7 coverage for critical systems.
- Q5. Are you ok with any location
- Ans.
Yes, I am open to any location for the Plsql Developer position.
I am willing to relocate for the right opportunity
I am open to working in different cities or countries
I am flexible with travel requirements for the job
- Q6. Holding any other offers in hand
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Interview Preparation Tips
I was interviewed in Jan 2025.
(6 Questions)
- Q1. Multi cast in angular
- Q2. Why event emitter what it does
- Q3. Handling multiple api calls
- Q4. Higher order functions
- Q5. Child route and forRoot difference
- Q6. Ng-container , ng-template
ravindar
Selected
I was interviewed in Feb 2025.
(2 Questions)
- Q1. Call flow 4G 5G
- Q2. Troubleshooting of subscriber issues
(2 Questions)
- Q1. PCRF AND CLOUD INFRASTRUCTURE
- Q2. Telecommunication knowledge
Interview Preparation Tips
Selected
(2 Questions)
- Q1. Asking introduction and tools
- Q2. Asking command and down Time
Interview Preparation Tips
1. Optimize Your Resume & Cover Letter
Tailor your resume to each job by highlighting relevant skills and experience.
Use keywords from the job description to pass Applicant Tracking Systems (ATS).
Keep it concise (1-2 pages) and error-free.
Your cover letter should tell a compelling story about why you're a great fit.
2. Build & Leverage Your Network
Let friends, family, and former colleagues know you're job hunting.
Use LinkedIn to connect with professionals in your industry.
Attend networking events, career fairs, and industry meetups.
3. Use Multiple Job Search Strategies
Apply on company websites, job boards (LinkedIn, Indeed, Glassdoor), and recruitment agencies.
Reach out to hiring managers directly via LinkedIn or email.
Consider internships, freelance work, or contract jobs to gain experience.
4. Prepare for Interviews
Research the company and role thoroughly.
Practice common interview questions and prepare examples of your achievements.
Dress professionally and arrive early.
Follow up with a thank-you email after the interview.
5. Upskill & Stay Competitive
Take online courses or certifications relevant to your field.
Stay updated on industry trends.
Work on side projects or volunteer work to showcase your skills.
6. Stay Organized & Persistent
Track applications and follow up if you don’t hear back in a reasonable time.
Rejection is part of the process—keep applying and improving.
Set daily/weekly goals for job applications and networking.
Would you like help with a specific job search situation?
I was interviewed in Jan 2025.
Numerical reasoning : Tests mathematical skills,such as number sequences,percentages,and ratios.
(6 Questions)
- Q1. What is the difference between static and dynamic typing in python?
- Q2. What is the difference between list and touple in python?
- Q3. Data structures and algorithms
- Q4. Object oriented programming
- Q5. File handling and database
- Q6. Advanced python topics
Gd Topics:
1.Current affairs
2.Business and Economy
3.Social and Cultural
(6 Questions)
- Q1. CN you tell me about your self?
- Q2. Why do you want to work as a python developer?
- Q3. Career goals and motivation
- Q4. Team work and communication
- Q5. Problem solving and adaptability
- Q6. Behavioral questions
Interview Preparation Tips
2.practice interview skills
3.Follow the interview tips
Selected
I applied via campus placement at National Institute of Technology (NIT), Kurukshetra and was interviewed in Dec 2024. There were 2 interview rounds.
(6 Questions)
- Q1. Introduce yourself
- Q2. How will you handle disputes in the team?
- Q3. Explain your projects
- Q4. Why you want to work as Manager although your degree is in Electrical Engineering
- Q5. Which operation do you think are costly in the Delhivery Last mile, First mile, Middle , Transportation etc ?
- Q6. What you have managed in College?
(6 Questions)
- Q1. Introduce yourself
- Q2. Explain your projects
- Q3. Why you want to join Delhivery as a Manager although you are from Electrical Engineering department?
- Q4. How will you unload vehicles? What factors will you consider while unloading?
- Q5. Suppose you are managing a team of 20 people and 10 are absent what actions will you take ?
- Q6. Any Questions you want to ask
Interview Preparation Tips
- Management
- Supply chain management
- Situation based questions
- Logistics Management
- Warehouse Management
Explain situation based questions strategically with logics.
Prepare for Supply chain management and logistics basics they might ask.
Be confident and pray to God.
Selected
(4 Questions)
- Q1. Good communication with our team and my colleagues
- Q2. Need improve my skills and strictly fallow up our EHS values
- Q3. Target is more important in your life, keep doing work unless get your unreachable targets.
- Q4. Good behaviour build your team and save ethics.
Interview Preparation Tips
Qa Automation Testing Engineer Interview Questions & Answers
Nagarro
Anonymous
posted on 30 Jan 2025
I was interviewed in Dec 2024.
Basic quant and reasoning questions
Selenium MCQ
Java programs with MCQ
(23 Questions)
- Q1. Tell me about yourself
- Q2. Where you initialise driver
- Ans.
The driver is typically initialized in the setup method of a test automation framework.
Driver initialization is usually done in a setup method before test execution.
Commonly used methods for driver initialization include WebDriverManager, System.setProperty, and driver instantiation.
Example: WebDriverManager.chromedriver().setup();
- Q3. Driver is static or non static
- Ans.
Driver can be both static and non-static depending on the context of its usage.
Driver class can be static if it is used to initiate the WebDriver instance in a test automation framework.
Driver class can be non-static if it is used as an instance variable within a test class.
Static driver can be accessed directly without creating an object of the class.
Non-static driver requires an object of the class to be created befo
- Q4. Difference between static and non static
- Ans.
Static variables belong to the class itself, while non-static variables belong to instances of the class.
Static variables are shared among all instances of a class
Non-static variables are unique to each instance of a class
Static variables are initialized only once, at the start of the program
Non-static variables are initialized separately for each instance of the class
- Q5. Disadvantages of static and non static
- Ans.
Static and non-static have their own disadvantages in QA automation testing.
Static methods cannot be overridden or inherited, making it difficult to create flexible test cases.
Non-static methods require an instance of the class to be created, which can lead to increased memory usage.
Static methods can lead to tight coupling between classes, making it harder to maintain and update the code.
Non-static methods may have de...
- Q6. Parallel execution in TestNG
- Ans.
TestNG allows parallel execution of test cases to save time and improve efficiency.
TestNG provides the 'parallel' attribute in the testng.xml file to specify the level of parallelism for test execution.
Parallel execution can be achieved at the test level, class level, method level, or suite level.
TestNG also supports parallel execution of tests across multiple classes or suites using the 'parallel' attribute in the sui...
- Q7. Write the code for Parallel testing in TestNG
- Ans.
Parallel testing in TestNG allows running tests concurrently for faster execution.
Use 'parallel' attribute in testng.xml file to specify parallel execution mode.
Set 'parallel' attribute to 'methods', 'classes', or 'tests' based on the level of parallelism needed.
Example: <suite name='MySuite' parallel='tests'>
Use 'thread-count' attribute to specify the number of threads to use for parallel execution.
- Q8. Difference between parallel methods and parallel tests
- Ans.
Parallel methods run multiple methods concurrently within a single test, while parallel tests run multiple tests concurrently.
Parallel methods execute multiple methods within a single test class concurrently.
Parallel tests execute multiple test classes concurrently.
Parallel methods are useful for speeding up the execution of a single test, while parallel tests are useful for running multiple tests faster.
Example: Runni...
- Q9. Upload file using rest assured
- Ans.
Use Rest Assured to upload a file
Use the given file path to create a File object
Use MultiPartSpecBuilder to build the request with the file
Send the request using Rest Assured's given(), when(), and post() methods
- Q10. Postman basic questions
- Q11. Parameter for post method in postman
- Ans.
The parameter for a POST method in Postman is typically sent in the request body.
Parameters are sent in the request body in key-value pairs
Parameters can be sent as form-data, x-www-form-urlencoded, or raw JSON
Example: {"key": "value"}
- Q12. BDD Framework cucumber
- Q13. Cucumber execution process
- Q14. How cucumber know step defination file placed
- Ans.
Cucumber knows the step definition file based on the annotations provided in the feature files.
Cucumber uses annotations like @Given, @When, @Then to map steps in feature files to corresponding step definition methods.
Step definition files are typically placed in a separate package or directory within the project structure.
Cucumber scans the project directory for step definition files based on the package structure and
- Q15. Parameters used in cucumber
- Ans.
Parameters used in cucumber are used to pass values to the step definitions in feature files.
Parameters are defined in feature files using < > syntax
Parameters can be passed to step definitions using Regular Expressions
Parameters can be used to make scenarios more reusable and dynamic
- Q16. Datatable in cucumber
- Ans.
Datatable in Cucumber is used to pass multiple sets of data to a step definition in a scenario.
Datatables are defined using pipes (|) to separate values
Each row in the datatable represents a set of data passed to the step definition
Datatables can be used for parameterization and data-driven testing
- Q17. Have u created the testplan document when porject was started
- Ans.
Yes, I have created the test plan document at the start of the project.
Yes, I always create a test plan document at the beginning of a project to outline the testing approach and strategy.
The test plan document includes details on scope, objectives, resources, schedule, and test cases.
It helps in ensuring that all stakeholders are aligned on the testing process and expectations.
For example, in my previous project, I cr...
- Q18. Testing cycle when project was on initial level
- Ans.
During the initial testing cycle of a project, focus is on establishing test cases, setting up test environments, and identifying potential issues.
Creating test cases based on requirements
Setting up test environments
Identifying potential issues and risks
Executing test cases and reporting defects
Collaborating with developers to resolve issues
- Q19. Risk management and risk based testing
- Q20. Which estimate technique you follow , if fibonacci then why it is in 1 2 3 5 8 13 ?? Not in 12345678
- Ans.
Fibonacci sequence is a mathematical pattern where each number is the sum of the two preceding ones.
Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones.
The sequence starts with 1, 2, then each subsequent number is the sum of the two previous numbers (1+2=3, 2+3=5, 3+5=8, and so on).
This sequence is used in estimating because it reflects natural growth patterns found in natur
- Q21. What is testing matrix and automation ROI
- Ans.
Testing matrix is a tool used to track test coverage and automation ROI is the return on investment from implementing automation testing.
Testing matrix is a visual representation of test cases, test scenarios, and their coverage across different platforms, browsers, devices, etc.
Automation ROI is the measure of the benefits gained from automation testing compared to the costs incurred in implementing and maintaining th...
- Q22. Cicd tool
- Q23. Handle team ?
Selected
Bachelor of Commerce degree with a GPA of 6.79 and an accompanying resume.
(5 Questions)
- Q1. Location send Hyderabad komplly
- Q2. Hardwark honest project
- Q3. First introducedy
- Q4. Salarypackge and times
- Q5. Respect to office staff
Interview Preparation Tips
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Analyst Interview Questions
- Design Engineer Interview Questions
- Software Developer Interview Questions
- Senior Engineer Interview Questions
- Sales Executive Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Nanubhai Education Foundation Reviews and Ratings
based on 1 review
Rating in categories
TCS
Capgemini
HCLTech
BYJU'S
- Home >
- Interviews >
- Nanubhai Education Foundation Interview Questions
