NCERT Solutions Class 12 Computer Science Structured Query Language

NCERT Solutions Class 12 Computer Science  Structured Query Language. NCERT book for Computer Science in class 12 is strongly recommened by teachers and the CBSE and NCERT boards. Please download the NCERT solutions for class 12 Computer Science free in PDF made by teachers of the best schools in India. These solutions are carefully compiled to give detailed understanding of the concepts and also steps of solutions. The NCERT solutions are free to download in pdf format. Please refer to the download link below to download the pdf file and also refer to other chapters and subjects to get the solutions to Computer Science NCERT book questions and exercises.

Chapter - Structured Query Language

Question 1: Differentiate between delete and drop table command ?

Аnswer: DELETE command is used to remove information from a particular row or rows. If used without any condition, it will delete all row information but not the structure of the table. It is a DML command. DROP table command is used to remove the entire structure of the table and information. It is a DDL command.

Question 2: What is the use of wildcard ?

Аnswer: The wildcard operators are used with the LIKE operator to search a value similar to a specific pattern in a column. There are 2 wildcard operators. % – represents 0,1 or many characters – = represents a single number or character

Question 3: Write SQL query to add a column total price with datatype numeric and size 10, 2 in a table product.

Аnswer: ALTER TABLE product ADD total price number

Question 4: While creating table ‘customer’, Rahul a forgot to add column ‘price’. Which command is used to add new column in the table. Write the command to implement the same.

Аnswer: ALTER TABLE customer ADD price number(10,2)

Question 5: Deepika wants to remove all rows from the table BANK. But he needs to maintain the structure of the table. Which command is used to implement the same ?

Аnswer: DELETE FROM BANK

Question 6: Sonal needs to display name of teachers, who have “0” as the third character in their name.She wrote the following query. Select name from teacher where name = “$$0?”; But the query isn’t producing the result. Identify the problem.

Аnswer: The wildcards are incorrect. The corrected query is SELECT name FROM teacher

WHERE name LIKE’ _ _ 0%’ 

Please click on link below to download NCERT Solutions Class 12 Computer Science  Structured Query Language.

Tags: 

 


Click to View or Download pdf file
Click for more Computer Science Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Cogito and The Question Book A series on Thinking skills by CBSE

The Board has dedicated this academic session 2020-21 for ‘Competency Based Learning’. Skills connected to Critical & Creative thinking, Problem Solving, Collaboration and Communication are core to successful living in the 21st Century. To focus on the importance...

Re verification of Class 10 Board Exams Marks

Modalities and Schedule for Secondary School (Class X) Examinations, 2020 in the subjects whose examinations have been conducted by CBSE for the processes of (I) Verification of Marks (II) Obtaining Photocopy of the Evaluated Answer Book(s) (Ill) Re-evaluation of Marks...

CBSE Reduced Syllabus Class 11 and 12

CBSE has announced major reduction in the syllabus for class 11 and class 12. There has been major changes too in the main syllabus for class 11 and 12. The prevailing health emergency in the country and at different parts of the world as well as the efforts to contain...

Training Programme on the Alternative Academic Calendar

In view of the extraordinary situation prevailing in the world due to COVID-19 pandemic, the CBSE Board had announced the ‘Revised Academic Curriculum for classes 9- 12 for the session 2020-21’. The reduced topics will not be part of the internal assessment or for the...

CBSE Reduced Syllabus Clarification

CBSE board has issued the following clarification relating to various news reports regarding reduction in syllabus and questions from the reduced syllabus during board exams. Please read below: It has come to notice of the Board through a section of media reports that...

Board Cancelled Official CBSE Statement

Keeping in view the requests received from various State Governments and the changed circumstances as on date, following has been decided- 1. Examinations for classes X and XII which were scheduled from 1st July to 15th, 2020 stand cancelled. 2. Assessment of the...

×
Studies Today