Question
Write the output produced by the following SQL commands:
✓
Answer
(a) 
(b) 
(c) 
(d) 
(e) 
(f) 
(g) 
(h) 
(i) 
(j) 
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Given the following relation: STUDENT
Table: STUDENT
| No. | Name | Age | Department | Dateofadm | Fee | Sex |
| 1 | Pankaj | 24 | Computer | 10/01/97 | 120 | M |
| 2 | Shalini | 21 | History | 24/03/98 | 200 | F |
| 3 | Sanjay | 22 | Hindi | 12/12/96 | 300 | M |
| 4 | Sudha | 25 | History | 01/07/99 | 400 | F |
| 5 | Rakesh | 22 | Hindi | 05/09/97 | 250 | M |
| 6 | Shakeel | 30 | History | 27/06/98 | 300 | M |
| 7 | Surya | 34 | Computer | 25/02/97 | 210 | M |
| 8 | Shikha | 23 | Hindi | 31/07/97 | 200 | F |
Write SQL commands for the following queries
(a) To show all information about the students of History department.
(b) To list the names of female students who are in Hindi department.
(c) To list the names of all students with their date of admission in ascending order.
(d) To display student’s name, fee, age for male students only.
(e) To count the number of students with Age>23.
How can you get the sum of values of a column in pandas DataFrame?
Which protocol helps us to transfer files to and from a remote computer?
Categorise the following under Client Side and Server Side script category:
(i) VB Script
(ii) ASP
(iii) JSP
(iv) JavaScript
Differentiate between PAN and LAN types of networks.
Write function insert() to insert the new row in table emp. The function will take the values as parameter.
Write a script to create an empty list and then find the sum of all the elements present at even indices of the list.
Explain the concept of split-apply-combin in group by.
What is the basic difference between Trojan Horse and Computer Worm?
Write a script to create a list of 10 integers and then
(a) Display all the elements of the list
(b) Display the odd elements of the list
(a) Display all the elements of the list
(b) Display the odd elements of the list