Advertisements
Chapters
2: Data Abstraction
3: Scoping
4: Algorithmic Strategies
5: Python - Variables and Operators
6: Control Structures
7: Python functions
8: Strings and String manipulation
9: Lists, Tuples, Sets and Dictionary
10: Python Classes and objects
11: Database Concepts
▶ 12: Structured Query Language (SQL)
13: Python and CSV files
14: Importing C++ programs in Python
15: Data manipulation through SQL
16: Data visualization using pyplot: line chart, pie chart and bar chart
![Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 12 - Structured Query Language (SQL) - Shaalaa.com](/images/computer-science-english-class-12-tn-board_6:5f2b1b2038084cf381bfa42c826a928c.jpg "Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 12 - Structured Query Language (SQL)")
Advertisements
Solutions for Chapter 12: Structured Query Language (SQL)
Below listed, you can find solutions for Chapter 12 of Tamil Nadu Board of Secondary Education Samacheer Kalvi for Computer Science [English] Class 12 TN Board.
Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board 12 Structured Query Language (SQL) Evaluation [Pages 230 - 231]
Part I - Choose the best answer 1 X 5 = 5
Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.
DDL
DML
DCL
DQL
Which command lets to change the structure of the table?
SELECT
ORDER BY
MODIFY
ALTER
The command to delete a table is ______
DROP
DELETE
DELETE ALL
ALTER TABLE
Queries can be generated using ______
SELECT
ORDER BY
MODIFY
ALTER
The clause used to sort data in a database.
SORT BY
ORDER BY
GROUP BY
SELECT
Part II - Write Short Answers 2 x 5 = 10
Write a query that selects all students whose age is less than 18 in order wise.
Differentiate Unique and Primary Key constraint.
Write the difference between table constraint and column constraint?
Which component of SQL lets inserts values in tables and which lets to create a table?
What is the difference between SQL and MySQL?
Part III - Explain 3 x 5 = 15
What is a constraint?
Write a short note on Primary key constraints.
Write a SQL statement to modify the student table structure by adding a new field.
Write any three DDL commands.
Write the use of the Savepoint command with an example.
Write a SQL statement using the DISTINCT keyword.
Part IV - Explain in Detail 5 x 5 = 25
Write the different types of constraints and their functions.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display the details of all employees in descending order of pay.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display all employees whose allowance is between 5000 and 7000.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To remove the employees who are mechanics.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To add a new row.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display the details of all employees who are operators.
What are the components of SQL? Write the commands in each.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.
Solutions for 12: Structured Query Language (SQL)
Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 12 - Structured Query Language (SQL)
Shaalaa.com has the Tamil Nadu Board of Secondary Education Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. Samacheer Kalvi solutions for Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education 12 (Structured Query Language (SQL)) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. Samacheer Kalvi textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in Computer Science [English] Class 12 TN Board chapter 12 Structured Query Language (SQL) are Introduction to SQL, Role of SQL in RDBMS, Processing Skills of SQL, Creating Database, Components of SQL, Data Types, SQL Commands and Their Functions.
Using Samacheer Kalvi Computer Science [English] Class 12 TN Board solutions Structured Query Language (SQL) exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in Samacheer Kalvi Solutions are essential questions that can be asked in the final exam. Maximum Tamil Nadu Board of Secondary Education Computer Science [English] Class 12 TN Board students prefer Samacheer Kalvi Textbook Solutions to score more in exams.
Get the free view of Chapter 12, Structured Query Language (SQL) Computer Science [English] Class 12 TN Board additional questions for Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education, and you can use Shaalaa.com to keep it handy for your exam preparation.
