Comprehension Passage
Case study based question
An Educational Institute in Delhi make use of DBMS to store details of students. The institute maintains a database named 'school - record' under which there are two tables.
1. Student table : maintains general details of every student enrolled in the school
2. Stulibrary Table: To store the details of issued books.
* BookID is the unique identification number of 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 |
Which of the following SQL query will fetch ID of those issued books which have not been returned?
1
Select BookID from Stulibrary where BookID is NULL;
2
Select BookID from Stulibrary where StulD is NULL;
3
Select BookID from Stulibrary where Issued date is NULL;
4
Select BookID from Stulibrary where Return_date is NULL;