Set 1 - Class webSite



Set 1

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours        Max. Marks: 30

1. Write a menu driven program in PYTHON.       12

Program to count the number of uppercase and lowercase characters in the text file

I. Create Text File

II. Display the text file

III. Read and display file Backwards

IV. Display each character in separate line

V. Exit

2. Consider the two tables given below and the write the commands: 

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a)   To display the name, hiredate of all employees hired after Jan 10th 1980.     1

(b)  To display the department no., highest and lowest salary for each department. 1

(c)  To display the name of the employees whose job is in Clerk, Salesman, President.   1 

(d)   To display the name and department name of all employees.   1

(e)  To display the name and salary of all the employees in the alphabetical order of name. 1 

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(A,B,C,D)= ∑(3,4,5,6,7, 13,15)

Set 2

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.     12  

Create a class book with title, author, publisher and year as data members. Write a menu driven program to create a file "book.dat" to store books details and perform the following operations:

I. Append record

II. Search a record for a give title

III. Display the file contents in the tabular form with appropriate headings

IV. Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a)  To display the employee name, department name and department number.                 1

(b)  To display the ename, dname and loc of all employee who earn commission.               1

(c)  To display the ename and dname of all the employees whose name starts with A.         1

(d)  To display the name, department number for all employees who work as Clerks and

earns a salary more than 1000        1

(e)To display the employee number and employee name in the descending order of salary  1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

H(U,V,W,Z) = Σ(0, 1, 4, 5, 6, 7, 11, 12, 13, 14, 15)

Set 3

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours        Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Program to perform the following operations on a text file :

i. Create Text File

ii. Display the text file

iii. Count two Words given by the user

iv. Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a) Display all the records (all columns) from table Emp. 1

(b) Display EName and Dname of all employees who are working in New York 1

(c) Display Ename, Sal and Sal added with Comm from table Emp 1

(d) Display EName joined with Job with heading “Employee”, Sal*12 as “Total Salary” from

table Emp. 1

(e) Display distinct Sal of employees from table Emp 1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(P, Q, R, S) = Σ(1, 2, 3, 5,6, 7, 9, 11, 12, 13, 15)

Set 4

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Write a program in PYTHON to create a binary file “House.dat” with the following structure:

Name, Class, Section and Average Marks and to do the following functions:

i) To append a record

ii) To delete all records of a given class .

iii) To Display the data in tabular form.

iv) Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a) Write a Query to display the name of employee who is having ‘L’ as any

alphabet of the name. 1

(b) Write a query to display the current system date. 1

(c) Create a query that produces display in the following format 1

Earns $ Monthly and working as

(d) Write a query to display the EName and DeptNo and DName for all

employees using tables Emp and Dept. 1

(e) Write a Query to display employee name, department name and location 1

of all employees who have manager number between 7500 and 7900.

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(U,V,W,Z)=((0,1,2,4,5,6,8,10)

Set 5

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Program to perform the following operations on the text file:

i. Create Text File

ii. Display the text file

iii. Count two alphabets given by the user

iv. Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a) Write a Query to Display the employee names in descending order 1

(b) Write a Query to Display location and number of employees at each location 1

(c) Write a Query to Display the Sum, Average, Highest and Lowest salary of

the employees grouped by department number and sub-grouped by job. 1

(d) Write a query to display the difference of Highest and lowest salary of

each department having salary > 2000. 1

(e) Write a query to display employee name and salary of those who either

work in department 10 or have salary greater than 1200 1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(A,B,C,D)=((0,1,2,4,5,6,8,10)

Set 6

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

1. Write a menu driven program in PYTHON..       12

Program to perform the following operations on the text file:

i. Create Text File

ii. Display the text file and

iii. count the number of uppercase and lowercase characters in the text file

iv. Exit

2. Consider the two tables given below and the write the commands: 

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a)   To display the name, hiredate of all employee hired after employee Jan 10th 1980.     1

(b)  To display the department no., highest and lowest salary for each department.   1

(c)  To display the name of the employees who is working as Clerk or Salesman or President. 1   

(d)   To display the name of the employees who are earning more than the average salary.  1

(e)  To display the name and salary of all the employees in the alphabetical order of name. 1 

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F (A, B, C, D) =∑(0, l, 2, 4, 5, 8, 9, 10, 11)

Set 7

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Create and display a file “ITEM.DAT” with the following information:

INo, IName, Quantity, Rate, Amount

Include functions to perform the following:

i) Modify the record for a given INo.

ii) Search on a given INo and display appropriate messages

iii) Display the data in tabular form.

iv) Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a) Display all the records (all columns) from table Emp. 1

(b) Display employee name and department name of all employees. 1

(c) Display Ename, Sal and Sal added with Comm from table Emp. 1

(d) Display EName joined with Job with heading “Employee”, Sal*12 as “Total Salary” from table Emp. 1

(e) Display distinct Sal of employees from table Emp 1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F (A, B, C, D) =π(O, 1, 2, 3, 4, 5, 10, 11, 15)

Set 8

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Write program to perform the following operations on the text file:

i. Create Text File

ii. Display the text file

iii. Count the number of lines starting with 'A'

iv. Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a)  To display the employee name, department name and department number.                 1

(b)  To display the ename, dname and loc of all employee who earn commission.              1

(c)  To display the ename and dname of all the employees whose name start with A.         1

(d)  To display the name, department number for all employees who work as Clerks and

earns a salary more than 4000        1

(e)To display the employee number and employee name in the descending order of salary  1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(U,V,W,Z) = π ( 0,1,2,4,5,6,8,10)

Set 9

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours         Max. Marks: 30

.1. Write a menu driven program in PYTHON.       12

Write program to perform the following operations on the binary file EMP.DAT. The class employee have the following attributes:

EmpName, EmpNo, Dept and Salary

i. Append records.

ii. Delete a record for a given Empno.

iii. Search for a given employee name

iv. Display all records tabular form.

v. Exit

2. Consider the two tables given below and the write the commands:    

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a) Write a Query to display name, job, salary, and HireDate of employees

who are hired between Jan-Feb. 20, 1981, and May 1, 1981. Order the

query in ascending order of HireDate. 1

(b) Write a Query to display the name and hire date of all employees who

were hired in 1982 1

(c) Write a Query to display the name, job title and salary of employee who do

not have manager. 1

(d) Write a Query to display the name of employee whose name contains ‘A’

as third alphabet. 1

(e) Write a Query to display employee name, department name and location

of all employees who have manager number between 7500 and 7900. 1

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(A, B, C, D) = π(5,6,7,8,9,12,13,14,15)

Set 10

ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION

CBSE BOARD PRACTICAL EXAMINATION, JANUARY-2015

COMPUTER SCIENCE PRACTICAL

Time: 3 hours      Max. Marks: 30

1. Write a menu driven program in PYTHON.       12

Write program to perform the following operations on text file:

i. Create text file

ii. Create a copy of the text files by copying the words starting with vowels

iii. Display the original files

iv. Display the new file

v. Exit

2. Consider the two tables given below and the write the commands: 

TABLE: EMP

|EMPNO |ENAME |JOB |MGR |HIREDATE |SAL |COMM |DEPTNO |

|7369 |SMITH |CLERK |7902 |17-DEC-80 |800 | |20 |

|7499 |ALLEN |SALESMAN |7698 |20-FEB-81 |1600 |300 |30 |

|7521 |WARD |SALESMAN |7698 |22-FEB-81 |1250 |500 |30 |

|7566 |JONES |MANAGER |7839 |02-APR-81 |2975 | |20 |

|7654 |MARTIN |SALESMAN |7698 |28-SEP-81 |1250 |1400 |30 |

|7698 |BLAKE |MANAGER |7839 |01-MAY-81 |2850 | |30 |

|7782 |CLARK |MANAGER |7839 |09-JUN-81 |2450 | |10 |

|7788 |SCOTT |ANALYST |7566 |19-APR-87 |3000 | |20 |

|7839 |KING |PRESIDENT | |17-NOV-81 |5000 | |10 |

|7844 |TURNER |SALESMAN |7698 |08-SEP-81 |1500 |0 |30 |

|7876 |ADAMS |CLERK |7788 |23-MAY-87 |1100 | |20 |

|7900 |JAMES |CLERK |7698 |03-DEC-81 |950 | |30 |

|7902 |FORD |ANALYST |7566 |03-DEC-81 |3000 | |20 |

|7934 |MILLER |CLERK |7782 |23-JAN-82 |1300 | |10 |

Table: DEPT

|DEPTNO |DNAME |LOC |

|10 |ACCOUNTING |NEW YORK |

|20 |RESEARCH |DALLAS |

|30 |SALES |CHICAGO |

|40 |OPERATIONS |BOSTON |

(a)   To display the name, hiredate of all employees hired after Jan 10th 1980.     1

(b)  To display the department no. highest and lowest salary for each department.   1

(c)  To display the name of the employees whose job is in Clerk, Salesman, President.   1 

(d)   To display the name and department name of all employees.   1

(e)  To display the name and salary of all the employees in the alphabetical order of name. 1 

3. Project Work         5

4. Practical File         4

5. Viva Voce          2

6. Draw a digital circuit diagram using NOT, AND and OR logic gates, for the following expression after reduction using K-map: 2

F(P,Q,R,S) = π(0,3,5,6,7,11,12,15)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download