CBSE Class 12 Informatics Practices
Question 35 of 44
Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065) — Question 4
Back to all questions 4
Question I. Write an SQL statement to create a table named STUDENTS, with the following specifications:
| Column Name | Data Type | Key |
|---|---|---|
| StudentID | Numeric | Primary Key |
| FirstName | Varchar(20) | |
| LastName | Varchar(10) | |
| DateOfBirth | Date | |
| Percentage | Float(10, 2) |
II. Write SQL Query to insert the following data in the Students Table
1, Supriya, Singh, 2010-08-18, 75.5
I.
CREATE TABLE STUDENTS (
StudentID NUMERIC PRIMARY KEY,
FirstName VARCHAR(20),
LastName VARCHAR(10),
DateOfBirth DATE,
Percentage FLOAT(10,2)
);II.
INSERT INTO STUDENTS (StudentID, FirstName, LastName,
DateOfBirth, Percentage) VALUES (1, 'Supriya', 'Singh', '2010-08-18',
75.5);