Exam2win > Programming > Sql Interview > part2

Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part2 : 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.Select name from instructor where salary <= 100000 and salary >= 90000; This query can be replaced by which of the following ?

Select name

instructor

salary between 90000 and 100000;

Select name

7.Select * from employee where dept_name=”Comp Sci”; #17. Select * from employee where dept_name=”Comp Sci”; In the SQL given above there is an error . Identify the error .

Dept_name

Employee

“Comp Sci”

From

8.Select name from instructor where dept name = ’Physics’ order by name; By default, the order by clause lists items in ______ order.

Descending

Any

Same

Ascending

9.The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.

Create table

Create temporary table

Create view

Create label view

10._____ operator is used for appending two strings.