Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

In the Table employee_Details there are two columns: Employee_Id-Integer[10] and Employee_Name-Char[10],The following select query Select distinct(Employee_Name) from employee_Details where Employee_Id='1232' fails due to:

  1. The field mentioned in the where clause should be one of the columns selected

  2. The distinct function can not be used on a field of type Char

  3. The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.

  4. none of the above.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

The following query fails. Select employee_name,employee_id,count() from employee_Details group by employee_id where count()>2; The right format is:

  1. Select employee_name,count() from employee_Details group by employee_id where count()>2;

  2. Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

  3. Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;

  4. NONE of THE ABOVE
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation