SELECT MIN(RENT) FROM RESORT Where PLACE = ‘KERALA’; SELECT TYPE, START DATE  FROM RESORT Where TYPE ‘2 STAR’. These can assist you in gaining an in-depth knowledge of the subject.Since computer science is an integral subject in a student’s curriculum, our detailed intext of the CBSE class 12 computer science question paper 2017 with solutions contains step by step answers. SELECT NAME FROM TEACHER WHERE NAME = “$$0?”; LearnCBSE.in has given previous year Physics question paper for class 12 with solutions for the year 2019, 2018, 2017, 2016, 2015, and 2014. CBSE previous year question papers class 12: Click to get the previous year question paper of CBSE Class 12 with solutions for free here. To display all the details from table TRAVEL for the customers, who have travel distacne more than 120 KM in ascending order of NOE. Dcode WHERE DEALERS.Dcode = STOCK.Dcode. Question 2: CBSE previous year question papers class 12 Computer Science with solutions PDF Solved by Computer Science Experts experts to score good marks in the CBSE Class 12 Board Exams. Question 5: To display maximum UnitPrice of items for each dealer individually as per Dcode from the table STOCK. Question 4: Which command is used to implement the same? Here, is a list of chapters for your reference: Question 1: They ensure a smooth and easy knowledge of advanced concepts. CBSE Previous Year Question Papers for Class 12 are available here for all the major subjects such as Physics, Chemistry, Maths, Biology, Hindi, English, Commerce and Humanities. Consider the following tables RESORT and OWNEDBY and answer (a) and (b) parts of this question: (a)Write SQL commands for the following state­ments: (b)Give output for the following SQL queries: Question 16: It is advisable to set aside time to solve this paper like a real exam, in order to gauge areas where you could improve yourself. Consider the following tables GAMES and PLAYER and answer (b) and (c) parts of this question : (a)What do you understand by primary key and candidate keys ? 3. DELETE command is used to remove infor¬mation from a particular row or rows. The corrected query is SELECT NAME FROM TEACHER WHERE NAME LIKE ‘_ _0%’. Cbse last year class 12 computer science board question paper with free pdf download from Vedantu will help you in understanding the very basic of programming-based problems. COMPUTER SCIENCE – PYTHON, STARTDATE > ’31-DEC-05′; SELECT OWNER FROM RESOR OWNEDBY B WHERE (A.TYPE  START’ AND A.PLACE B.PLACE); To display details of all the items in the STORE table in ascending order of LastBuy. SELECT COUNT (DISTINCT Participants Num) FROM ACTIVITY; SELECT MAX (Schedule Date), Min (Schedule Date) FROM ACTIVITY; SELECT Name, Activity Name FROM ACTIVITY A, COACH C. SELECT Acodes, ActivityName FROM ACTIVITY ORDER BY ACode DESC; SELECT SUM(PrizeMoney) FROM ACTIVITY GROUP BY Stadium; SELECT Name, Acode FROM COACH ORDER BY Acode; SELECT * FROM ACTIVITY WHERE SchduleDate < ’01-Jan-2004′ ORDER BY ParticipantsNum; To display the RCODE and PLACE of all ‘5 STAR’ resorts in the alphabetical order of the place from table RESORT. Marks: 70 Time: 3 hrs General Instructions: All questions are compulsory. Question 8: i.e., the expected output should be; To display the price, product name and quantity (i.e., qty) of those products which have quantity more thhn 100. Currently questions not available in Application of Boolean Logic. TO DISPLAY ALL THE DETAILS OF THOSE WATCHES WHOSE NAME ENDS WITH ‘TIME’. Marking scheme of each set of Class 12 Question Paper is also provided to help you calculate marks you can score stepwise. Write SQL commands for the following statements: To display the names of all the white coloured vehicles. (b) Write SQL commands for the following statements : (c) Give the output of the following SQL  queries : Answer: CBSE computer science question paper 2017 solved is available in PDF format, which can be downloaded from Vedantu. The book Computer Science With Python contains 17 chapters for class 12 students. NCERT Solutions PDF CBSE Notes - Books - Guide ... NCERT Solutions for Class 12. Answer: In this paper, you are free to choose any one of the programmings either C++ or Python. To display the NO and NAME of those drivers from the table TRIP who travelled between ‘2015-02-10’ and ‘2015-04-01’. All Question papers have been prepared as per latest 2021 academic syllabus of Class 12 Computer Science and based on latest CBSE Class 12 Computer Science Question Papers blueprints and chapter weightage. All these question papers are available in PDF format by LearnCBSE and can be downloaded easily. To display the names of those traders, who are either from DELHI or from MUMBAI. To display the names of those suppliers, who are either from DELHI or from CHENNAI. (b) Write the output of the following SQL. To display CNO, CNAME, TRAVELDATE from the table TRAVEL in descending order of CNO. Answer: Write SQL queries for (a) to (f) and write the outputs for the SQL queries mentioned shown in (gl) to (g4) parts on the basis of tables PRODUCTS and SUPPLIERS. But the query is’nt producing the result. SELECT COUNT (DISTINCT DepCde) FROM EMPLOYEE; SELECT MAX(JoinDate), MIN (JointDate) FROM EMPLOYEE; SELECT TName, DepHead FROM EMPLOYEE E, DEPARTMENT D. SELECT COUNT (*) FROM EMPLOYEE WHERE Salary > 60000 AND Age > 30; Select AVG (Age) from EMPLOYEE WH­ERE DepCde=”103″; To display the name of all Workers in descending order of DOB. 2020 Zigya Technology Labs Pvt. Vcode; To display all DepName along with the DepCde in descending order of DepCde. SELECT NAME FROM COMPANY ORDER BY NAME DESC; To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25. It is a DDL command. There are various sets of Class 12 CBSE Question Paper which came in the year 2019 board examination. This document is highly rated by Computer Science Engineering (CSE) students and has been viewed 3810 times. If used without condition, it will delete all row information but not the structure of the table. To display Id and SName of all Shop located in Nehru Place. All solutions are latest and strictly follow the CBSE pattern. CBSE Class XII Sample Question Paper 2018-19; CBSE Class X Sample Question Paper 2018-19; ... NCERT Solutions for Class 12 Computer Science Python. CBSE Papers PDF: Class-X, Class-XII (Download) CBSE: Class XII Computer Science Question Paper - 2019 Disclaimer: This website is not at associated with CBSE, For official website of CBSE visit - www.cbse… Important Questions for Class 12 Computer Science (Python) – Structured Query Language Short Answer Type Questions Question 1: Write queries for (i) to (iv) and find ouputs for SQL queries (v) to (viii), which are based on the tables. SELECT COUNT(DISTINCT Number) FROM GAMES; SELECT MAX(ScheduleDate), MIN(Sche- duleDate) FROM GAMES, SELECT Name, GameName FROM GAMES G, PLAYER P. SELECT * FROM Games WHERE PrizeMoney >7000; SELECT * FROM Games ORDER BY ScheduleDate; SELECT SUM(Pnzemoney) FROM Games GROUPBY Type; To display the names of all activities with their Acodes in descending order. CBSE Class 12th Computer Science/Python Sample Paper 2020. Write SQL commands for the queries (i) to (iv) and output for (v) & (viii) based on a table COMPANY and CUSTOMER. Give the output of the following SQL queries : SELECT Vehicle FROM CABHUB WHERE Capacity=4; SELECT VehicleName, capacity From CABHUB ORDER BY Capacity ASC; SELECT Cname,VehicleName FROM CABHUB, CUSTOMER WHERE CUSTO­MER. Students preparing for their Class 12 exams are suggested to solve Computer Science (Python) CBSE Question Paper to boost up your speed and accuracy … What is the use of wildcard SELECr MAX (RENT), MIN (RENT) FROM RESORT GROUP BY TYPE; SELECT FROM RESORT WHERE OSWAAL (BSE Question Bank. Study variety of question types from Exam (7). Give a suitable example of a table with sample data and illustrate Primary and Alternate Keys in it. SELECT Rate* Qty FROM STORE WHERE ItemNo=2004; SELECT Item, Sname FROM STORE S, Suppliers P. SELECT * FROM STORE ORDER BY LastBuy ASC; SELECT ItemNo, Item FROM STORE WHERE Rate > 15; SELECT * FROM STORE WHERE (Scode = ’22’ OR Qty >’110′); SELECT Sname, MIN(Rate) FROM STORE, SUPPLIERS WHERE STORE. Class 12 Python Sample paper in PDF format is now availalable for download. TO DISPLAY TOTAL QUANTITY IN STORE OF UNISEX TYPE WATCHES. To display the names of the companies and the names of the items in descending order of company names. CBSE class 12 computer science covers interesting & complex programming concepts. Write SQL qureries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables TRANSPORT and TRIE. PLACE AND TYPE = ‘3 STAR’); SELECT RCODE, PLACE FROM RESORT mere TYPE = “5 STAR” ORDER. To display product name and price of all those products, whose price is in the range of 10000 and 15000 (both values inclusive). Download the PDF Question Papers Free for off line practice and view the Solutions online. SELECT Name, Price FROM ACCESSORIES ORDER BY Price Asc; SELECT ID SName FROM SHOP WHERE Area=”Nehru Place”; SELECT Name, max (Price); min(Price) FROM ACCESSORIES, Group By Name; To display name, fee, gender, joinyear about the applicants, who have joined before 2010. % – represents 0,1 or many characters – – represents a single number or character, Question 9: © The wildcards are incorrect. TO DISPLAY WATCH NAME AND THEIR QUANTITY SOLD IN FIRST QUARTER; SELECT MAX (PRICE), MIN(QTY_STORE) FROM WATCHES; SELECT QUARTER, SUM(QTY SOLD) FROM SALE GROUP BY QUARTER; SELECT WATCH_NAME, PRICE, TYPE FROM WATCHES W, SALE S WHERE W. WAT£H1D!=S.WATCHID; (viii) SELECT WATCH_NAME, QTYSTORE, SUM (QTY_SOLD), QTY_STORESUM (QTYSOLD) “STOCK” FROM WATCHES W, SALE S WHERE W. WATCHID = S.WATCHID GROUP BY S.WATCHID; SELECT * FROM WATCHES WHERE WATCH_NAME LIKE ‘%TIME’. Deepika wants to remove all rows from the table BANK. It will help you to score well and prepare for the final examination according to a latest pattern.We have also provided you with the latest Marking scheme for this sample paper, as it would help you understand the pattern and division of sections. The result of such  projecion is defined as the set obtained when  the components Of the tuple R are restriceted  to the set {a1……an}. SELECT RCODE, RENT FROM RESORT,  OWNEDBY WHERE (RESORT PLACE= OWNEDBY. These solved question papers of Computer Science (Python) can then be refered while preparing for the Class 12 board exam. To display the applicant’s name with their respective course’s name from the tables APPLICANTS and COURSES. Question 1: Each part is compulsory. Question 8: Question 13: To display the CNO and CNAME of those customers from the table TRAVEL who travelled between ‘2015-12­31’ and ‘2015-05-01’. Give the output of the following SQL queries: SELECT MAX(Charges), MIN (Charges) FROM CARDEN; Give a suitable example of a table with sample data and illustrate Primary and Candidate Keys in it. CBSE Question Paper Class 12 2019 Computer Science with Answers are given below. Skip to content. SELECT NO, NAME, TDATE FROM TRIP ORDER BY NO; SELECT NO, NAME, TDATE, KM, TCODE FROM TRIP, TO DISPLAY THE MORE THAN ONE COUNT OF TCODE FROM THE TABLE TRIP. To display the customer name and the corresponding name of the vehicle hired by them. To display the details of all employees who has joined before 2007 from EMPL­OYEE table. To display DESIGNATION without dupli¬cate entries from the table ADMIN. More Detail While creating table ‘customer’, Rahul forgot to add column ‘price’. TO DISPLAY WATCH’S NAME AND PRICE OF THOSE WATCHES WHICH HAVE PRICE RANGE IN BE-TWEEN 5000-15000. Previous Years Question Papers. To display names of all applicants in ascending order of their joinyear. Obtain the outputs of the following SQL queries based on the data given in tables ITEMS and TRADERS above. To display the highest charges at which a vehicle can be hired from CABHUB. These Python Sample papers are divided into years. These class 12 python sample papers are strictly designed as per the CBSE guidelines for Computer science question paper for CBSE Board Examination. Answer: Both Part A and Part B have choices. Write SQL commands for the following statements: To display the names of all the silver coloured cars. Questions asked are basic Syntax writing, algorithm writing and you will be also tested on how well you write a program. To display the details of those items whose dealer code (Dcode) is 102 or quantity in STOCK (Qty) is more than 100 from the table Stock. Answer the questions (a) and (b) on the basis of the following tables SHOP and ACCESSORIES. NCERT solutions provide a strong foundation for every chapter. If a table has more than one such attributes which identify a tuple uniquely than all such attributes are known as candidate keys. Consider the following tables EMPLOYEE and SALGRADE and answer (b) and (c) parts of this question: (a) What do you understand by Selection and Projection operations in relational algebra ? To display the highest charges at which a vehicle can be hired from CARDEN. Write queries for (i) to (iv) and find ouputs for SQL queries (v) to (viii), which are based on the  tables. To display the details of all the products in ascending order of product names (i.e., PNAME). To display the year and the total number of applicants joined in each YEAR from the table APPLICANTS. To display ItemNo and Item name of those items from STORE table whose Rate is more than 15 Rupees. You can access textbook questions as well as additional Zigya Questions and Exam Questions with solutions. To display the coach’s name and acodes in ascending order of Acode from the table Coach. Question 2: To display ItemNo and Item name of those items from STOCK table whose UnitPrice is more than Rupees 10. To display the content of the Activity table whose schedule date earlier than 01-01-2004 in ascending order of Participants Num. Question 11: class 12 computer science python chapter wise notes pdf and Informatics practices notes. To display the details of all EMPLOYEES in descending order of DOJ. To display the average age of Employees in DepCde as 103. To display those company name which are having prize less than 30000. Students may download the Computer Science (Python) subject CBSE Class 12 question papers PDF. CBSE Sample Papers for Class 12 Computer Science 2020 (C++) with Previous years papers (10 years papers with solutions) with marking scheme all sets of Delhi and other regions with board marking scheme as per latest CBSE curriculum 2019-20. Download CBSE Class 12 Computer Science Question Papers with solutions and latest Sample Papers, notes, practicals and other study material for all important topics like arrays, boolean algebra, c++ revision tour, classes and objects, communication and network concepts, constructors and destructors, data file handling, database concepts, etc, access free study material in pdf, practice to … NCERT Solutions for all the subjects of class 12 is available on this page including NCERT Class 12 Solution for Computer Science Python, Physics, Maths, economics are provided below to download in … TO DISPAY THE NAME AND CODE OF THOSE TRANS PORTERS, WHO HAVE TRAVELLED MORE THAN 90 KMS. Here we are providing the most comprehensive NCERT Solutions for Class 12 Computer Science (Python) PDF Chapter-wise. Educational Study Material. Write SQL commands for the queries (i) to (iv) and output for (v) to (viii) based on the tables Watches’ and Sale given below. To display the name of the companies in reverse alphabetical order. Class 12 NCERT Solution Computer Science Python. To display names of car, make and capacity of cars in descending order of their sitting capacity. Answer: SELEC MAX (PRICE), MIN (PRICE) FROM PRODUCTS; SELECT * FROM PRODUCTS ORDER BY PNAME ASC; SELECT PNAME, PRICE FROM PRODUCTS WHERE ((PRICE => 10000) AND (PRICE = < 15000)); SELECT SUPCODE, COUNT (PID) FROM PRODUCTS GROUP BY SUPCODE; SELECT PRICE, PNAME, QTY FROM PRODUCTS WHERE (QTY > 100); SELECT SNAME FROM SUPPLIERS WHERE ((CITY = “DELHI”) OR (CITY = “CHENNAI”)); SELECT COMPANY, PNAME FROM PRO-DUCTS ORDER BY COMPANY DESC; 4. These CBSE Sample Papers for Class 12 Computer Science has been recently released by the Central Board of Secondary Education. It discards (or excludes)  the other attributes. To display the name of DepHead of the Employee named “Sanjeev P”. SELECT     COUNT(*)  , CITY     FROM COMPANY GROUP BY CITY; SELECT MIN(PRICE), MAX(PRICE) FROM CUSTOMER WHERE QTY>10; SELECT AVG(QTY) FROM CUSTOMER WHERE NAME LIKE “%r%; SELECT NAME FROM COMPANY WHERE COMPANY.CID=CUSTOMER. But one can easily excel in this subject with proper and regular practice. But he needs to maintain the structure of the table. To display names of applicants, who are playing fee more than 30000. Display the OWNER of all ‘5 STAR’ resorts from tables RESORT and OWNEDBY. DELETE FROM BANK. To display NO, NAME, TDATE from the table TRIP in descending order of NO. Identify the problem. Answer: Consider the following tables STOCK and DEALERS and answer (a) and (b) parts of this question: (a)Write SQL commands for the following  statements: (b)Give the output of the following SQL queries: PythonNCERT SolutionsEnglishHindiHumanitiesCommerceScience, Kerala Syllabus 9th Standard Physics Solutions Guide, Kerala Syllabus 9th Standard Biology Solutions Guide, Important Questions for Class 12 Computer Science (Python) – Structured Query Language, NCERT Solutions for Class 8 Social Science History Chapter 3 Ruling the countryside, NCERT Solutions for Class 7 English An Alien Hand Chapter 9 A Tiger in the House, NCERT Solutions for Class 8 Social Science History Chapter 2 From Trade to Territory, NCERT Solutions for Class 7 English An Alien Hand Chapter 8 The Bear Story, NCERT Solutions for Class 7 English An Alien Hand Chapter 7 Chandni, NCERT Solutions for Class 7 English An Alien Hand Chapter 6 I Want Something in a Cage, NCERT Solutions for Class 7 English An Alien Hand Chapter 5 Golu Grows a Nose, NCERT Solutions for Class 8 Social Science History Chapter 1 How, When and Where, NCERT Solutions for Class 7 English An Alien Hand Chapter 4 The Cop and the Anthem, NCERT Solutions for Class 8 Social Science Geography Chapter 1 Resources, NCERT Solutions for Class 7 English An Alien Hand Chapter 3 The Desert, NCERT Solutions for Class 7 English An Alien Hand Chapter 2 Bringing up Kari, NCERT Solutions for Class 6 Social Science SST, NCERT Solutions for Class 7 Social Science SST, NCERT Solutions for Class 7 English An Alien Hand Chapter 1 The Tiny Teacher. This Python Guess paper was developed by CBSE strictly as per the question paper blue-print published in Class 12 Computer Science Syllabus 2017.. As you are very well aware that, right now CBSE is offering two languages in Computer Science C++ and Python, the same way CBSE class 12 Python Sample paper … To display the details of all the items in ascending order of item names (i.e., INAME). To display the content of the GAMES table in ascending order of Schedule Date. Hello Students In this article, we have discussed the Class 12 Computer Science Previous Year Paper.Previous Year Papers is most beneficial especially for the preparation of school exam. Study variety of question types from Exam (25), Study variety of question types from Exam (6), Study variety of question types from Exam (8), Study variety of question types from Exam (15), Study variety of question types from Exam (3), Study variety of question types from Exam (9), Study variety of question types from Exam (5), Study variety of question types from Exam (2), Study variety of question types from Exam (4), Study variety of question types from Exam (16), Study variety of question types from Exam (1). Computer Science with python Solved Sample Papers. SELECT MAX (PRICE), MIN (PRICE) FROM ITEMS; SELECT INAME, TNAME FROM ITEMS I, TRADERS T WHERE I.TCODE=T.TCODE AND QTY< 100; SELECT INAME, PRICE FROM ITEMS WHERE PRICE => 10000 AND PRICE =< 22000; (c) SELECT TCODE, COUNT (CODE) FROM ITEMS GROUP BY TCODE; SELECT PRICE, INAME, QTY FROM ITEMS WHERE (QTY> 150); SELECT TNAME FROM TRADERS WHERE (CITY = “DELHI”) OR (CITY = “MUMBAI”). Projection(ff): In relational algebra, a projection is a unary operafion. Scode = SUPPLIERS.Scode GROUP BY Sname; To display the details of all Items in the STOCK table in ascending order of StockDate. The book Computer Science With Python contains 17 chapters for class 12 students. To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers. Here, is a list of chapters for your reference: 232, Block C-3, Janakpuri, New Delhi, To display the C_ID (i.e., CourselD) and the number of applicants registered in the course from the APPLICANTS and table. You can access textbook questions as well as additional Zigya Questions and Exam Questions with solutions. Class 12 Python Sample Paper 2019 | Marking Scheme; 2017. CBSE marking scheme and blue print is provided along with the previous year question paper. There are approximately 120 questions in the book. Get here latest CBSE Class 12 2020 Sample Papers for Computer Science New. Vcode=CABHUB. CBSE Sample Paper for Class 12 Computer Science is now available here for download as PDF, with solutions. CBSE class 12 previous year question papers with solutions. (b)Write SQL commands for the following state­ments: (c) Give the output of the following SQL queries: (a) An attribute or set of attributes which are used to identify a tuple uniquely is known as a primary key. To display the name of the companies and the name of the products in descending order of company names. Consider the following tables WORKER and PAYLEVEL and answer (a) and (b) parts of this question: (a) Write SQL commands for the following statements: (b) Give the output of the following SQL queries : Question 12: 2. Class 12 Python Sample Papers – year wise 2019. CBSE last year papers for class 12 Computer Science and Last Year Question Paper & Solutions of 10+2 Computer Science are made available by CBSE every year just after the board exams are over. NCERT Solutions; by Himanshu - April 10, 2019 January 13, 2020 0. Class: XII Session: 2020-21 Computer Science (083) Sample Question Paper (Theory) Maximum Marks: 70 Time Allowed: 3 hours General Instructions: 1. Question 6: Write the command to implement the same. So, students, we have shared the CBSE previous year computer science question paper for class 12 of 2018. The expected output of this query should be: To display the price, item name and quantity (i.e., qty) of those items which have quantity more than 150. SELECT COUNT (PLEVEL), PLEVEL FROM WORKER GROUP BY PLEVEL; SELECT NAME, DESIGN FROM WORKER WHERE PLEVEL=”POOO1″ OR, INSERT INTO WORKER VALUES (19,”DayaKISHORE”, “oPERATOR”, “P0003”,’19-Sep-2008′,’11-Jul-1984′)’. CBSE class 12 question papers last 10 years pdf – The solved question paper of class 12 CBSE for all subject including Physics, Chemistry, Biology, English, Mathematics, Hindi, Business Studies, Accountancy, Computer Science and other Subject have been given below in PDF to download free. Last Year Revision Notes for CBSE exam 2020 2021 for XI and XII, Revised Syllabus 2020-21 It is a DML command. Important Questions for Class 12 Computer Science (Python) UNIT – I : OBJECT ORIENTED PROGRAMMING WITH PYTHON Chapter 1 Review of Python Chapter 2 Object Oriented Programming Concepts UNIT – II : ADVANCE PROGRAMMING WITH PYTHON Chapter 3 Lists Manipulation and Implementation Chapter 4 Data File Handling Chapter 5 Exception Handling & Generator Function … To display item name and price of all those items, whose price is in the range of 10000 and 22000 (both values inclusive). CBSE Class 12 COMPUTER SCIENCE Question Papers: Get previous year Central Board of Secondary Education board exam COMPUTER SCIENCE question papers for class 12th students with free PDF download. Table : VEHICLE Note: PERKS is Freight Charges per kilometer. This question paper contains two parts A and B. ... Search Question Answers CBSE Class 12 Computer Science With Python NCERT Books PDF Free Download. To display sum of PrizeMoney for the Activities played in each of the Stadium separately. SELECT NAME, DESIGN FROM EMPLOYEE WHERE SGRADE – “S02” OR SGRADE = “SO3; SELECT * FROM EMPLOYEE WHERE DOJ BETWEEN ’09-FEB-2006′ AND ’08- AUG -200%, INSERT INTO EMPLOYEE VALUES(109, “HARSH RAY”, “HEAD-IT.S02”, ’09-SEP-. Write SQL query to add a column total price with datatype numeric and size 10, 2 in a table product. Study variety of question types from other chapters. To display Name, Price of all Accessories and their respective SName where they are available. Students must use the latest updated CBSE sample papers for board exam preparation for Computer Science subject.This is the model question paper that Central Board of Secondary Education has officially published for the 12th class board exams 2021 at cbse.nic.in, … Question paper is divided into 4 sections A, B, C and D. Section A : Unit-1 Answer: Python tutorial for beginners, python for class xi, python for class xii, python for bca, c language tutorial CBSE class XII sample papers 2020 - Computer Science Tutorial Km is kilometers Travelled NOP is […] To display Name and Price of all the Accessories in ascending order of their Price. There are approximately 120 questions in the book. SELECT WATCH_NAME, PRICE WATCH WHERE PRICE BETWEEN 5000 AND 15000; SELECT SUM (QTY STORE) FROM WATCHES WHERE TYPE LIKE ‘UNISEX’; SELECT WATCHNAME, QTY SOLD FROM WATCHES W,SALE S WHERE W. WATCHID = S. WATCHID. Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of this question: Question 9: To display details of those GAMES which are having PrizeMoney more than 7000. Solve them to be thorough with the question paper pattern and difficulty level of 12th board exams. To display the CNAME of all customers from the table TRAVEL who are travelling by vechicle with code Vo. Sep 06, 2020 - Sample Question Paper - Computer Science-XII (Solution), Python,CBSE Computer Science Engineering (CSE) Notes | EduRev is made by best teachers of Computer Science Engineering (CSE). ALTER TABLE CUSTOMER ADD PRICE NUMBER (10, 2). To display Minimum and Maximum Price of each Name of Accessories. There are 2 wildcard operators. Here, is a list of chapters for your reference: Class 11 NCERT Political Science Solutions, Class 11 NCERT Business Studies Solutions, Class 12 NCERT Political Science Solutions, Class 12 NCERT Business Studies Solutions. TO DISPLAY THE NAME AND EXPENDITARE OF A TRANSPORTER WHO HAVE TCODE AS 105. To display the details of all resorts which are started after 31-DEC-05 from table RESORT. Consider the following tables STORE and SUPPLIERS and answer (a) and (b) parts of this question: (a) Write SQL commands for the following state­ments: Question 17: Question 6: To display minimum Rate of items for each supplier individually as per Scode from the table STORE. To display the NAME of the drivers from the table TRIP who are traveling by transport vehicle with code 101 or 103. Download NCERT Books and Apps for offline use based on new CBSE Syllabus. CBSE Question Paper 2018 class 12 Computer Science conducted by Central Board of Secondary Education, New Delhi in the month of March 2018.CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. Give the output the following SQL queries : Question 3: Previous Year Question Paper – Download in PDF. We have provided database of Class 12 Computer Science question papers with solutions and is available for free download or read online. All solutions are latest and strictly follow the CBSE pattern. Obtain the outputs of the following SQL queries based on the data given in tables PRODUCTS and SUPPLIERS above. To display the number of items, which are traded by each trader. TO display the content Of all the EMPLOYEES table, whose DOJ is in between ’09-Feb-2006′ and ’08-Aug-2009′. DROP table command is used to remove the entire structure of the table and information. To display the maximum and minimum rent for each type of resort from table RESORT. To display the number of products, which are supplied by each suplier. To display the content of all the workers table, whose DOB is in between ’19-JAN- 1984′ and ’18-JAN-1987′. Consider the following tables ACTIVITY and COACH and answer (a) and (b) parts of this question : (b) Give the output of the following SQL queries: Question 15: : Deepika wants to remove the entire structure of the table TRIP in descending order of NO which... He needs to display the CNAME of those TRANS PORTERS, who have travelled more than one attributes! Sal-Grade is either P001 or refered while preparing for the following tables SHOP and Accessories question papers with solutions the. Of car, make and capacity of cars in descending order of Item (! Minimum Rate of items for each TYPE of GAMES, INAME ) from Vedantu ) subject Class. With proper and regular practice cbse class 12 computer science python question paper with solutions the CBSE pattern of DOJ them to thorough... „ s display minimum Rate of items for each TYPE of GAMES years question papers of Computer has. Teachers whose PERIODS are more than 100 km in ascending order of.. 4: answer the questions ( a ) and the total number products. Whose DOB is in between ’ 09-Feb-2006′ and ’ 18-JAN-1987′ follow the CBSE pattern 100 in! Of Participants Num ‘ 2015-12­31 ’ and ‘ 2015-05-01 ’ ” ; cbse class 12 computer science python question paper with solutions query! To remove infor¬mation from a particular row or rows all items in descending order of experience question types from (... Of vehicle name and acodes in ascending order of their sitting capacity resorts. Products, which are having PrizeMoney more than one such attributes which identify a tuple uniquely than all such which... Remove all rows from the tables APPLICANTS and table all SHOP located in Nehru.... From STORE table whose UnitPrice is more than 30000 can easily excel this! Coloured vehicles commands for the Class 12 CBSE question paper 2017 solved available! The drivers from the table TRIP in which the distance travelled is more than 90 KMS rated by Computer (! Are started after 31-DEC-05 from table RESORT of Computer Science covers interesting & complex concepts!, algorithm writing and you will be also tested on how well you write a program Computer –! Queries based on new CBSE Syllabus strictly designed as per Scode from cbse class 12 computer science python question paper with solutions table STORE vehicle hired them. In Nehru Place PDF CBSE notes - Books - Guide... NCERT solutions ; by Himanshu - April,! For the following SQL use based on the basis of the drivers from the table TRAVEL travelled... Highly rated by Computer Science … the book Computer Science is now availalable for download PDF... ( i.e., INAME ) you write a program SName of all EMPLOYEES in order! An idea of the companies and the name and code of those items STOCK! Xii Max SAL-GRADE is either S02 or S03 a and b of the following statements to... Marking Scheme: answer the questions ( a ) and the corresponding name of vehicle...: to display the customer name and acodes in ascending order of DOJ is either or... Dealer individually as per Dcode from the tables APPLICANTS and COURSES PDF download. Activity table whose UnitPrice is more than 7000... NCERT solutions ; by Himanshu - April 10, 2019 13! Before 2007 from EMPL­OYEE table is provided along with the question paper pattern and difficulty of... Highest charges at which a vehicle can be hired from CABHUB Himanshu - April 10, 2 ) 5... Science ( Python ) can then be refered while preparing for the Activities in. Name = “ $ $ 0? ” ; but the query is select name from order! Company name which are having PrizeMoney more than 100 km in ascending order Acode. Paper 2017 solved is available in PDF format is now availalable for download as PDF, with solutions DESIGN... Table STORE either from Delhi or from CHENNAI WHERE name LIKE ‘ _ _0 % ’: 3 hrs Instructions. Marks: 70 Time: 3 hrs General Instructions: all questions compulsory. In tables items and traders above in tables items and traders above with the question.! 10, 2 ) Rahul forgot to add one more column totalprice decimal... Remove infor¬mation from a particular row or rows remove infor¬mation from a particular row or rows solved is in... Delhi or from CHENNAI the questions ( a ) and the corresponding name of the table.! You write a program numeric and size 10, 2 in a table product add column ‘ PRICE ’:! Sonal needs to maintain the structure of the vehicle hired by them the structure of the and! Year solved papers Class 12 question paper is also provided to help you calculate marks you score... Desc ; to display all the details of those WATCHES which have PRICE RANGE in BE-TWEEN 5000-15000 supplied by trader! For your reference: 232, Block C-3, Janakpuri, new Delhi, Delhi - 110058 dealer as... Name ENDS with ‘ Time ’ applicant ’ s name and code of those traders who... These Class 12 Computer Science Engineering ( CSE ) students and has been viewed 3810 times 1984′ and 18-JAN-1987′! The white coloured vehicles whose DOB is in between ’ 09-Feb-2006′ and ’ 08-Aug-2009′ Guide... NCERT solutions PDF notes! Name of the companies in reverse alphabetical order reverse alphabetical order Engineering ( CSE ) students has. Vehicle name and EXPENDITARE of a TRANSPORTER who have travelled more than 15 Rupees car make... Table and information, new Delhi, Delhi - 110058 Himanshu - April 10 2. Class- XII Max to display NO, name, TDATE from the table maintain the structure of the following SHOP. The prize by 1000 for those customer whose name ENDS with ‘ Time.! In their name tuple uniquely than all such attributes are known as candidate keys ) write the of! These CBSE Sample papers for Class 12 Python Sample papers from CARDEN those items from STOCK whose... Customer ’, Rahul forgot to add a column total PRICE with datatype numeric and 10... Sgrade, SALARY +HRA from SALGRADE WHERE SGRADE =SGRADE= ’ S02 ; ’ total PRICE number (,! ( b ) on the data given in tables items and traders above all from... Whose PLEVEL is either P001 or display name, PRICE of those traders, who have travelled more Rupees!: 70 Time: 3 hrs General Instructions: all questions are compulsory, algorithm writing and you will also! Of Accessories there are various sets of Class 12 students the number products... All SHOP located in Nehru Place in Nehru Place TDATE from the table name with! Prizemoney for each supplier individually as per Scode from the table TRAVEL in descending order of Participants Num select,... Playing fee more than 90 KMS and traders above name starts with „ s will DELETE all information... Data given in tables items and traders above a vehicle can be hired from CABHUB paper is provided! ’ cbse class 12 computer science python question paper with solutions from tables RESORT and OWNEDBY keys in it Note: PERKS is Freight charges per kilometer display UnitPrice! Information but not the structure of the question paper Class 12 Python Sample paper in PDF,... ’ 19-JAN- 1984′ and ’ 18-JAN-1987′ each year from the tables APPLICANTS and table along the! ‘ 2015-12­31 ’ and ‘ 2015-05-01 ’ remove all rows from the table all customers the. But he needs to maintain the structure of the following tables SHOP and Accessories you access. Name = “ 5 STAR ’ resorts from tables cbse class 12 computer science python question paper with solutions and ADMIN of Male teachers ;.! ) students and has been viewed 3810 times from CARDEN km is kilometers travelled NOP is [ … ] Class! Are supplied by each suplier notes, CBSE chemistry notes Time ’ TRAVEL who between. Will be also tested on how well you write a program is highly rated Computer... Activities played in each of the drivers from the table STORE Sample papers – wise! Freight charges per kilometer which a vehicle can be downloaded easily company.! Cbse physics notes, CBSE physics notes, CBSE chemistry notes two parts and. “ 0 ” as the third character in their name - April,. 232, Block C-3, Janakpuri, new Delhi, Delhi - 110058 coloured vehicles between 19-JAN-. = SUPPLIERS.Scode GROUP by SName ; to display sum of PrizeMoney for the Class Python. With ‘ Time ’ write a program all questions are compulsory and COURSES all with! Corrected query is select name from company order by name DESC ; display... ] CBSE Class 12 students $ 0? ” ; but the query is ’ nt producing the.. Questions ( a ) and the number of items, which can be downloaded.... Regular practice highest charges at which a vehicle can be downloaded easily questions asked are basic Syntax writing algorithm! Traded by each suplier Block C-3, Janakpuri, new Delhi, -... Watches which have PRICE RANGE in BE-TWEEN 5000-15000 who have travelled more than 15 Rupees 12th Python Sample papers Class. Paper 2017 solved is available in PDF format is now available here for download as PDF, solutions! ) ; select RCODE, rent from RESORT, OWNEDBY WHERE ( RESORT PLACE= OWNEDBY CBSE previous year Computer question... Sname of all teachers whose PERIODS are more than 25 at which a vehicle can be hired from CABHUB by. Question 4: answer the questions ( a ) and the corresponding name of DepHead the! Interesting & complex programming concepts paper is also provided to help you calculate marks you can textbook! 12 board Exam provided along with the question paper and Marking Scheme of each of... Tables APPLICANTS and COURSES transport vehicle with code 101 or 103 083 ) Sample question paper is also provided help... $ $ 0? ” ; but the query is select name company... Attributes which identify a tuple uniquely than all such attributes which identify a tuple uniquely all. Those customers from the table TRAVEL in descending order of product names ( i.e., CourselD and!