CBSE Class 11 Informatics Practices
Question 38 of 87
Structured Query Language (SQL) — Question 19
Back to all questions 19
Question Consider the attributes ( RollINumber, SName, SDateofBirth, GUID ) of the table Student. According to you, which of the following options is the correct representation of the table after executing the following query?
Insert Into Student (RollNumber, SName, SDateofBirth)
Values (2, 'Sudha', '2002-02-28') ;
(i)
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | NULL |
(ii)
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | 00000000 |
(iii)
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | 00000000 |
(iv)
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 |
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | NULL |
Reason — In the above code, a new row is inserted into the 'Student' table, values are provided for RollNumber, SName, and SDateofBirth, but not for GUID. Since GUID is not specified, it will take on its default value, which may be NULL if no default value is defined for the column.