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”

 

Related Posts by Categories