Informatics Practices
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 |
Relational Database
2 Likes
Answer
| 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.
Answered By
3 Likes
Related Questions
Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:
- Select Ename, Salary*12 Annual Salary From Emp;
- Select Ename, Salary*12 Rename "Annual Salary" From Emp;
- Select Ename, Salary*12 Change "Annual Salary" From Emp;
- Select Ename, Salary*12 as "Annual Salary" From Emp;
The symbol Asterisk (*) in a select query retrieves …………… .
- All data from the table
- Data of primary key only
- NULL data
- None of these
Consider a table Student having two fields—FName varchar(20) and LName char(20). If in a record, value stored in Fname is 'Anuj' and LName is 'Batra', then FName and LName will consume …………… and …………… character space respectively.
- 4, 5
- 4, 20
- 20, 4
- 20, 20
Assertion (A): Database management system is an application software which arranges data in a well-organized manner in the form of tables.
Reasoning (R): DBMS acts as an interface between the database stored in the computer memory and the user.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.