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.

                       

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

Model question paper for Computer - 1 (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 in brief following terms: (4)
             a)      Ring Topology
             b)      TCP/IP 

(B) (I) Answer the following: (4)
a) What are the advantages of star topology?
b) Name the network which is normally spread over geographical area
c) What is the difference between server based network and client base Network?
d) What is the main advantage of Network?

      (II)Explain uses of following devices of Network? (4)

       a) WWW.

       b) HTTP

(C) (I) Explain in brief: (4)

       a) Search Engine

       b) E-mail.

       

(II) Answer in one sentence: (4)
       a)      What are different types of internet connections?
       b)      Name the Boolean Search Engines
       c)      What do you mean by hypertext?
       d)     What are the internet protocols?

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

(A) (I) Fill in the blanks with appropriate choices: (4)
a) Buying and selling the products over the internet is called______

i) E-commerce         ii) EDI             iii) E-market    iv) E-shoping

b) Ebay.com is the most successful example of ____________
i) B2B         ii) B2C            iii) C2C           iv) C2B

c) Pureplay is a category of ______________

i) Market Creator     ii) E-tailer   ii)content provider   vi)Service provider
d) A digital Signature is used as one of the security measures in order to maintain the____

i) Integrity    ii) Confidentiality    iii) Authentication  iv) Non-repudiaton

(II) State whether the following statements are true or false: (4)

a)      EDI is a subset of E-commerce.

b)      The scope of E-commerce is local

c)      Orkut is a type of service provider

           d)     WAP forum is founded by four companies. 

(B) (I) Answer the following question in one line (4)

a) Which companies have developed SET protocol?

b) Which are the participants of online credit card transaction?

c) In which model of E-commerce get referral fee from resulting sales?

d) In which business model the company integrates both off line and online aspects of retailing.

(II) Define the following terms in one or two lines only: (4)

a)      Portals

b)      Internet Auctions.

c)      WAP

d)     E-market

(C) Distinguish between:(8)

 (I) Traditional Commerce and E-Commerce

 (II) B2B Internet commerce and B2C internet commerce

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

(A) (I) There exist a table student (s_no int primary key, F-name varchar (10),L-name varchar (10), gender char (1), dob date, city varchar (15))(8)

a) Write query to display female students born in the year 1990.

b) Write query to display students not from pune city

c) If dob is date of birth then display day, moth and year of birth of s_no15

d) Write command to display structure of student table in two ways.

 

(B)(I) Write command line to create a table Emp containing columns(e_no int primary key, S_name name of person, M_sal monthly salary,Doj date of joining, gender) (4)

 

(II) Write a command to enter following data in above table S_name is Rajesh, he is a male and monthly salary is 250000 and Date of joining is 12-Aug-2005.(2)

(III) Write command to correct date of joining as 9-sept-2001 instead of 8-Aug-2001 of S_no 25 in above table.(2) 

 

(C) (I) Explain use of the MySQL functions CONCAT( ) and YEAR( ) (2)

 

(II) Explain the concept of Foreign Key (2)

 

(III) There exists a table named EMPLOYEE containing (4) 

EMP_ID (employee id primary key) EMP_NAME (employee’s name) And DOJ (Date of joining). There exists another table called EMPLOYEE_PAY containing  EMP_ID (employee id primary key) DEPT (department name) and SALARY (salary). 

Write MySQL statement for the following  

a) Display EMP_ID, EMP_NAME, DEPT and SALARY for those Employees whose date of joining is on or before 1^st January 2009  

b) Display EMP_NAME, DOJ, DEPT and SALARY using INNER JION

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

(A) (I) Which are the 4 different storage classes in C? (2)

(II) Give the difference between scanf () and getchar () (2)

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

#include
main ( )
{
char x = '&';
float y = 2134.627;
printf("%3c %9.2f\n", x, y);
printf("% -4c -7.0f\n", x, y);
return(0);
}

 

(B) (I) What are identifiers? Give an example. (2)

 

(II) Mention the difference between break and continue statement.(2)

 

(III) Write a C program to find and print the sum of: (4)

            1*6   +   2*9   +   3*12    +    10*33

(C) (I) What is the difference between while loop and Do while loop in C(2)

 

(II) Write a C program for Sorting the data in ascending order and print Lowest and highest value.(6)

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 absolute cell reference and mixed cell reference. (2)

(II) Answer the following using Spreadsheet (6)

Name & basic salary of 100 employees are entered in first two columns.

The first row contains the column headings calculate HRA, DA, MA, GROSS, PF & NET SALARY.

HRA is 15% of basic salary or Rs. 200 whichever is more.

DA is 45% of basic salary subject to maximum of Rs. 1000.

MA is 18.5% of basic salary subject to Maximum of Rs. 800

PF is 8.33% of basic if basic salary is above 2000 otherwise PF is NIL

GROSS = Basic salary + HRA + DA + MA 

Net salary = Gross – PF.

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

                 1. MOD( )       2. PROPER( )

(II) A worksheet contains employee no. and monthly gross pay entered in Column A and B respectively in the first 16 rows. In first row headings are entered and in remaining rows data is entered. Write steps to compute annual income and income tax in columns C and D respectively where income tax is to be calculated as follows (6)

 

Annual Income	Income tax
First 150,000	NIL
Next 100,000	10%
Next 75,000	20%
Excess	30%

 

(C) (I) Which are the different types of data used in a worksheet?(2)

 (II) Given the worksheet as follows (6)

	A	B	C	D	E	F	G	H	I	J
1	NAME	ENG	HINDI	ECO	BK	MATHS	OC	TOTAL	PCTG	RESULT
2	Anjali	76	63	78	66	86	68
3	Rajesh	54	49	48	52	46	89
4	Dilip	72	69	66	78	75	84
5	Jasmine	87	73	84	82	97	93
6	Mumtaz	54	49	28	31	17	21

 

Explain the procedure to fill the details in TOTAL, PCTG and RESULT columns by Computing total of all subject, percentage of marks and result respectively.

Where result is “PASS” when total is 240 or more otherwise “FAIL”

 

read more "Model question paper for Computer - 1 (Paper Pattern of Computer)"