CBSE Class 12 Informatics Practices
Question 50 of 103
Review of Database Concepts & SQL — Question 20
Back to all questions 20
Question Consider the attributes ( RollNumber, 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') ;
1.
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | NULL |
2.
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | 00000000 |
3.
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv | 2003-05-15 | 12354899 |
| 2 | Sudha | 2002-02-28 | 0 |
4.
| 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.