Nomura Holdings Senior Analyst Interview Questions and Answers for Experienced

Some easy mcq coding questions

Q1. 1. What is serialization? 2. What is a Singleton class? 3. Difference b/w interface and abstract class. And a few more basic java 8 questions.
Ans. 
Serialization is the process of converting an object into a stream of bytes to store or transmit data.
• Serialization is used to save the state of an object and recreate it when needed.

• In Java, serialization is achieved by implementing the Serializable interface.

• Example: ObjectOutputStream and ObjectInputStream classes are used for serialization in Java.
Answered by AI
Add your answer

Q1. Some basic HR questions like how do you manage pressure at work, Willing to relocate or not, etc.
Add your answer

Q1. About my experience and roles and responsibilities About technology
Add your answer
Q2. About process flow and knowledge
Add your answer

Q1. What is Normalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by eliminating duplicate data

• Normalization improves data integrity by ensuring that each piece of data is stored in only one place

• There are different levels of normalization, such as First Normal F...read more
Answered by AI
Add your answer
Q2. What is sub-Query
Ans. 
A sub-query is a query nested within another query in SQL to retrieve data from multiple tables.
• Used to retrieve data from multiple tables

• Can be used in SELECT, INSERT, UPDATE, or DELETE statements

• Must be enclosed in parentheses
Answered by AI
Add your answer
Q3. What is joins ?explain
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right ta...read more
Answered by AI
Add your answer
Q4. What is Left outer join ?give ex
Ans. 
Left outer join is a type of join operation that returns all records from the left table and the matched records from the right table.
• Left outer join combines rows from two tables based on a related column between them.

• It includes all the rows from the left table, even if there are no matches in the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q5. What is constraint?
Ans. 
A constraint is a rule or limitation that must be followed in a system or process.
• Constraints restrict the actions or behaviors of users or systems.

• Constraints can be related to data validation, business rules, or system limitations.

• Examples of constraints include password length requirements, maximum file size limits, and budget constraints.
Answered by AI
Add your answer

Q1. Previous experience about your profiles
Ans. 
I have worked as a Test Analyst for 3 years in a software development company.
• Conducted functional, regression, and integration testing on various software applications

• Created and executed test cases and reported defects using JIRA

• Collaborated with developers and business analysts to ensure quality of software products

• Participated in Agile ceremonies such as sprint planning, daily stand-ups, and retrospectives
Answered by AI
Add your answer
Q2. Share your exp positively
Ans. 
I have extensive experience in testing various software applications and have consistently delivered high-quality results.
• I have worked on multiple projects and have gained expertise in manual and automation testing.

• I have a strong understanding of testing methodologies and have implemented them effectively.

• I have collaborated with cross-functional teams to identify and resolve issues, ensuring timely delivery of proje...read more
Answered by AI
Add your answer

Basic aptitude and logical reasoning

Q1. 1-Diffeerence between explict wait and implicit wait 2-How to handle stale exceptions 3-XML parsing and Json parsing 4-Maven compile and Mavem install 5-Sql Join questions 6-Requirement.txt in Python 7-sha...read more
Ans. 
Test Analyst interview questions on wait types, parsing, Maven, SQL, Python, and database connectivity and exceptions.
• Explicit wait waits for a specific condition to be met, while implicit wait waits for a certain amount of time before throwing an exception

• Stale exceptions occur when an element is no longer attached to the DOM, can be handled by refreshing the page or finding the element again

• XML parsing involves readi...read more
Answered by AI
Add your answer

Q1. 1-Spring ,agile,Jira,left shift approach
Add your answer