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

JEE Entrance Exam 2020 Dates Registration Admit Cards Exam Pattern

JEE Entrance exam is conducted for students who wish to pursue engineering in different subjects or categories like mechanical, CS, etc.. It is officially organized and conducted by NTA. Formerly it was organized by CBSE. It avails seats for students in IITs, NITs, and...

CBSE examination board hike the fee for class 10th and 12th

The CBSE (Central Board Secondary Education) increased the examination fees for classes 10 and 12 of the 2020 boards, with no profit no loss principle, from Rs. 750 to Rs 1500, for all categories of students, including SC/ST candidates for all schools throughout India...

NCERT NTSE Admit Card 2020 released - know more

Introduction: NTSE 2020 National Talent search examination is conducted by NCERT to take out the students who excel in science. It is organized to measure and let the students with talent outshine in their coming future. This talent search exam is taken in 2 stages....

How to crack a competitive examination

“How I crack a competitive examination” is a frequently asked question by today’s students. Cracking a competitive exam is a challenging task. Attaining a huge amount of study and solving several complex problems in a limited amount of time is a huge task. Competitive...

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...

Tips for exam preparation

Students often get nervous during their exams. The reason behind this nervousness is either a lack of confidence or a lack of preparedness. To overcome these fears students are advised to do their preparation in such a way that will retain their confidence. For this...

×
Studies Today