ZS Business Technology Associate Interview Questions, Process, and Tips

Quantitative, logical reasoning, data interpretation, verbal ability

Q1. Grammar check question
Add your answer
Q2. Speaking n comunication
Add your answer

Q1. How to copy a table in sql
Ans. 
To copy a table in SQL, you can use the CREATE TABLE AS SELECT statement.
• Use the CREATE TABLE AS SELECT statement to copy the structure and data of a table.

• Specify the new table name after CREATE TABLE and the existing table name after SELECT.

• Example: CREATE TABLE new_table AS SELECT * FROM existing_table;
Answered by AI
Add your answer
Q2. How to copy only contents of table in sql
Ans. 
Use SELECT INTO statement to copy contents of a table in SQL.
• Use SELECT INTO statement to copy contents of a table into a new table.

• Specify the columns you want to copy in the SELECT statement.

• Ensure the new table has the same structure as the original table.
Answered by AI
Add your answer

Reasoning ,English,Guessttimates

Q1. Puzzles related to maths
Add your answer
Q2. Why wanna join consulting
Add your answer

Q1. Joins SQL detail
Ans. 
Joins in SQL are used 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

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Project in derail
Ans. 
When a project is in derail, it means it is off track and not progressing as planned.
• Identify the root cause of the derailment

• Reassess project goals and timeline

• Implement corrective actions to get the project back on track

• Communicate with stakeholders about the situation and the plan moving forward
Answered by AI
Add your answer

Basic aptitude LR DI quant and speaking skills

Q1. SQL MCQs 15 - 20 were there
Add your answer
Q2. SQL query writing questions were there i guess 2 3 and 1 coding question in python
Add your answer

Q1. SQL query writing question was there
Add your answer
Q2. Guesstimate- estimate the number of urinals in ZS office
Ans. 
I would estimate there are around 20 urinals in the ZS office.
• Consider the size of the office building and the typical ratio of urinals to toilets in commercial spaces.

• Take into account the number of employees and visitors who would use the restroom facilities.

• If possible, try to gather information on the floor plan or layout of the office to make a more accurate estimate.
Answered by AI
Add your answer