CBSE Guess > Papers > Important Questions > Class XII > 2012 > Computer Science > Computer Science Vinay Kumar Srivastava Computer Science- CBSE CLASS XII c) Consider the table given below, write command in SQL for (1) to (4) and output for (5) to (8). For - 1 Marks Table : STUDENT
( 1 ) To display the name and stream of all students who are in class 12. Ans: (1) SELECT name,stream (2) SELECT DISTINCT stream (3) SELECT name, AvgMark, Grade (4) SELECT name (5) 2500 (6) 2 (7) 11C (8) 1000 Q . 6 Answer the following question. For - 2 Marks a) Write an SQL query to create the table “Club“ with the following structure- For - 2 Marks
Ans: b) In a database there are two tables ‘Doctors’ and ‘Patients’ shown below- For - 2 Marks Table: Doctors
Table: Patients
i) Name the column(s) that can be used to retrieve data from both the tables. Ans : i) DId ( from Doctors and Patients table) c) Consider the tables given below- For - 6 Marks Table : Staff
Table : Salary
With reference to above tables, write commands in SQL for (i) and (ii) and output for (iii)- i)To display name of all the staff that are in Sales having more than 9 years experience and commission percentage is more than 8.ii)To display average salary of staff working in Finance department. (Salary=Basic+allowance) iii) SELECT name, Basic from Staff, Salary WHERE Dept=’Sales’ and Staff.StaffId=Salary.StaffId; Ans: i) SELECT Name ii) SELECT AVG(Basic+Allowance) AS “Average Salary” iii) Noopur 14000 Q.7 a) What is e-Governance? Name any two major e-Governance projects in India. For - 2 Marks b) What is database connectivity? For - 1 Marks Ans: Database Connectivity refers to a programming interface through that front end access a database on a backend via same means c) Mr. Anubhav is working as a programmer in a Hotel. He wants to create the forms to add the details of customers. Choose appropriate controls from Text Field, Label, Radio Button, Check Box, List Box, Combo Box, and Command Button and write in the third column. For - 2 Marks
Ans:
Prepared By: Mr. Pradumna Singh |
Warning: include(../../../../../120_60_others.php): Failed to open stream: No such file or directory in /home/cbseguess/public_html/papers/cbse_important_questions/xii/2012/computer_science/computer_science11.php on line 450 Warning: include(): Failed opening '../../../../../120_60_others.php' for inclusion (include_path='.:/opt/cpanel/ea-php83/root/usr/share/pear') in /home/cbseguess/public_html/papers/cbse_important_questions/xii/2012/computer_science/computer_science11.php on line 450 |