PwC Associate Interview Questions, Process, and Tips

45 MCQ for 45 mins ...basic questions aptitude, output and basic computer skills

Q1. Based on resume
Add your answer

Q1. Again based on resume and project
Add your answer

A common topic for everyone...we have to say something about the same

Q1. Tell me about yourself
Add your answer

Q1. Caro 2020 schedule 3 ind as 12 15 19 gstr9 9c amendments mat gst amendments
Add your answer

Q1. Director round -resume related questions, Caro 2020
Add your answer

Q1. Questions related to MVC
Add your answer
Q2. Basic coding questions
Add your answer

Q1. Project related questions
Add your answer
Q2. Certification related questions
Add your answer

Q1. Basic salary discussion
Add your answer

It was conducted on Glider
There were 5 sections in total.
Quants-there were 15 questions
Verbal=5 questions
Conceptual CS-20
Programming skills -1
Generic-5

Q1. Write code to check if two strings are anagram or not.
Ans. 
Code to check if two strings are anagram or not.
• Convert both strings to lowercase to avoid case sensitivity

• Sort both strings and compare them

• Use a hash table to count the frequency of each character in both strings and compare the hash tables
Answered by AI
View 1 more answer

It was conducted on Google Meet.
The interview started with an introduction. Then he asked me to share my screen, and gave me some dbms and coding questions.

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 a database into smaller, more manageable tables.

• Each table should have a primary key and only contain data that is related to that key.

• Normalization helps to prevent data inconsistencies and anomalies.

• There are different levels of normalization, with each level building on t...read more
Answered by AI
Add your answer
Q2. Create a table with specified columns Alter the table and add new columns Create another table with help of existing tables Write a query which uses group by clause Write a query which uses having clau...read more
Ans. 
Answering SQL related questions on table creation, alteration, and querying with group by and having clauses.
• To create a table with specified columns, use the CREATE TABLE statement with column names and data types.

• To alter a table and add new columns, use the ALTER TABLE statement with ADD COLUMN keyword.

• To create another table with help of existing tables, use the CREATE TABLE statement with SELECT statement.

• To write...read more
Answered by AI
View 1 more answer
Q3. Difference between where and having clause Types of joins, explain with examples Combine two tables and write the output
Ans. 
Explaining the difference between WHERE and HAVING clause and types of joins with examples.
• WHERE clause is used to filter rows based on a condition while HAVING clause is used to filter groups based on a condition

• INNER JOIN returns only the matching rows from both tables while LEFT JOIN returns all rows from the left table and matching rows from the right table

• Combining two tables can be done using JOIN clause with a c...read more
Answered by AI
Add your answer
Q4. What is your preferred programming language?
Ans. 
My preferred programming language is Python.
• Python is easy to learn and has a simple syntax.

• It has a vast library of modules and frameworks for various purposes.

• Python is widely used in data science and machine learning.

• It is also great for web development and automation tasks.

• Examples: Flask, Django, NumPy, Pandas, TensorFlow.
Answered by AI
Add your answer
Q5. Write a code to print the second largest element in array.
Ans. 
Code to print the second largest element in array
• Sort the array in descending order and return the second element

• Iterate through the array and keep track of the largest and second largest elements

• Use a priority queue to find the second largest element
Answered by AI
Add your answer
Q6. Tell me about the collections in java. 4Write the code which uses collection ( to print the elements in reverse order

Ans. 

Java collections are a group of classes and interfaces used to store and manipulate groups of objects.

• To print elements in reverse order, use the Collections.reverse() method.

• This method takes a List as an argument and reverses the order of its elements.

• Example: List names = new ArrayList<>(); Collections.reverse(names);

• Other commonly used collections in Java include Set, Map, Queue, and Stack.

Add your answer