NCERT Solutions Class 12 Computer Science Structured Query Language

Scroll down for PDF

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 on the text For more study material for Computer Science please click here - Computer Science

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

CBSE Instructs schools to form Eco Clubs

The Central Board of Secondary Education has directed schools to form Eco Clubs under the Board for Environmental Protection. They have further asked the schools to ensure that every student would save one litre of water at home and school every day. It was started by...

CBSE and Microsoft join hands to build capacity for AI learning for schools

Central Board of Secondary Education and Microsoft join hands to build capacity for AI learning for schools : The officials from the Central Board of Secondary Education have announced that they have partnered with Microsoft India to conduct several capacity building...

Sample Papers for Class 12 Boards 2020

CBSE has released the final sample papers for the class 12 boards exams as per the new pattern as per which the question papers are expected to come in the 2020 board exams for class 12. The sample papers have been for class 12 for all subjects along with the suggested...

CBSE will have more practicals

CBSE board has made a bigger announcement regarding 2020 board examinations for class 12. Board has decided that subjects like humanities, History, English and Hindi will also have practical exams like Chemistry, Biology, and Physics. As per, CBSE official's statement...

TIPS: Study habits for success

Being a student is fairly a difficult job. Alongside maintaining your curricular as well as extra-curricular activities adds more to it. Performance in academics is one of the major concerns. Every parent now tries to get their children more indulged in studies. Need...

Extension of dates by CBSE for Single Girl Child Merit (SGC) scholarship

CBSE has announced to extend dates for SGC scholarship. Previously the dates to submit the SGC scholarship form were 18 October 2019. Now dates have shifted. For online submission, the last date is 31st October. Whereas date for submission of hard copies of renewal...

×
Studies Today