Swews Interview Questions and Answers

Q1. Find length of longest substring, without repeating charecters
Add your answer
Q2. Implement a custom method for Memoization
Add your answer
Q3. What is this keyword, and follow up questions were asked on this
Add your answer
Q4. Deep copy and shallow copy
Add your answer

The test was easy, containing data interpretation questions

Q1. Case study to evaluate my approach
Add your answer
Q2. Guesstimate to evaluate my approach
Ans. 
To evaluate your approach, I would estimate the number of cars passing through a busy intersection in a day.
• Identify the average number of cars passing through the intersection per minute

• Calculate the total number of minutes in a day

• Multiply the average cars per minute by total minutes in a day to get an estimate
Answered by AI
Add your answer

Q1. What is the importance of Microsoft Word, Microsoft Office, and Microsoft PowerPoint in your work?
Ans. 
Microsoft Word, Microsoft Office, and Microsoft PowerPoint are essential tools for creating, editing, and presenting documents and presentations.
• Microsoft Word is used for creating and editing text documents, such as reports, letters, and memos.

• Microsoft Office includes Word, Excel, and PowerPoint, providing a suite of tools for various tasks like data entry, analysis, and presentation.

• Microsoft PowerPoint is used for ...read more
Answered by AI
Add your answer
Q2. You know about the computer knowledge and typing also very important okay and also good environment and good positive and responsible and from more more and more etc and make them very important knowledg...read more
Add your answer

Q1. Second highest Salary
Ans. 
To find the second highest salary in a database table, you can use a SQL query with the ORDER BY and LIMIT clauses.
• Use a SQL query with ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to retrieve the second highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;
Answered by AI
Add your answer
Q2. Left and right join explanation
Ans. 
Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table.
• Left join: Returns all records from the left table and the matched records from the right table.

• Right join: Returns all records from the right table and the matched records from the left table.

• Example: Left join - SELECT * FROM table1...read more
Answered by AI
Add your answer

Q1. Question on Binary Search tree
Add your answer
Q2. One easy array question
Add your answer

Q1. Difference between reach and engagement?
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a dedicated and detail-oriented PMO Analyst with a strong background in project management and data analysis.
• I have a Bachelor's degree in Business Administration with a focus on project management.

• I have experience in creating and maintaining project plans, tracking progress, and analyzing data to identify trends and areas for improvement.

• I am proficient in using project management tools such as Microsoft Project...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a seasoned PMO Analyst leading strategic projects and mentoring junior team members.
• Leading strategic projects within the organization

• Mentoring junior team members to help them grow professionally

• Continuing to enhance my skills and knowledge in project management

• Possibly pursuing advanced certifications in project management
Answered by AI
Add your answer

Q1. Powerbi features?
Add your answer
Q2. PM roles and responsibility
Ans. 
PM roles involve planning, organizing, leading, and controlling project activities to achieve project goals.
• Develop project plans and schedules

• Coordinate project resources and stakeholders

• Monitor project progress and report on status

• Manage project risks and issues

• Ensure project deliverables meet quality standards

• Facilitate communication among team members

• Adapt to changes in project scope or requirements
Answered by AI
Add your answer

Q1. What is the Triggers
Ans. 
Triggers are special types of stored procedures that are automatically executed when certain events occur in a database.
• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in a database.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating a related table when a record is
Answered by AI
Add your answer
Q2. What is the Stored Procedures
Ans. 
Stored procedures are precompiled SQL queries stored in a database for reuse.
• Stored procedures are used to perform specific tasks or operations in a database.

• They can improve performance by reducing the amount of data sent between the database and application.

• Stored procedures can be called from within other SQL queries or from application code.

• They can also help with security by controlling access to data and enforcin
Answered by AI
Add your answer

Q1. What is the current CTC?
Ans. 
I am currently earning $60,000 per year.
• My current annual salary is $60,000.

• I am earning $5,000 per month.

• I make $1,250 per week.

• My current CTC is $60,000 per annum.
Answered by AI
Add your answer
Q2. Basic questions related to the current work place
Add your answer

Q1. Different types of attribution models in google ads
Ans. 
Different types of attribution models in Google Ads include last click, first click, linear, time decay, and position-based.
• Last click attribution gives all credit to the last interaction before a conversion.

• First click attribution gives all credit to the first interaction before a conversion.

• Linear attribution gives equal credit to all touchpoints along the conversion path.

• Time decay attribution gives more credit to t...read more
Answered by AI
Add your answer
Q2. Meta ad placements available
Add your answer