Direction: Q.1 to 5 |
I. A school in Delhi uses database management system to store student details. The school maintains a database 'school record' under which there are two tables. |
Student Table: Maintains general details about every student enrolled in school. |
StuLibraryTable: To store details of issued books. BookID is the unique identification number issued to each book. Minimum issue duration of a book is one Day. |
STUDENT | |
Field | Type |
StuID | numeric |
StuName | Varchar(20) |
StuAddress | Varchar(50) |
StuFatherName | Varchar(20) |
StuContact | numeric |
StuAadhar | numeric |
StuClass | Varchar(5) |
StuSection | Varchar(1) |
StuLibrary | |
Field | Type |
BookID | numeric |
StuID | numeric |
Issued_date | Date |
Return_date | Date |
Identify the SQL Query which displays the data of StuLibrary table in ascending order of StudentID. |
(i) Select * from StuLibrary Order By BookID. |
(ii) Select * from StuLibrary Order By StuID |
(iii) Select * from StuLibrary Order By StuID ASC |
(iv) Select * from StuLibrary Order By StuID DESC |
Choose the correct option: |
A) Both Query (i) and (iv) will display the desired data.
B) Both Query (i) and (ii) will display the desired data.
C) Both Query (iii) and (iv) will display the desired data.
D) Both Query (ii) and (iii) will display the desired data
Correct Answer: D
Solution :
[d]You need to login to perform this action.
You will be redirected in
3 sec