Advertisements
Advertisements
Can keep you signed in.
I can remember your site preferences.
I can give you locally relevant content.
Who am I?
Concept: undefined >> undefined
Which of the following are not used in mobile communication?
Concept: undefined >> undefined
Advertisements
Which of the following are the features of mobile communication?
Concept: undefined >> undefined
Which of the following are examples of mobile communication systems?
Concept: undefined >> undefined
A web cookie is a small piece of data that is ______
Concept: undefined >> undefined
To skip NaN values in a calculation, you can specify the ______ attribute.
Concept: undefined >> undefined
Which command is correct to display the total number of all ITEMS in the STOCK data frame?
Concept: undefined >> undefined
Which command is correct to display the total QUANTITY of all ITEMS in the STOCK?
Concept: undefined >> undefined
______ is used to get a specified day of the month for a given date.
Concept: undefined >> undefined
In general, a file is basically a collection of all related ______.
Concept: undefined >> undefined
______ keyword is used to find out the number of values in a column?
Concept: undefined >> undefined
HTML stands for ______.
Concept: undefined >> undefined
Which method is used to get the row-id of the last modified row?
Concept: undefined >> undefined
Which of the following belongs to an "aggregate function"?
Concept: undefined >> undefined
A file is a
Concept: undefined >> undefined
The MAX () function finds the
Concept: undefined >> undefined
Consider the table STUDENT given below:
| RollNo | Name | Class | DOB | Gender | City | Marks |
| 1 | Anand | XI | 6/6/97 | M | Agra | 430 |
| 2 | Chetan | XII | 7/5/94 | M | Mumbai | 460 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
| 5 | Saniyal | XII | 8/10/95 | M | Delhi | 360 |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 8 | Nishant | X | 12/6/95 | M | Moscow | 429 |
State the command that will give the output as:
| Name |
| Anand |
| Chetan |
| Geet |
| Preeti |
(i) select Name from student where Class ='XI' and Class='XII';
(ii) select name from student where not Class='XI' and Class='XII';
(iii) select name from student where City="Agra" or City="Mumbai";
(iv) select name from student where City in("Agra", "Mumbai");
Choose the correct option:
Concept: undefined >> undefined
Consider the table STUDENT given below:
| RollNo | Name | Class | DOB | Gender | City | Marks |
| 1 | Anand | XI | 6/6/97 | M | Agra | 430 |
| 2 | Chetan | XII | 7/5/94 | M | Mumbai | 460 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
| 5 | Saniyal | XII | 8/10/95 | M | Delhi | 360 |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 8 | Nishant | X | 12/6/95 | M | Moscow | 429 |
State the command to display the average marks scored by students of each gender who are in class XI?
(i) Select Gender, avg(Marks) from STUDENT where Class= "XI" group by Gender;
(ii) Select Gender, avg(Marks) from STUDENT group by Gender where Class="XI";
(iii) Select Gender, avg(Marks) group by Gender from STUDENT having Class="XI";
(iv) Select Gender, avg(Marks) from STUDENT group by Gender having Class = "XI";
Choose the correct option:
Concept: undefined >> undefined
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Concept: undefined >> undefined
