View Count: 0
Duration: 74 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 20
Does COUNT(*) include NULL values? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:

Question No: 2 of 20
Does AVG function consider NULL values? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
b
Explanation:

Question No: 3 of 20
The functions COUNT(), MIN() and MAX() cannot take as input which of the following data type? 
Options:
  1. int
  2. char
  3. decimal
  4. date
View Answer/Explanation:
c
Explanation:

Question No: 4 of 20
Can grouping be done on multiple columns 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:

Question No: 5 of 20
Which of the following statement is used to alias the column Empname as Employeename? 
Options:
  1. Select Empname AS EmployeeName from Employee
  2. Select Empname Employeename from Employee
  3. Only a
  4. Both a and b
View Answer/Explanation:
d
Explanation:

Question No: 6 of 20
Query to get all employees belonging to department 10 and 20 
Options:
  1. Select * from employee where deptid IS EQUAL TO 10 OR 20
  2. Select * from employee where deptid =10 AND deptid=20
  3. Select * from employee where deptid IN(10,20)
  4. None
View Answer/Explanation:
c
Explanation:
Select * from employee where deptid IN(10,20) Note: (Select * from employee where deptid =10 OR deptid=20) is also correct

Question No: 7 of 20
Aggregate functions can return? 
Options:
  1. only multiple values
  2. only single value
  3. either single value or multiple values
View Answer/Explanation:
b
Explanation:

Question No: 8 of 20
Which of the following is not a aggregate function 
Options:
  1. Sum
  2. With
  3. Min
  4. Avg
View Answer/Explanation:
b
Explanation:

Question No: 9 of 20
Aggregate functions can be used in the select list or the_______ clause of a select statement or subquery. They cannot be used in a______ clause. 
Options:
  1. Where,Having
  2. Having,Where
  3. Groupby,Having
  4. Groupby, where
View Answer/Explanation:
b
Explanation:

Question No: 10 of 20
Which of the following function is used for calculating aggregate value. 
Options:
  1. Sum
  2. Max
  3. Average
  4. Avg
View Answer/Explanation:
d
Explanation:

  1