Model question paper for Computer - 2 (Paper Pattern of Computer)

Computer Systems and Applications

            Instruction

1) All questions are compulsory and carry equal marks.

            2) Attempt any two of (a), (b), (c) for each question.

            3) Figures to right indicate maximum marks.

            4) Attempt either Q.4 on VB or Q.4 on C-programming.

Q.1) Attempt any two of the (A), (B), (C):

(A) (I) What are different elements of communication system? (4)

(II) Explain the uses of bridges and Routers. 4)

(B) (I) Explain the terms: (4)

            (a) TCP/IP       (b) DNS

 (II) State whether the following is true or false. (4)

i.                    Computer that acts as server and client is peer.

ii.                  IP protocol determines the address of destination machine.

iii.                A Blog is website for passing articles and comment.

iv.                URL is a unique address to any source of information

(C) (I) Explain the terms: (4)

a) HUBS         (b) OSI model

(II) Explain the uses of WWW and HTTP. (4)

Q.2) Attempt any two of the (A), (B), (C):

(A) (I) Explain B2C and C2C E-commerce (4)

(II) State different modes of payment systems used in E-Commerce.(4)

(B) (I) Explain briefly about the following. (4)

            a) Community Provider

            b) Public Key Encryption

(II) Define the following terms: (4)

a)      Secure Sockets Layer (SSL)

b)      Secure Electronic Transaction (SET)

(C) (I) Give the working of online credit card. (4)

(II) Explain briefly about the following. (4)

a)      Limitation of E-Commerce

b)       Mobile Commerce (M-Commerce)

Q.3) Attempt any two of the (A), (B), (C) with reference to MySQL:

A) (I) There exits a table called EXAM containing columns SEATNO (Seat number primary key), NAME (Student’s name), AVG (Average marks).

1. Display all the rows of the table EXAM. (4)

2. Display seat number and average marks for those students who have obtained average marks between 60 and 75.

3. Display the Structure of the table

4. To add a new column TOTAL int

(II) (a) Explain use of the MySQL functions UPPER ( ) and ROUND ( ) (2)

(b) Explain the concept of Primary Key (2)    

(B) (I) Write a command line to create a table in Mysql with following details: (4)

                        Name of table: Salary

                        Employee Code: E_code Primary key

                        Employee name: E_name

                        Date of joining: Doj

                        Gender: gender (m or f)

 (II) With reference to table created above, write command line to insert a new Column having name department. Also write a command to change the Name of the column doj to appoint_date (4)

(C) (I) There exist a table ORDERS (order_num int primary key, order_date date, Produnt_no int, order_qty int, amt int) and there is another table called PRODUT (Produnt_no int, description varchar, price int, stock int).

Write command in SQL. (4)

i.                    Using join command display order number, description and stock

ii.                  Using inner join, display order date, order quantity and price

(II) There exits a table called CUSTOMERS containing columns CUST_ID (Customer id), NAME (name of the customer), and CITY (city) PIN (pin code), PHONE (phone number) (4)

i.                    Display name, city and phone number of those customers persons who do not stay on city of MUMBAI or PUNE.

ii.                  Remove a row from the table for which customer id is 50

iii.                Rename the table from CUSTOMERS to CONSUMERS.

iv.                Delete the table CONSUMERS.

Q.4) Attempt any two of the (A), (B), (C) with reference to ‘C’

(A) (I) What is the difference between = and = = operators? (2)

(II) What are Keywords in C? (2)

(III) What is the output of following C program? (4)

main ( )
{ int x = 6589;
char z = '*';
float y = 8888.9935;

printf ("% -6.1f %3c\n", y, z);
printf ("% +5d % -3c\n", x, z); }

(B) (I) Mention one difference between gets ( ) and scanf ( ) (1)

 (II) Name the different types of constants in C language. (1)

 (III) Input a character and print whether vowel or not. (3)

 (IV) Write a program in c to find the sum (3)

            s = 1/3  +  3/5  +  5/7  +  7/9  +  9/11  + 11/13  +  13/15

(C) (I) What is the use of main ( ) in C? (1)

 (II) Name any two escape sequence in C. (1)

(III) Input Basic Salary. Display Income Tax. Income Tax is calculated as Follows(6)                                                                                            

                       

Basic Salary	Income Tax
First 1,80,000	Nil
Next 1,20,000	10%
Next 1,00,000	20%
Rest	30%

OR

Q.4) Attempt any two of the (A), (B), (C) with reference to Visual Basic:

(A) (I) State whether the following is true or false (4)

1. The function chr ( ) gives an ASCII value of the character.

2. In VB, while saving the project file the corresponding forms are saved automatically

3. The menu programs prefers command button to be displayed on the form

4. The VB software is a user friendly DBMS.

 (II) Explain the following function with illustrations (4)

1. FormatNumber ( )               2. str ( )

(B) (I) Answer the following (4)

1. What are the features of Visual Basic?

2. Explain the use of option button in your program

3. Explain the following controls

1.Text box                   2. Command button

(II) Write the code for the following (4)

Print odd numbers from 1 to 20 in ascending as well as descending order as per the users choice.

           

(C) Write a project to design a suitable form to enter a text message for Deewali Greetings. Provide options to change colour, font, font size and fond effects such as Bold, underline. Use check boxes for the effects and option buttons for colour, Font, font size. User should be allowed to enter text message only. (8)

Q.5) Attempt any two of the (A), (B), (C) with reference to MS-Excel

(A) (I) Explain the terms Relative, Absolute and Mixed Referencing (2)

II) A worksheet contains Roll no. and marks out of 100 in 2 subject entered in Columns A, B respectively in first 21 rows. In the first row heading is entered and in subsequent rows data has been entered.Explain the procedure to find average and grade in column D and E respectively.Grade is to be assigned as follows: (6)

Average	Grade
75 or more	A
50 or more and below 75	B
Below 50	C

(B) (I) Explain the use of the following functions (2)

1. Sumif ( )                  2. Countif ( )

(II) Consider the following worksheet. (6)

1. Arrange the data as per name                                                       
2. To display only those records where M2 is above 90                  
3. To display all the records where name is ending with ‘A’          

	A	B	C	D	E	F
1	Name	M1	M2	M3	Total
2	Anil	69	72	61	202
3	Ajay	75	48	73	196
4	Smita	85	81	70	236
5	Anita	65	100	95	260

                       

(C) (I) What is Pivot table? Where it is used? (2)

 (II) The following data has been entered in a worksheet (6)

	A	B	C	D
1	ITEM NO.	2007	2008	2009
2	510	399	400	300
3	300	150	200	200
4	210	200	250	170
5	309	175	375	155

           

                       

Write the steps

i.                    To calculate the total in B6, C6 and D6.

ii.                  To construct 3-D Bar diagram

iii.                To construct Pie-Chart for the totals.

                       

Related Posts by Categories