Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part1 : 6 to 10

Following SQL Multiple choice objective type questions and answers will help you in many software compnaies written examinations and inteview 2015 :

6.Insert into employee _____ (1002,Joey,2000); In the given query which of the keyword has to be inserted ?

Table

Values

Relation

Field

7.To alter a database ___________ command is used

ALTER database database_name

ALTER database_name

ALTER database database_name

ALTER database_name

8.Which of the following statements contains an error?

Select * from emp where empid = 10003;

Select empid from emp where empid = 10006;

Select empid from emp;

Select empid where empid = 1009 and lastname = ‘GELLER’;

9.Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?

Salary, dept_id

Employee

Salary

All the field of employee relation

10.Select name, course_id from instructor, teaches where instructor_ID= teaches_ID; This Query can be replaced by which one of the following ?

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name ,course_id from instructor;

Select course_id from instructor join teaches;

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Too many of us are not living our dreams because we are living our fears.- Les Brown

Related Online Test