(a) Create a table Weather with the following structure using SQL | Name of Column | Type | | :--- | :--- | | City | Character(15) | | Temperature | Number(2) | | Humidity | Number(2) | | Condition | Character(20) | | Country | Character(20) | Create Queries for the following requirements : ..... 10
Explanation
The SQL query creates a table named Weather with five columns: City, Temperature, Humidity, Condition, and Country. Each column has a specific data type, such as CHARACTER(15) for the City column and NUMBER(2) for the Temperature column.
⬆ Related Topic
📘 Syllabus
View KERALA UNIVERSITY Class 5 Syllabus →
📝 Practice Questions
Practice Previous Year Questions →
🤖 Practice with AI
Generate Practice Question Paper →
📚 Related Concepts
- (a) List down any four key characteristics of Light Rail Transit System (LRT).
- (a) Explain the factors involved in the selection of good alignment for a railway line. Illustrate with necessary sketch
- (a) Explain the functions of rails and various types of rails in use.
- (a) What is negative super elevation? A $1^{\circ}$ curve track diverges from a main curve of $3^{\circ}$ in the opposit
- (a) Why is widening of gauge required on sharp curves? Determine the extent of gauge widening required for a broad gauge