National Statistical Office Interview Questions and Answers

Q1. Can you provide information about yourself and the projects you have worked on?
Add your answer
Q2. What is the Re-Framework, and how do the Dispatcher, Performer, and DataTable transaction approaches function in UiPath?
Add your answer
Q3. What is the difference between an execute query and an execute non-query?
Add your answer
Q4. What is the difference between a switch statement and an if-else statement?
Add your answer
Q5. Datatable how to use it in Uipath, what is a connection string and how we can create that?
Add your answer

The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your internship experience?
Add your answer
Q3. Given a puzzle to solve
Add your answer
Q4. What can you tell me about your major projects?
Add your answer
Q5. What is the latest news you have heard regarding technology?
Ans. 
The latest news I heard regarding technology is the release of the new iPhone 13 with improved camera features.
• Apple recently announced the release of the iPhone 13 series with upgraded camera capabilities.

• The new iPhone 13 models come with improved low-light performance and cinematic mode for videos.

• Apple also introduced the A15 Bionic chip for enhanced performance and battery life.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Expected CTC
Add your answer
Q3. Why you left your previous company (Negative answers should be avoided)
Add your answer

Q1. Questions based on the concepts of payroll
Add your answer
Q2. Expected CTC
Add your answer
Q3. Discussion regards to Shift timings, Cab facility, Annual leaves, Variable bonus, Relocate bonus.
Add your answer

Q1. Regards to Payroll questions on what I did on daily basis.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What is the product conference customer
Add your answer
Q3. What is the time management
Add your answer
Q4. What is the customer dealing
Add your answer
Q5. What is the product and service the opportunity this customer
Add your answer

Q1. Give work freedom to employee
Add your answer
Q2. No need to search each and every transactions
Add your answer

Q1. Trust on employee
Add your answer
Q2. Maintain minimum job curtsy
Add your answer

Q1. Salary hike and position hike is Mandatory
Add your answer
Q2. Collect exact feedback from employee
Add your answer

An aptitude test evaluates an individual's potential to excel in a specific area by assessing their strengths and weaknesses in particular abilities.

An assessment that measures an individual's inherent abilities and potential for success in a specific activity.

A coding test is a programming assessment designed to evaluate a candidate's coding skills. It is a standard component of the technical hiring process for software developers and programmers.

Assessment that evaluates a candidate's coding skills

Group discussion (GD) topics for interviews may cover areas such as business, social issues, and current affairs. GDs serve to evaluate a candidate's communication, leadership, and teamwork abilities.

Discussion assignments are prompts that your teacher may assign to you. By participating in these discussions, you can reflect on your learning, share ideas and opinions, or ask and answer questions. Discussions may require you to respond to individual questions or provide multiple responses to an ongoing conversation.

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.

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
Add your answer
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.
Answered by AI
Add your answer
Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
Add your answer
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
Answered by AI
Add your answer
Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
Add your answer
Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer

Q1. Current CTC, Expected CTC, Notice Period, Skill set
Add your answer
Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Ans. 
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
• Open for fixed term hire

• Willing to work from client location at Gurgaon for 3 days a week
Answered by AI
Add your answer

Q1. Introduction, Current role and responsibilities
Add your answer
Q2. List out the achievements in current project, Tools used
Ans. 
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
• Implemented automated testing framework using Selenium WebDriver

• Utilized JUnit for test case management

• Worked in Agile environment to ensure continuous testing and integration
Answered by AI
Add your answer
Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
Ans. 
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
• Pilot testing involves a small group of users testing the functionality in a controlled environment.

• Beta testing involves a larger group of users testing the functionality in a real-world environment.

• ...read more
Answered by AI
Add your answer
Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
Ans. 
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
• Primary key enforces uniqueness and not null constraint on a column

• Unique key enforces uniqueness but allows null values

• To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
Answered by AI
Add your answer
Q5. Explain Software Testing Life Cycle, Defect Life Cycle
Ans. 
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
• STLC includes requirements analysis, test planning, test design, test execution, and test closure.

• Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.

• STLC ensures that the so...read more
Answered by AI
Add your answer
Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
Ans. 
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
• 303 status code indicates that the resource can be found at a different URI and should be retrieved from there

• PUT method is used to update an existing resource in the API

• DELETE method is used to remove a resource from the API

• 3 point esti...read more
Answered by AI
Add your answer
Q7. What kind of links and labels can be tagged to a bug in jira?
Ans. 
Links and labels that can be tagged to a bug in Jira
• Links: related issues, documents, websites

• Labels: priority, severity, type, status
Answered by AI
Add your answer
Q8. Have you done shell scripting? What does grep, href commands do in unix?
Ans. 
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
• Shell scripting automates tasks by writing scripts in a Unix/Linux environment

• Grep command is used to search for specific patterns in text files

• Example: grep 'search_pattern' file.txt

• Href is not a standard Unix command, it may be a typo or a custom script
Answered by AI
Add your answer
Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
Ans. 
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
• Listen to the team member's perspective and concerns

• Communicate openly and calmly about the issue

• Find common ground and areas of agreement

• Work together to find a solution that benefits both parties

• Seek input from other team members or a mediator if ne
Answered by AI
Add your answer
Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...read more
Ans. 
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
• Yes, open to relocating to Bangalore and working from client's office

• Yes, open to working in night/rotational shifts

• Yes, open to working in long extendable hours or 24X7 culture

• Goal is to excel in automation testing
Answered by AI
Add your answer