Filter interviews by
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 ...
Earthquakes occur due to the movement of tectonic plates. Metamorphosis is the process of transformation in living organisms.
Earthquakes occur when two tectonic plates move against each other, causing a release of energy in the form of seismic waves.
Metamorphosis is a process of transformation in living organisms, where an organism undergoes a physical change in form and structure.
Examples of metamorphosis include...
The Industrial Revolution was a period of rapid industrial growth and technological innovation from the late 18th to early 19th century.
Began in Britain in the late 1700s, marked by the transition from hand production to machines.
Key inventions included the steam engine, spinning jenny, and power loom.
Led to the rise of factories, urbanization, and changes in labor systems.
Significantly impacted transportation wit...
ESG stands for Environmental, Social, and Governance criteria used to evaluate a company's sustainability and ethical impact.
ESG criteria are used by investors to assess the sustainability and ethical impact of a company.
Environmental criteria focus on a company's impact on the environment, such as carbon emissions and resource usage.
Social criteria evaluate a company's relationships with employees, customers, sup...
What people are saying about PwC
Backend tables of frameworks store data related to the application's functionality.
Backend tables in frameworks like Django, Ruby on Rails, and Laravel store data such as user information, posts, comments, etc.
These tables are designed based on the application's requirements and relationships between different entities.
Developers can interact with these tables using ORM (Object-Relational Mapping) tools to perform...
Professional skepticism is a critical mindset used in audit to question information and evidence.
Professional skepticism involves questioning the reliability of information provided by clients.
Auditors must remain independent and objective in their assessments.
Examples of professional skepticism include verifying financial data with third-party sources and challenging management's assumptions.
Auditors should not a...
Fly ash is a byproduct of coal combustion and is often used as a supplementary cementitious material in concrete.
Fly ash is a fine powder that is produced when coal is burned in power plants.
It can be used as a partial replacement for Portland cement in concrete to improve workability, durability, and strength.
The amount of fly ash in cement is typically limited to around 15-35% by weight of the total cementitious...
Identification of risk involves a systematic process of identifying potential threats and assessing their likelihood and impact.
Identify potential risks through brainstorming, historical data analysis, and expert opinions
Assess the likelihood and impact of each identified risk
Prioritize risks based on their potential impact and likelihood
Develop strategies to mitigate or manage identified risks
Regularly review and...
Problems faced during articleship
Long working hours
Lack of guidance from seniors
Low stipend
Unfair treatment by employers
Difficulty in balancing work and studies
Ind AS 115 and Ind AS 116 are accounting standards used for revenue recognition and lease accounting respectively.
Ind AS 115: It provides guidance on how to recognize revenue from contracts with customers.
Ind AS 116: It outlines the principles for recognizing, measuring, presenting, and disclosing leases.
Both standards are part of the Indian Accounting Standards (Ind AS) framework.
Ind AS 115 replaces the previous ...
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
Program to find character occurances in 'Hello World'
Create a map to store character occurrences
Iterate through each character in the string and update the map
Print the character occurrences from the map
Multithreading is the ability of a CPU to execute multiple threads concurrently, allowing for better performance and resource utilization.
Multithreading allows multiple threads to run concurrently within the same process.
Each thread has its own stack and shares the same memory space.
Multithreading can improve performance by utilizing multiple CPU cores efficiently.
Examples of multithreading include running multiple tas...
TestNG annotations are used to control the flow of test methods and provide additional information about the test.
Annotations like @Test, @BeforeSuite, @AfterSuite are used to define test methods and setup/teardown methods
Annotations like @BeforeTest, @AfterTest are used to run setup/teardown methods before/after a test
Annotations like @BeforeClass, @AfterClass are used to run setup/teardown methods before/after a test...
I appeared for an interview in Jan 2025.
I have worked on projects involving natural language processing, computer vision, and recommendation systems.
Developed a sentiment analysis model using NLP techniques
Implemented a facial recognition system using computer vision algorithms
Built a recommendation engine based on collaborative filtering
I appeared for an interview in Nov 2024.
No, the main method in Java cannot be overloaded.
The main method in Java is the entry point of a program and must have a specific signature: public static void main(String[] args).
Attempting to overload the main method by changing the number or type of parameters will result in a compilation error.
Instead of overloading the main method, you can create additional methods in the same class to perform different tasks.
60 min , Logical , Analytical, Reasoning, Data Interpretation and English
I have completed two internships in marketing and finance, gaining valuable hands-on experience.
Completed internships in marketing and finance
Gained hands-on experience in both fields
Learned about market research and financial analysis
I value PwC's commitment to integrity, diversity, and professional growth, which align with my career aspirations.
PwC's strong emphasis on integrity and ethical practices resonates with my personal values.
The diverse and inclusive culture at PwC fosters collaboration and innovation, allowing for varied perspectives.
Opportunities for continuous learning and professional development, such as mentorship programs, are high...
I am quite flexible with office locations, as I prioritize collaboration and productivity over a specific geographic area.
I am open to relocating if necessary, as I believe in adapting to the team's needs.
I have experience working remotely and can maintain productivity from various locations.
I understand the importance of being present for team meetings and client interactions, so I can adjust my location accordingly.
F...
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.
Queue is a data structure that follows First In First Out (FIFO) principle, while stack follows Last In First Out (LIFO) principle.
Queue: elements are added at the rear and removed from the front.
Stack: elements are added and removed from the top.
Example: In a queue, people waiting in line at a ticket counter are served in the order they arrived. In a stack, plates in a stack are removed from the top.
Multithreading is the ability of a CPU to execute multiple threads concurrently, allowing for improved performance and responsiveness.
Multithreading allows for parallel execution of multiple tasks within a single process.
Each thread has its own stack and program counter, but shares the same memory space.
Examples of multithreading include web servers handling multiple requests simultaneously and video games rendering gr...
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Use a stored procedure to prompt user for input in ETL process.
Create a stored procedure with parameters to accept user input.
Use the parameters in the stored procedure to filter or manipulate data.
Prompt the user for input values when calling the stored procedure.
Use TRY...CATCH block in SQL to handle errors in Stored Procedures
Enclose the code inside a TRY block
Use a CATCH block to handle any errors that occur
Use RAISEERROR or THROW statement to raise custom error messages
Use @@ERROR or @@ROWCOUNT to check for errors or affected rows
I appeared for an interview in Oct 2024.
Inactive relationships in Power BI allow for multiple relationships between tables, enabling complex data modeling without conflicts.
Multiple Relationships: Inactive relationships enable the creation of multiple relationships between two tables, which can be useful for different analysis scenarios.
Filtering Context: Inactive relationships can be activated in DAX formulas using the USERELATIONSHIP function, allowing for...
Power BI service roles define user permissions and capabilities for data access, report sharing, and collaboration within the platform.
Admin: Manages the Power BI environment, including user permissions, workspaces, and overall governance.
Member: Collaborates on content creation and can edit reports and dashboards within shared workspaces.
Contributor: Can create and publish content but has limited permissions compared ...
The duration of PwC interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 93 interview experiences
Difficulty level
Duration
based on 10.5k reviews
Rating in categories
Hyderabad / Secunderabad,
Bangalore / Bengaluru
5-9 Yrs
₹ 5-38.4 LPA
Senior Associate
18.8k
salaries
| ₹12.6 L/yr - ₹25 L/yr |
Associate
15.1k
salaries
| ₹8 L/yr - ₹14 L/yr |
Manager
7.5k
salaries
| ₹22.1 L/yr - ₹40 L/yr |
Senior Consultant
4.9k
salaries
| ₹15.9 L/yr - ₹26.2 L/yr |
Associate2
4.7k
salaries
| ₹6.2 L/yr - ₹14 L/yr |
Deloitte
Ernst & Young
Accenture
TCS