Live Help (Start Chat)
View Count: 0
Duration: 70 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 11
DQL stands for? 
Options:
  1. Dynamic Query language
  2. Data Query Language?
View Answer/Explanation:
b
Explanation:

Question No: 2 of 11
Which of the following statement can be used to compare a part of a name LIKE ‘ab’ 
Options:
  1. Select * from where LIKE
  2. Select * from
  3. where LIKE
  4. Select * from
  5. where LIKE
  6. Select * from
  7. where LIKE
    View Answer/Explanation:
    b
    Explanation:
    Select * from
    where LIKE ‘%ab%’% represents a set of characters
    Question No: 3 of 11
    Which of the following statement can be used to retrieve all employees whose commission is null? 
    Options:
    1. Select * from employee where commission =NULL
    2. Select * from employee where commission = ‘ ‘
    3. Select * from employee where commission IS NULL
    4. Select * from employee where commission == NULL
    View Answer/Explanation:
    c
    Explanation:
    Select * from employee where commission IS NULL

    Question No: 4 of 11
    ORDER BY cannot be used on which kind of column? 
    Options:
    1. Varchar
    2. Text
    3. Char
    4. Nchar
    View Answer/Explanation:
    b
    Explanation:
    ORDER BY cannot be used on ntext, text and image columns

    Question No: 5 of 11
    Which option is correct? 
    Options:
    1. ORDER BY statement can be used to order multiple columns
    2. ORDER BY statement cannot be used to order multiple columns
    View Answer/Explanation:
    a
    Explanation:

    Question No: 6 of 11
    Which option is correct? 
    Options:
    1. GROUP BY statement can be used to group multiple columns
    2. GROUP BY statement cannot be used to group multiple columns
    View Answer/Explanation:
    a
    Explanation:

    Question No: 7 of 11
    Which of the following is true regarding HAVING CLAUSE? 
    Options:
    1. It can use only those columns that are present in the SELECT statement
    2. It can use aggregate functions
    3. It is used to filter the rows got after applying GROUP BY
    View Answer/Explanation:
    a b c
    Explanation:

    Question No: 8 of 11
    Can the WHERE clause use aggregate functions? 
    Options:
    1. Yes
    2. No
    View Answer/Explanation:
    b
    Explanation:

    Question No: 9 of 11
    Can the HAVING clause use the LIKE operator? 
    Options:
    1. Yes
    2. No
    View Answer/Explanation:
    b
    Explanation:

    Question No: 10 of 11
    Which of the following statement can be used to retrieve the number of records in the employee table 
    Options:
    1. select count from employee
    2. select count(*) from employee
    3. select distinct count(*) from employee
    4. select distinct count from employee
    View Answer/Explanation:
    b
    Explanation:

      1