Physicswallah Interview Questions, Process, and Tips for Experienced

Your vhoice from group discussion

Q1. Real life based
Add your answer
Q2. IQ based any questions
Add your answer
Q3. Life Science based any questions
Add your answer
Q4. Your choice based
Add your answer
Q5. Creativitybased
Add your answer

Q1. Tell me about yourself
Ans. 
I am a highly motivated individual with a background in event planning and customer engagement.
• Background in event planning

• Strong communication skills

• Experience in customer engagement

• Passionate about creating memorable experiences for clients
Answered by AI
Add your answer

Q1. What is important while connecting with stakeholders
Ans. 
Building trust, communication, understanding needs, and maintaining relationships are important while connecting with stakeholders.
• Building trust is crucial for establishing a strong relationship with stakeholders.

• Effective communication helps in understanding their needs and expectations.

• Showing empathy and understanding their perspective can lead to better collaboration.

• Maintaining regular contact and providing updat...read more
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Basics of SQL and intermediate knowledge of SQL
Add your answer
Q3. What is Row level security?
Ans. 
Row level security is a feature that restricts access to specific rows in a database based on the user's permissions.
• Row level security limits access to certain rows of data based on the user's role or permissions.

• It helps organizations ensure that sensitive data is only accessible to authorized users.

• For example, a healthcare organization may use row level security to restrict access to patient medical records based o...read more
Answered by AI
Add your answer
Q4. How will you share the power BI reports
Ans. 
I will share Power BI reports through email, shared folders, and scheduled data refreshes.
• Share reports via email with stakeholders

• Store reports in shared folders for easy access

• Schedule data refreshes to ensure reports are up-to-date
Answered by AI
Add your answer
Q5. Difference between calculated colums & calculated measures ?
Ans. 
Calculated columns are calculated at the row level, while calculated measures are aggregated over a set of rows.
• Calculated columns are created at the individual row level in a table, using DAX formulas in Power BI or Excel.

• Calculated measures are created at the aggregate level, such as sum or average, and are used in measures like totals or averages in a pivot table.

• Calculated columns are stored in the data model, whil...read more
Answered by AI
Add your answer
Q6. How will you read files in Python ?
Ans. 
Files in Python can be read using the open() function to open the file and read() function to read the contents.
• Use the open() function to open a file in read mode: file = open('filename.txt', 'r')

• Use the read() function to read the contents of the file: content = file.read()

• Close the file after reading: file.close()
Answered by AI
Add your answer
Q7. What is standard deviations?
Ans. 
Standard deviation is a measure of the amount of variation or dispersion of a set of values.
• Standard deviation is calculated as the square root of the variance.

• It indicates how spread out the values in a data set are around the mean.

• A higher standard deviation means more variability in the data.

• A lower standard deviation means values are closer to the mean.

• For example, in a data set of test scores, a high standard devi...read more
Answered by AI
Add your answer

Q1. What do you know about Excel and what are the best features of excel.
Ans. 
Excel is a powerful spreadsheet software used for data analysis, reporting, and visualization.
• Excel allows users to organize data in rows and columns, perform calculations, and create charts and graphs.

• Features like pivot tables, conditional formatting, and data validation make it easier to analyze and present data.

• Excel also supports automation through macros and functions like VLOOKUP and SUMIF.

• It is widely used in b...read more
Answered by AI
Add your answer
Q2. What are window function.
Ans. 
Window functions are a type of function in SQL that perform calculations across a set of table rows that are related to the current row.
• Window functions are used to perform calculations on a specific subset of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().
Answered by AI
Add your answer
Q3. What is CTE query
Ans. 
CTE query stands for Common Table Expression query, used in SQL to create temporary result sets.
• CTE query is used to simplify complex SQL queries by breaking them into smaller, more manageable parts.

• It allows for recursive queries, which can be useful for tasks like hierarchical data retrieval.

• CTE queries are defined using the WITH keyword followed by the query name and definition.

• They can be referenced multiple times ...read more
Answered by AI
Add your answer
Q4. How will you join two tables. And asked practical questions in which joining the two tables and also returning the value as running total of fees paid by students.
Add your answer
Q5. One table has 5 other have 7 columns How many column will be there in Left Join, Inner join and union
Ans. 
Left Join will have 12 columns, Inner Join will have 7 columns, Union will have 7 columns.
• Left Join combines all columns from both tables, resulting in 12 columns.

• Inner Join only includes columns that are common between the tables, resulting in 7 columns.

• Union combines the results of two or more SELECT statements, keeping the same number of columns as the original tables (7 columns).
Answered by AI
Add your answer

Q1. About work experience
Add your answer
Q2. About salary discussion
Add your answer

Q1. Ram speed, CMOS battery voltage, NVR/dvr, network topology
Add your answer
Q2. Switch,bios,ram type, network class
Add your answer

Q1. Basic 12 th level science maths and English
Add your answer
Q2. Mathematics interview
Add your answer