Datta Meghe Institute Of Medical Sciences Stenographer Interview Questions and Answers

Power bi assignment was given to solve

Q1. Optimization techniques in sql
Ans. 
Optimization techniques in SQL involve using indexes, query optimization, and proper database design.
• Use indexes on columns frequently used in WHERE clauses to speed up query performance

• Avoid using SELECT * and instead specify only the columns needed in the query

• Optimize queries by using appropriate join types and conditions

• Normalize database tables to reduce redundancy and improve query efficiency
Answered by AI
Add your answer
Q2. Sub queries in sql
Ans. 
Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.
• Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• They can be used to filter results, retrieve data from multiple tables, or perform calculations.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. Types of Join in sql
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

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

• Full outer join: Returns all rows when there is a match in either table
Answered by AI
Add your answer
Q4. Time intelligence functions in power bi
Ans. 
Time intelligence functions in Power BI are used to analyze and compare data based on time periods.
• Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.

• Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.

• These functions allow for easy comparison of data across different time periods and help in tren
Answered by AI
Add your answer
Q5. Logical questions in aptitude
Add your answer
Q6. Row level security in power bi
Ans. 
Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.
• Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.

• Users can be assigned to specific roles which determine the data they have access to.

• Row level security helps in ensuring data privacy and compliance with regulations.

• For example, ...read more
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. What you have been doing in the current organisation
Add your answer
Q3. Turnover of the company
Ans. 
The turnover of the company refers to the total revenue generated by the company in a specific period of time.
• Turnover can be calculated by multiplying the number of units sold by the selling price of each unit.

• It is an important financial metric that indicates the company's performance and growth.

• Higher turnover generally indicates better financial health and efficiency.

• Example: Company X had a turnover of $1 million ...read more
Answered by AI
Add your answer

Q1. How confident are you to take up new job roles
Add your answer
Q2. You don't have the experience of certain things, how will you tackle them.
Add your answer

Q1. Where do you stay, with whom
Add your answer
Q2. Plans to shift and why do you want to join the organisation
Add your answer

Q1. Salary take home, expectations
Add your answer
Q2. Your present job role and salary slip
Add your answer

Coding test to screen developer skills

Arithmetic,data interpretation, verbal ability, verbal test, logical

Comprehensive technique to judge the suitability of an individual and his appropriateness for admission & scholarship

A job type of work that you are given to do

Q1. Weather i can travel for work or not
Add your answer

Q1. Profile related, industry and travel
Add your answer

Q1. What are your salary expectations?
View 2 more answers
Q2. Share details of your previous job.
View 1 more answer
Q3. Why should we hire you?
Add your answer
Q4. Why are you looking for a change?
Add your answer
Q5. What are your strengths and weaknesses?
Add your answer
Q6. Tell me about yourself.
Add your answer

Q1. Salary expectation Question related job location
Add your answer
Q2. Your expectations for salary
Add your answer

A group discussion (GD) is a structured form of communication used commonly in academic settings, business meetings, and selection processes for jobs and admissions. Here are the key elements of a group discussion:

### Purpose
- **Selection Tool:** GDs are often used in recruitment and admissions to assess candidates' communication skills, teamwork, leadership, and problem-solving abilities.
- **Decision-Making:** In organizational settings, GDs help in making collective decisions and brainstorming solutions.
- **Learning and Knowledge Sharing:** Academic GDs facilitate knowledge exchange and enhance understanding of complex topics.

### Structure
1. **Topic Introduction:**
- The facilitator or moderator introduces the topic.
- The topic can be of various types: abstract (e.g., "Red vs. Blue"), factual (e.g., "Climate Change"), or controversial (e.g., "Capital Punishment").

2. **Preparation Time:**
- Participants may be given a few minutes to gather their thoughts and jot down key points.

3. **Discussion:**
- Participants share their views, debate, and discuss the topic.
- Typically lasts 15-40 minutes, depending on the context and number of participants.

4. **Conclusion:**
- Some GDs end with a summary of key points or a consensus reached by the group.
- In some formats, one participant may be asked to summarize the discussio

A group discussion (GD) is a structured form of communication used commonly in academic settings, business meetings, and selection processes for jobs and admissions. Here are the key elements of a group discussion:

### Purpose
- **Selection Tool:** GDs are often used in recruitment and admissions to assess candidates' communication skills, teamwork, leadership, and problem-solving abilities.
- **Decision-Making:** In organizational settings, GDs help in making collective decisions and brainstorming solutions.
- **Learning and Knowledge Sharing:** Academic GDs facilitate knowledge exchange and enhance understanding of complex topics.

### Structure
1. **Topic Introduction:**
- The facilitator or moderator introduces the topic.
- The topic can be of various types: abstract (e.g., "Red vs. Blue"), factual (e.g., "Climate Change"), or controversial (e.g., "Capital Punishment").

2. **Preparation Time:**
- Participants may be given a few minutes to gather their thoughts and jot down key points.

3. **Discussion:**
- Participants share their views, debate, and discuss the topic.
- Typically lasts 15-40 minutes, depending on the context and number of participants.

4. **Conclusion:**
- Some GDs end with a summary of key points or a consensus reached by the group.
- In some formats, one participant may be asked to summarize the discussion.

### Evaluation Criteria
- **Communication Skills:** Clarity, coherence, and