{"id":1732,"date":"2022-01-05T19:47:35","date_gmt":"2022-01-05T14:17:35","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1732"},"modified":"2022-05-27T22:32:39","modified_gmt":"2022-05-27T17:02:39","slug":"term-2-sample-paper-class-12-computer-science","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/term-2-sample-paper-class-12-computer-science\/","title":{"rendered":"Term 2 Sample Paper Class 12 Computer Science (083)"},"content":{"rendered":"<h3><span style=\"color: #000000;\">Term 2 Sample Paper Class 12 Computer Science (083)<\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>Set-1<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">Max. Marks: 35 <\/span><\/p>\n<p><span style=\"color: #000000;\">Duration: 2:00 Hrs<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">General Instructions:<\/span><\/strong><\/p>\n<p><em><strong><span style=\"color: #000000;\">1. This question paper contains two parts A and B. Each part is compulsory.<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">2. Part-A has 8 MCQ questions of 1 mark each, Attempts any 5 questions.<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">3. Part \u2013 B has three sections<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">Section-I is short answer questions of 2 marks each.<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">Section-II is long answer questions of 3 marks each.<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">Section-III is very long answer questions of 4 marks.<\/span><\/strong><\/em><\/p>\n<p><em><strong><span style=\"color: #000000;\">4. All programming questions are to be answered using Python Language only.<\/span><\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">PART \u2013 A<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #000000;\">Q. Select the most appropriate option out of the options given for each question. Attempt any 5 questions from no 1 to 8.<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">1. If a user tries to remove an element from empty Stack, it is called-<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Empty Collection <\/span><\/p>\n<p><span style=\"color: #000000;\">b)Overflow <\/span><\/p>\n<p><span style=\"color: #000000;\">c)Underflow <\/span><\/p>\n<p><span style=\"color: #000000;\">d)Garbage Collection<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:c)Underflow <\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">2. Which of the following is application of Stack?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)One Way Traffic <\/span><\/p>\n<p><span style=\"color: #000000;\">b)A line of ticket seeking people<\/span><\/p>\n<p><span style=\"color: #000000;\">c)Reversing the order of items <\/span><\/p>\n<p><span style=\"color: #000000;\">d)Printer shared among four computers<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:c)Reversing the order of items <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">3. Consider the following operation performed on a stack of size 5.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Push(1); Pop();Push(2);Push(3); Pop(); Push(4);Pop();Pop();Push(5);<\/span><\/p>\n<p><span style=\"color: #000000;\">After the completion of all operation, the number of elements present in stack are:<\/span><\/p>\n<p><span style=\"color: #000000;\">a)1 <\/span><\/p>\n<p><span style=\"color: #000000;\">b)2 <\/span><\/p>\n<p><span style=\"color: #000000;\">c)3 <\/span><\/p>\n<p><span style=\"color: #000000;\">d)4<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans: d)4<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">4. Network in which every computer is capable of playing the role of a client, or a server or both at same time is called-<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)local area network <\/span><\/p>\n<p><span style=\"color: #000000;\">b)peer-to-peer network<\/span><\/p>\n<p><span style=\"color: #000000;\">c)dedicated server network <\/span><\/p>\n<p><span style=\"color: #000000;\">d)wide area network<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:b)peer-to-peer network<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">5. In computer, converting a digital signal in to an analog signal is called-<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)modulation <\/span><\/p>\n<p><span style=\"color: #000000;\">b)demodulation <\/span><\/p>\n<p><span style=\"color: #000000;\">c)conversion <\/span><\/p>\n<p><span style=\"color: #000000;\">d)transformation<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:a)modulation <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">6. Which of the following keywords will you use in the following query to display the unique values of the column dept_name?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)all <\/span><\/p>\n<p><span style=\"color: #000000;\">b)from <\/span><\/p>\n<p><span style=\"color: #000000;\">c)distinct <\/span><\/p>\n<p><span style=\"color: #000000;\">d)unique<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:c)distinct <\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">7. The pattern \u2018_ _ _\u2019 matches any string of _______ three characters. \u2018_ _ _%\u2019 matches and string of _________ three characters.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)Atleast, Exactly <\/span><\/p>\n<p><span style=\"color: #000000;\">b)Exactly, Atleast <\/span><\/p>\n<p><span style=\"color: #000000;\">c)Atleast, All <\/span><\/p>\n<p><span style=\"color: #000000;\">d)All, Exactly<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans: b)Exactly, Atleast <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">8. All aggregate functions except____________ ignore null values in their input collection.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a)count(attribute) <\/span><\/p>\n<p><span style=\"color: #000000;\">b)count(*) <\/span><\/p>\n<p><span style=\"color: #000000;\">c)avg <\/span><\/p>\n<p><span style=\"color: #000000;\">d)none of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans: b)count(*) <\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Part B (SECTION &#8211; I)<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #000000;\">9. Expand the following-<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) SMTP<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) DHCP<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) HTTP<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) TCP<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">i) SMTP : Simple Mail Transfer Protocol<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) DHCP: Dynamic Host Configuration Protocol<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) HTTP:Hypertext Transfer Protocol<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) TCP: Transmission Control Protocol<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>10. Define Web-Hosting?<\/strong> <\/span><\/p>\n<p>Ans:\u00a0 <span style=\"color: #000000;\">Web hosting\u00a0is the process of renting or buying space to house a website on the World Wide Web.<\/span><\/p>\n<p><span style=\"color: #000000;\">OR<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Give difference between Video Conferencing and Chat.<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans: Chatting is textual conversation between 2 or more members over the internet. Video conferencing is a real time video conversation over the internet.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">11. Give difference between CHAR and VARCHAR. Give Example.<\/span><\/strong><\/p>\n<p>Ans:<\/p>\n<p><span style=\"color: #000000;\">The basic difference between Char and Varchar is that:<\/span><\/p>\n<p><span style=\"color: #000000;\">char stores only fixed-length character string data types whereas varchar stores variable-length string where an upper limit of length is specified.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">12. What do you understand by the terms Candidate Key? What is Cardinality?<\/span><\/strong><\/p>\n<p>Ans: <span style=\"color: #000000;\">Candidate Key: A candidate key is the one that is capable of becoming primary key. i.e., a field or attribute that has unique value for each row in the relation.<\/span><\/p>\n<p><span style=\"color: #000000;\">Cardinality: It refers to the total number of tuple in the table.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">13. The SQL SELECT provides clauses for sorting data and for grouping results. Write the names of clauses for these.<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans: The ORDER BY clause of SQL SELECT statement allows to sort the data of result set. The GROUP BY clause of SQL SELECT statement allows to create summarized results of grouped result data from table.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Part-B (SECTION &#8211; II)<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #000000;\">14. Each node of a Stack contains the following information: PINCODE and NAME of city.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Write a PUSHCITY() function to implement push on stack like operation to add a node to Stack.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">OR<\/span><\/p>\n<p><span style=\"color: #000000;\">Write a POPCITY() function to implement pop from stack like operation to remove a node(same as above) from Stack.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">15. A department is considering to maintain their worker data using SQL to stroe the data. As a Database Administrator, Karan has decided that:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Name of the database \u2013Department<\/span><\/p>\n<p><span style=\"color: #000000;\">Name of the table \u2013Worker<\/span><\/p>\n<p><span style=\"color: #000000;\">The attributes of Workeer are as follows:<\/span><\/p>\n<p><span style=\"color: #000000;\">WORKER_ID \u2013 CHARACTER OF SIZE 3<\/span><\/p>\n<p><span style=\"color: #000000;\">FIRST_NAME \u2013 CHARACTER OF SIZE 10<\/span><\/p>\n<p><span style=\"color: #000000;\">LAST_NAME \u2013 CHARACTER OF SIZE 10<\/span><\/p>\n<p><span style=\"color: #000000;\">SALARY \u2013 NUMERIC<\/span><\/p>\n<p><span style=\"color: #000000;\">JOINING_DATE \u2013 DATE<\/span><\/p>\n<p>&nbsp;<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">WORKER_ID<\/span><\/strong><\/td>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">FIRST_NAME<\/span><\/strong><\/td>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">LAST_NAME<\/span><\/strong><\/td>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">SALARY<\/span><\/strong><\/td>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">JOINING_DATE<\/span><\/strong><\/td>\n<td style=\"width: 16.6667%;\"><strong><span style=\"color: #000000;\">DEPARTMENT<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">001<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">MONIKA<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">ARORA<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">100000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-02-20<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">HR<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">002<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">NIHARIKA<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">DIWAN<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">80000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-06-11<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Admin<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">003<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">VISHAL<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">SINGHAL<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">300000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-02-20<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">HR<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">004<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">AMITABH<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">SINGH<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">500000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-02-20<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Admin<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">005<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">VIVEK<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">BHATI<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">500000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-06-11<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Admin<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">006<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">VIPUL<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">DIWAN<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">200000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-06-11<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Account<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">007<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">SATISH<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">KUMAR<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">75000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-02-20<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Account<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">008<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">MONIKA<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">CHAUHAN<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">80000<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">2014-04-11<\/span><\/td>\n<td style=\"width: 16.6667%;\"><span style=\"color: #000000;\">Admin<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Attempt any 3 of the following-<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\"><strong>i)\u00a0Karan wants to remove all the data from table WORKER from the database department. Which command will he use from the following:<\/strong> <\/span><\/p>\n<p><span style=\"color: #000000;\">a) DELETE FROM WORKER;<\/span><\/p>\n<p><span style=\"color: #000000;\"> b) DROP TABLE WORKER; <\/span><\/p>\n<p><span style=\"color: #000000;\">c) DROP DATABASE Department; <\/span><\/p>\n<p><span style=\"color: #000000;\">d) DELETE * FROM WORKER;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) Identify the attribute best suitable to be declared as a primary key.<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">iii) Karan wants to increase the size of the FIRST_NAME column from 10 to 20 characters. Write an appropriate query to change the size.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">iv) Write a query to display the structure of the table Worker, i.e. name of the attribute and their respective data types.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">16.\u00a0 Write the output of the SQL queries (i) to (iii) based on the table: Employee<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: Employee<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">ECODE<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">NAME<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">DEPT<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">DOB<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">GENDER<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">DESIGNATION<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">SALARY<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">101<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">SUNITA<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">SALES<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">06-06-1995<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">MANAGER<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">25000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">102<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">NEERU<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">OFFICE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">05-07-1993<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">CLERK<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">12000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">103<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">RAJU<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">PURCHASE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">05-06-1994<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">MANAGER<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">26000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">104<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">NEHA<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">OFFICE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">08-08-1995<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">ACCOUNTANT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">18000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">105<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">NISHANT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">OFFICE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">08-10-1995<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">CLERK<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">10000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">106<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">VINOD<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">OFFICE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">12-12-1994<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">CLERK<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">10000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">i)\u00a0SELECT SUM(SALARY) FROM EMPLOYEE WHERE GENDER=\u2019F\u2019 AND DEPT =\u2019SALES\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) SELECT MAX(DOB), MIN(DOB) FROM EMPLOYEE;<\/span><\/p>\n<p><span style=\"color: #000000;\">iii)\u00a0SELECT GENDER, COUNT(*) FROM EMPLOYEE GROUP BY GENDER;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">17. Consider the table TEACHER given below. Write commands in SQL for (i) to (iii)<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong>Table: TEACHER<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 6.16449%;\"><strong><span style=\"color: #000000;\">ID<\/span><\/strong><\/td>\n<td style=\"width: 13.9221%;\"><strong><span style=\"color: #000000;\">NAME<\/span><\/strong><\/td>\n<td style=\"width: 22.7705%;\"><strong><span style=\"color: #000000;\">DEPARTMENT<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">HIREDATE<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">CATEGORY<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">GENDER<\/span><\/strong><\/td>\n<td style=\"width: 14.2857%;\"><strong><span style=\"color: #000000;\">SALARY<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">1<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">TANIYA<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">SOCIAL STUDIES<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1994-03-17<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">TGT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">25000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">2<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">ABHISHEK<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">ART<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1990-12-02<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">PRT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">20000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">SANJANA<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">ENGLISH<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1980-05-16<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">PGT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">30000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">VISHWAJEET<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">ENGLISH<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1989-10-16<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">TGT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">25000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">AMAN<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">HINDI<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1990-01-08<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">PRT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">22000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">6<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">PRITAM<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">MATH<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1980-03-17<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">PRT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">21000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">7<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">RAJKUMAR<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">SCIENCE<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1994-02-09<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">TGT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">M<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">27000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 6.16449%;\"><span style=\"color: #000000;\">8<\/span><\/td>\n<td style=\"width: 13.9221%;\"><span style=\"color: #000000;\">SHEETAL<\/span><\/td>\n<td style=\"width: 22.7705%;\"><span style=\"color: #000000;\">MATH<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">1980-11-17<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">TGT<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">F<\/span><\/td>\n<td style=\"width: 14.2857%;\"><span style=\"color: #000000;\">24500<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Attempt the following &#8211;<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) To display all information about teachers of Female PGT Teachers.<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) To list names, departments and date of hiring of all the teachers in descending order of date of joining.<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) To count the number of teachers and sum of their salary department wise.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Part B (SECTION &#8211; III)<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">18. Success Institution is an educational organisation. It is planning to set up its India campus at Nepal with its head office at Mumbai. The Nepal campus has 4 main buildings- ADMIN, ENGINEERING, BUSINESS and MEDIA.<\/span><\/p>\n<p><span style=\"color: #000000;\">You as a network expert have to suggest the best network related solutions for their problems raised in (i) to (iv), keeping in mind the distance between the buildings and other given parameters.<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Shortest distance between various buildings.<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong><span style=\"color: #000000;\">Buildings<\/span><\/strong><\/td>\n<td style=\"width: 50%;\"><strong><span style=\"color: #000000;\">Distance<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ADMIN to ENGINEERING<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">50 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ADMIN to BUSINESS<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">80 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ADMIN to MEDIA\u00a0<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">45 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ENGINEERING to BUSINESS\u00a0<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">60 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ENGINEERING to MEDIA\u00a0<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">145 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">BUSINESS to MEDIA\u00a0<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">50 M<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">Mumbai Head Office To Nepal Campus\u00a0<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">2175 KM<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Number of Computers installed at various buildings are as follows:<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong><span style=\"color: #000000;\">Building<\/span><\/strong><\/td>\n<td style=\"width: 50%;\"><strong><span style=\"color: #000000;\">No. of Computers installed<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ADMIN<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">20<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">ENGINEERING<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">150<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">BUSINESS<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">35<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">MUMBAI HEAD OFFICE<\/span><\/td>\n<td style=\"width: 50%;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">i) Suggest the most appropriate location of the server inside the Nepal Campus(out of 4 buildings), to get the best connectivity for maximum number of computers. Justify your answer.<\/span><\/p>\n<p><span style=\"color: #000000;\">ii)\u00a0Suggest and draw the cable layout to efficiently connect various buildings within the Nepal Campus for connecting the computers.<\/span><\/p>\n<p><span style=\"color: #000000;\">iii)\u00a0Which hardware device will you suggest to be procured by the company to be installed to protect and control the Internet uses within the campus.<\/span><\/p>\n<p><span style=\"color: #000000;\">iv)\u00a0Which of the following will you suggest to establish the online face-to-face communication between the people in the ADMIN office of Nepal Campus and Mumbai Head Office?<\/span><\/p>\n<p><span style=\"color: #000000;\">a)Cable TV <\/span><\/p>\n<p><span style=\"color: #000000;\">b)E-Mail <\/span><\/p>\n<p><span style=\"color: #000000;\">c)Video Conferencing <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Text Chat<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">19. Consider the tables Watches and Sale given below and answer the following questions.<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: Watches<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 20%;\"><strong><span style=\"color: #000000;\">Watchid<\/span><\/strong><\/td>\n<td style=\"width: 20%;\"><strong><span style=\"color: #000000;\">Watch_Name<\/span><\/strong><\/td>\n<td style=\"width: 20%;\"><strong><span style=\"color: #000000;\">Price<\/span><\/strong><\/td>\n<td style=\"width: 20%;\"><strong><span style=\"color: #000000;\">Type<\/span><\/strong><\/td>\n<td style=\"width: 20%;\"><strong><span style=\"color: #000000;\">Qty_Store<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">W001<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">High Time<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">10000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Unisex<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">100<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">W002<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Life Time<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">15000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Ladies<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">150<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">W003<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Wave<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">20000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Gents<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">200<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">W004<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">High Fashion<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">7000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Unisex<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">250<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">W005<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Golden Time<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">25000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Gents<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">100<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: Sale<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%;\"><strong><span style=\"color: #000000;\">Watchid<\/span><\/strong><\/td>\n<td style=\"width: 33.3333%;\"><strong><span style=\"color: #000000;\">Qty_Sold<\/span><\/strong><\/td>\n<td style=\"width: 33.3333%;\"><strong><span style=\"color: #000000;\">Quarter<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W001<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">10<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W003<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W002<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">20<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W003<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">10<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W001<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">15<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W002<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">20<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W005<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">10<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">W003<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">15<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Write the SQL command for the following statements:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) To display total quantity in store of unisex type watches.<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) To display watch name and their quantity sold in first quarter.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Give the output for the following SQL queries:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) SELECT WATCH_NAME, PRICE , TYPE FROM WATCHES W, SALE S WHERE W.WATCHID=S.WATCHID;<\/span><\/p>\n<p><span style=\"color: #000000;\">ii)\u00a0SELECT WATCH_NAME, QTY_STORE , SUM(QTY_SOLD), FROM WATCHES W, SALE S WHERE W.WATCHID = S.WATCHID GROUP BY S.WATCHID<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Term 2 Sample Paper Class 12 Computer Science (083) Set-1 Max. Marks: 35 Duration: 2:00 Hrs General Instructions: 1. This question paper contains two parts A and B. Each part is compulsory. 2. Part-A has 8 MCQ questions of 1 mark each, Attempts any 5 questions. 3. Part \u2013 B has three sections Section-I is [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,20],"tags":[],"class_list":["post-1732","post","type-post","status-publish","format-standard","hentry","category-cbse-sample-papers-class-12","category-cbse-computer-science-with-python-class-12"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1732"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1732\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}