Guess Paper – 2011
CBSE Class – XI
(Informatics Practices)

• Subject Code: IP (065)
• Marks-70

1. Answer the following questions:
(a) What is operating system? Give example.2
(b) What is application software? Give example. 2
(c) What is port? Name some of port types.2
(d) What is memory card? Discuss briefly its type.2
(e) What are the two categories of printers? Which type of printer is found to be more speedy? 2

2. Write down the short notes on the followings: 5×2
(i) Bar code reader
(ii) Computer virus
(iii) Complier
(iv) Bluetooth
(v)DVD

3. Explain the following terms with example:5×2
(i) Primary Key
(ii) DDL
(iii) Where Clause
(iv) He Like Clause
(v) Update Command

4. (i)Create the table-Customer as per following structure:2

(ii) Insert six(6) rows into above table. 2

Write the queries for the above table:
(iii) To increase amount by adding another Rs.100 where amount is less than 1000.1
(iv) To modify the name of the customer of cust_id=5 to Raja.1
(v) To arrange the data of the above table in descending order of amount.1
(vi) To display customer details whose name contains ‘A’ as third alphabet.1
(vii) To display customer’s name who don’t have their amount inn the range of 1000.00 to 2000.00.1
(vii) To remove the entire contents of customers those who have no any address. 1

5. Consider the following table-EMP and write the outputs for the Q.No.(a) to Q.No.(j) 10×1

(a) SELECT COUNT(*) FROM EMP WHERE DEPTNO=20;
(b) SELECT SUM(COMM) FROM EMP WHERE DEPTNO=30;
(c) SELECT MOD(SALARY,10) FROM EMP WHERE DEPTNO=20;
(d) SELECT SUBSTR(ENAME,2,4) FROM WHERE DEPTNO=20;
(e) SELECT MIN(SAL) FROM EMP WHERE DEPTNO=10;
(f) SELECT AVG(COMM) FROM EMP WHERE COMM.<1500;
(g) SELECT COUNT(DISTINCT JOB) FROM EMP;
(h) SELECT SUM(SALARY+COMM) FROM EMP WHERE JOB=”MANAGER’;
(i) SELECT CONCAT(ENAME, JOB) FROM EMP WHERE JOB=’ANALYST’;
(j) SELECT MAX(SALARY) FROM EMP WHERE COMM. IS NULL;

6. Answer the following questions: 10×1
(i) What is constraint?
(ii) Which command is used to list the structure of a table?
(iii) What is the function of order by?
(iv) Define function?
(v) Select char(77,121,83,81,76): What will be the output?
(vi) Write command to display name of the weekday.
(vii) Write command to display the system date.
(viii) Write a command to display first three characters of ‘Information’.
(ix) A numeric data field price stored a value 40409.97. Write command in SQL to round off the price up to 1 decimal place.
(x) Write the command to extract last five letters from string=’ Student’s behavior should be good’.

7. Write the output of the followings:10×1
(a) Select length(upper(‘We are here to study’));
(b) Select substr(trim(‘Informatics Practices’),12,12);
(c) Select concat(concat(‘Infrom’,’atics’),’Practices’));
(d) Select round(29.84,1),round(29.84,-1);
(e) Select right(lower(‘select MySQL’),5);
(f) Select InStr(‘Display the position’,’he’);
(g) Select sign(-15 + 15);
(h) Select truncate(75.796,-2);
(i) Select Date(Curdate);
(j) Select NOW();