Sunday, 26 March 2017

Interview Tips for trainer , Complete Interview and key points of interview



          Interviews
*       Position: Trainer
*       Work experience: Fresher

*       Education Qualification: Graduation/Post- Graduation.

This is an interview of a person who got selected as a trainer in skill development sector in one of the big brand of education industry.

(Fresher’s interviews totally depend on their curriculum vita and their qualification because a fresher doesn’t have any work experiences, so his /her qualification is the only experience he/she is carrying. It’s better to mention true and documented proof which he/she is having with them. Plus don’t mention any information, which one don’t have any knowledge or idea, it may lead to rejection.)


      Candidate ,  Good Morning Sir .
      Interviewer: Good Morning. How are you?

      Interviewee: I’ am fine Ma’am and you?

      Interviewer: All good, let’s start with the process. So tell me about yourself?

      Interviewee: My name is Ram. I completed my MBA from ABC Institute and did my graduation from DEF university. My schooling was from QRS School Delhi. I live in South Delhi and I am fresher. 

      Interviewer:  what you did in graduation?

      Interviewee: I did B.A

      Interviewer:  Was your college regular?
      Interviewee:  Yes, I my college was regular.

      Interviewer:  you have mentioned in your C.V that you did internship in the retail sector. Can you tell me about this internship?

      Interviewee:  Yes, I did my internship in the retail sector in marketing field.  Where I need to do marketing, research and merchandising of XYZ Company’s product.

(This answer must be depending on projects or trainings mentioned by candidate on the resume. Candidate must have full knowledge of mentioned projects or training with full documented proof.)


      Interviewer:  You said, you were taking care of marketing of product of XYZ Company. Then why do you want a job in training field? Not in marketing field?

      Interviewee:  The reason behind this, I want to do job in training field because I like training, it is a very interesting field and you need to learn a lot every day, it’s very vibrant field and I love training.


      Interviewer: It seems you like training job. This very good for us. Now let me ask some basic questions related to training? What is the difference between training and teaching?

      Interviewee: There is one difference between training and teaching, which is a methodology. Teaching mainly follows pedagogy while training follows andragogy.  So it’s depending where teaching is required and where training is required.


      Interviewer: Good answer. If you got selected in our company then you need to train students who are mainly from low income group or below the poverty line or school dropouts. Most students are not interested in studies? How will you encourage learning in them or create interest?

      Interviewee:  I need to find out why it happened or why they are not interested in studies. I need to find ways in which they find the studies interesting. They need to be aware or counsel, why studies are important. 

(Every interview has technical round on which candidate’s selection is judge, so one should brush the learning or knowledge required for job. It is must.)


      Interviewer: If any student gets dropped out or stop coming to your classes. What will you do? How you’ll bring her/him back?

      Interviewee:  If this kind of case will happen, I will go to the student and ask why he/she has stopped coming to my class? What are the reasons? And then I will counsel him/her according to that and try my best to get her/him back to my class.


      Interviewer: Good answer ram. Tell me your strengths and weaknesses?

      Interviewee: My strengths are I am hard working. I used to work late night or early morning on my projects in my masters, that’s why I got excellence certificates in my projects and I am an empathetic person, that’s why I help people going beyond my strength, due to this I am also a good team player. Now my weaknesses are: I am an impatient person, I can’t take rest till my work is not completed plus I am a very aggressive person, I want my things in the right way till it’s not harming anyone.  

(This answer is also matter of subjective but its best to mention his/her strengths and weaknesses by keeping job or position in mind)


      Interviewer: Well, good we need an empathetic person who understands the problem with solutions and a good team player. How soon you can join us?

      Interviewee:. Ma’am, I can join as per your requirement. I am comfortable in that

      Interviewer:  what are your salary expectations?

      Interviewee:  (Answer should be according to salary bar provided by the company or its matter of subjective expectation.)
At the End here the tips to improve your Training skills for getting selection during Demo sessions because in training profile Demo session is main session on which 80% of selection and remuneration depends.

Here are few tips by which one can give effective training:
           
·       As you know the area of expertise of yours in which you give training so, it’s best you should prepare some topics really well.
·       Try to judge the audiences to whom you impart training by asking some simple questions, like you can ask them what they have studied in their last session.
·       Always state motive or outcome of session before starting the training.
·       Make training session interesting by keeping balance of activities and content, too much of any part can dilute the purpose of training. Example: try to make session interactive.
·       Highlight the main points or sub topics of the training repeatedly during session so those trainees remember the main points of training.
·       Don’t make your training session too long or too short so that it can’t lose its jest.

·         Keep small test at the End of session to know how much trainees have learnt and how effectively you able to impart training plus it’s also make trainee serious throughout training.

·       Always remember two very important things to do at last, first always summaries the learning of training and secondly take feedback to know your positive and improvement points.

Keep these points in practice and in mind for effective training.
                                                Thank you!

Saturday, 18 March 2017

sql query asked in interview







An interview in Sql Questioning and database programming


Interviewer   "Hi sahil"


Sahil Replied  "hello mam !"


Interviewer "what query you write to find distinct salary from this employee  table "


Sahil Replied  " The query is , select distinct salary from employee "


Interviewer " Retrieve all employees whose address is in Houston Texas "
Sahil Replied  "  SELECT fname , lname from employee where address like '%Houston T%' "


Interviewer " find all employees who were born during 1950's "
Sahil Replied  "  SELECT fname , lname from employee where bdate  like '1950 6 times _' "


Interviewer " Retrieve all employees in department 5 whose salary is between 30000 and 40000 "
Sahil Replied  "  select * from employee  where salary between  30000 and 40000 and dno = 5 "



Interviewer "  find the sum of salaries of all  employees , the maximum salary ,  the minimum salary , and the average salary "
Sahil Replied  "  select sum(salary) , max(salary) , min(salary) , avg(salary) from employee "


Interviewer " find  the sum of the salaries of all employees of the 'Research' department , as well as the maximum salary , the minimum salary , and the average salary in this department "


Sahil Replied  " select sum(salary) , max(salary) , min(salary) , avg(salary)  from (employee join department on dno = dnumber) where dname = 'Research' "

Interviewer " For each project , retrieve the project number , the project name , and the number of employees  who work on that project in these tables "


Sahil Replied  " select pnumber , pname ,count(*) from project , works_on  where pnumber = pno group by pnumber , pname "


Interviewer " For each project on which more than two employees work  , retrieve the project number , the project name , and the number of employees who work on the project "

Sahil Replied  " select pnumber , pname , count(*) , from project , works_on  where pnumber = pno group by pnumber , pname having count(*) >2 "

Interviewer " Retrieve all name of employee whose department are there in dependent table "


Sahil Replied  " select e dot name , e dot lname from , employee as e  , where exists (select * from dependent where e dot ssn = essn and e dot sex = sex and e dot f name = dependent_name) "

Interviewer " Retrieve the name of employees who have no dependents "


Sahil Replied  " select f name , l name  from employee where not exists (select * from dependent where ssn =essn ) "


Interviewer " Write query to change location to 'Bellaire' of project no 10 of department 5 "


Sahil Replied  " update project,  set plocation  ='Bellaire' ,  where p number = 10 and  d num =5 "

Interviewer " Write query to give all employees in the 'research' department a 10 percent raise in salary "


Sahil Replied  " update employee set salary =  salaries*1.1   where dno in ( select dnumber from department where dname = 'Research') "


Interviewer " Make a list of all project numbers for projects that involve an employee whose last name is 'smith' , either as a worker or as a manager of the department that controls the project"


Sahil Replied  " (SELECT DISTINCT PNUMBER FROM PROJECT, DEPARTMENT, EMPLOYEE  WHERE DNUM=DNUMBER AND MGRSSN=SSN AND LNAME='Smith')
UNION
(SELECT DISTINCT PNUMBER FROM PROJECT, WORKS_ON, EMPLOYEE WHERE PNUMBER=PNO AND ESSN=SSN AND LNAME='Smith'); "



Interviewer " How to   specify the constraint that "the salary of an employee must not be greater than the salary of the manager of the department that the employee works for"


Sahil Replied  " CREATE ASSERTION  SALARY_CONSTRAINT CHECK ( NOT EXISTS (SELECT * FROM EMPLOYEE E, EMPLOYEE M, DEPARTMENT D  WHERE  E.SALARY>M.SALARY AND E.DNO=D.DNUMBER AND D.MGRSSN= M.SSN) )"


Interviewer " Explain views in sql with example "


Sahil Replied  "  A views is a virtual table , in contrast to  base tables , whose tuples are actually stored in the database
Example of above view is created from this query ,   create view works_on1 as select fname , lname , pname , hours from employee , project , works_on  where ssn =  essn  and pno = pnumber "


Interviewer " Explain except , union , intercept operator in sql  "


Sahil Replied  " Except operator is used to combine two select statements and return rows from the first select statement that are not returned by  the second select statement "


Sahil Replied  "  UNION  operator is used to combine the results of two or more SELECT statements without returning any duplicate rows."


Sahil Replied  " INTERSECT operator used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement."


Interviewer " Explain the difference between union and union all operator in sql "

Sahil Replied  "  UNION operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.
   UNION ALL operator is used to combine the results of two or more SELECT statements with returning  duplicate rows. "
 
 
 Interviewer "  what are different types of join and explain them."


Sahil Replied  " Different types of join are :
   INNER JOIN: returns rows when there is a match in both tables.
    LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table

RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table.
FULL JOIN: returns rows when there is a match in one of the tables.
 SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.
CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables."

  Sahil replied to all question very clearly


Search Any topic , section , query