Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Select Empname AS EmployeeName from Employee
b. Select Empname Employeename from Employee
c. Only a
d. Both a and b
Reveal Answer
Options:
a. Select * from employee where deptid IS EQUAL TO 10 OR 20
b. Select * from employee where deptid =10 AND deptid=20
c. Select * from employee where deptid IN(10,20)
d. None
Reveal Answer
Options:
a. only multiple values
b. only single value
c. either single value or multiple values
Reveal Answer
Options:
a. Select avg(salary) from Employees
b. Select avg(salary) as‘avgsal' from Employees
c. Select avg(salary)‘avgsal’ from Employees
d. All are correct
Reveal Answer
Options:
a. Select max(salary) from employees where name=’k%’
b. Select max(salary) from employees where salary=’k%’
c. Select max(salary) from employees where salary like ’%k%’
d. Select max(salary) as ‘maxsal’ from employees where name like ‘k%’
Reveal Answer
Options:
a. Select total(salary) from employees
b. Select sum(salary) from employees
c. Select total of salary from employees
d. Select sum of salary from employees
Reveal Answer
Options:
a. Select sum(salary) from employees where dept=’db’
b. Select min(salary) from employees where dept=’db’
c. Select min(salary) from employees where dept like ‘db’
d. None of the above
Reveal Answer
Options:
a. Count function used only for displaying total number of columns present in the original result set
b. Count function used for displaying total number of rows present in the result set
c. Count function used for displaying total number of columns present in the result set
d. None of the above
Reveal Answer
Options:
a. Select top(salary) from employees
b. Select top of salary from employees
c. Select Maximun(salary) from employees
d. Select max(salary) from employees
Reveal Answer
Options:
a. Avg(salary) should not be selected
b. Dept_id should not be used in group by clause
c. Misplaced group by clause
d. Group by clause is not valid in this query
Reveal Answer
Bestdotnet google plus