VMLY&R Commerce Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a recent graduate with a degree in Computer Science and a passion for coding and problem-solving.
• Recent graduate with a degree in Computer Science

• Passionate about coding and problem-solving

• Experience with programming languages such as Java, Python, and C++

• Completed internships at tech companies like Google and Microsoft
Answered by AI
Add your answer
Q2. Tell me about your education baground
Ans. 
I have a Bachelor's degree in Computer Science with a focus on software development.
• Bachelor's degree in Computer Science

• Focus on software development

• Completed relevant coursework in algorithms, data structures, and programming languages
Answered by AI
Add your answer
Q3. What programming languages are you good at
Ans. 
I am proficient in Java, Python, and SQL.
• Java

• Python

• SQL
Answered by AI
Add your answer

It is all about reasoning.

GD is all about how to build Business Strategy in short term

Q1. Introduce Your self
Add your answer
Q2. Where do you see after 5 years
Add your answer
Q3. Salary expectation
Add your answer
Q4. Rate yourself within 10
Add your answer
Q5. Why are you join this institute
Add your answer

Q1. Are you planning pregnancy?
Ans. 
It is not appropriate to ask about pregnancy in a job interview as it is a personal matter.
• Politely redirect the conversation back to your qualifications and experience

• Explain that personal matters such as family planning are not relevant to the job

• Express that you are focused on your career and committed to your work
Answered by AI
Add your answer
Q2. Are you comfortable working late nights?
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. Tell me about yourself
Add your answer
Q2. What recently happened and it's advantage and disadvantage
Ans. 
The company recently implemented a new accounting software system.
• Advantage: Increased efficiency in processing transactions and generating reports.

• Advantage: Improved accuracy in financial data recording and analysis.

• Disadvantage: Initial learning curve for employees to adapt to the new system.

• Disadvantage: Potential downtime during system implementation and data migration.
Answered by AI
Add your answer
Q3. Co-education or separate education which is better and each pros and cons
Ans. 
Co-education allows for better socialization and understanding between genders, but separate education can provide a more focused learning environment.
• Co-education promotes gender equality and helps in breaking stereotypes.

• Separate education can lead to less distractions and better academic performance in some cases.

• Co-education can help in developing communication and teamwork skills.

• Separate education may cater to sp...read more
Answered by AI
Add your answer

Q1. What is macro & types
Ans. 
Macros are automated tasks that can be created in software applications to perform repetitive tasks. Types include keyboard macros, spreadsheet macros, and programming macros.
• Macros are automated tasks that can be created in software applications to perform repetitive tasks.

• Types of macros include keyboard macros, spreadsheet macros, and programming macros.

• Keyboard macros are shortcuts that automate a series of keystro...read more
Answered by AI
Add your answer
Q2. Bulk import and export can you do ?
Ans. 
Yes, I have experience in bulk import and export of data using tools like Excel, CSV, and database management systems.
• Proficient in using Excel for bulk import and export of data

• Experience with CSV files for transferring large amounts of data

• Knowledge of database management systems for efficient import and export processes
Answered by AI
Add your answer
Q3. Creative types in DCM
Ans. 
Creative types in DCM refer to individuals who think outside the box and come up with innovative solutions for digital campaign management.
• Creative types in DCM often have a background in design, marketing, or advertising.

• They are skilled at creating visually appealing and engaging content for digital platforms.

• Examples include graphic designers, content creators, and social media managers.
Answered by AI
Add your answer

String Array manipulation

Q1. Different activity launch modes, services, intent-services
Ans. 
Different launch modes control how activities are launched, services run in the background, and intent-services handle asynchronous tasks.
• Launch modes include standard, singleTop, singleTask, and singleInstance

• Services are used for long-running operations in the background

• Intent-services are used for handling asynchronous tasks on a separate worker thread
Answered by AI
Add your answer
Q2. Normal android sdk related questions and about third party libraries
Add your answer

Q1. Interview with India Director
Add your answer

Q1. Let me know about yourself
Add your answer
Q2. Normal queries about you
Add your answer

Q1. Excel questions
Add your answer

Q1. Personality questions
Add your answer

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer