Model question paper for Computer - 1
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 based 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_no 15
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 1st 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);
}
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:
1*6 + 2*9 + 3*12 + 10*33 (4)
(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
1. FormatNumber() 2. str() (4)
(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 2000otherwise 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”
0 comments:
Post a Comment