M.C.A - Commerce (2008 Pattern)
M.C.A - Commerce (2008 Pattern)
M.C.A - Commerce (2008 Pattern)
[5521]-12
M.C.A. (Commerce Faculty) (Semester - I)
102 : System Organisation and Management
(2013 Pattern)
Time : 3 Hours] [Max. Marks :80
Instructions to the candidates:
1) Attempt all questions.
2) All questions carry equal marks.
P.T.O.
Q4) Answer the following (Any Four) : [16]
a) State and explain elements of management information system.
b) Determine information requirements for a marketing manager.
c) Give advantages of E-Commerce.
d) Describe features of Decision support system.
e) Explain importance of management.
[5521]-12 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q3) Attempt Any Four. [4 × 4 = 16]
a) What is function? Explain any two storage classes in function.
b) What is DMA? Explain functions included in DMA.
c) Explain Structure with proper example.
d) Define Array. Explain different types of array.
e) What is Macro? How do we write macros in ‘C’.
[5521]-13 2
d) Find memory requirement for-
union t1
{
char s[5];
intnum;
};
e) void main( )
{
int x = 4, y = 3, z;
z = x- --y;
printf(“%d%d%d”,x,y,z);
}
[5521]-13 3
Total No. of Questions : 5] SEAT No. :
P.T.O.
dy
c) From the following table, compute at x = 1.
dx
x 1 2 3 4 5 6
y 1 8 27 64 125 216
6 1 rd
d) Evaluate 0 1 x 2 dx by using simpson’s 1 3 rule. (Take n = 6).
dy
e) Given 1 xy with initial condition that y = 1 when x = 0. Compute
dx
y(0.1) and y(0.2) by using Euler’s method.
[5521]-14 2
d) The table below gives the number of books issued from a certain library
on the various days of a week.
Days Mon. Tue. Wed. Thurs. Fri. Sat
No. of books issued 120 130 110 115 135 110
Test at 5% L.O.S. Whether the issuing of books are uniformly distributed
over the days.
e) Explain in detail paired t-test along with the assumptions made.
[5521]-14 3
Total No. of Questions : 5] SEAT No. :
[5521]-16 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q3) Attempt following (Any Four) : [4 × 4 = 16]
a) Write a note on built in aggregate functions in SQL.
b) Explain 2-Phase locking protocol and List its versions.
c) Write a note on Validation based protocol.
d) Explain following operation with example i ) Natural Join ii) Project
e) What is Integrity Constraint? Which are different types of Integrity
Constraint?
[5521]-22 2
b) Attempt following : [2 × 3 = 6]
i) Consider the following schedule
T1 T2
R(x) R(y)
x = x + 50 y = y + 100
W(x) W(y)
R(y) R(z)
Y = y – 500 z = z – 200
W(y) W(z)
Give one non-serial schedule that is serializable.
ii) Consider the following schedule and check its serializability using
precedence graph.
T1 T2
R(x)
R(x)
R(y)
W(x)
W(y)
[5521]-22 3
Total No. of Questions : 5] SEAT No. :
Q1) a) Explain the concept of ‘Cost Accounting’, State the advantages of Cost
Accounting. [8]
b) Define the term Element of Cost. State the different Element of cost with
suitable Examples. [8]
Q3) The cost Accounts of Umesh Ltd. Nasik. For the year ended 31-03-2010
showed the following information. [16]
P.T.O.
Rs.
Sales 5,50,000
Rent 15,000
2
(Factory - ( 66 3 %, office 33 1 3 %)
b) Prime Cost
c) Works Cost
d) Cost of production
e) Total Cost
f) Profit
[5521]-23 2
Q4) Product X is obtained after it passes through three distinct processes. You are
required to prepare process Accounts from the following information. [16]
Particulars Total Rs. Process
I Rs. II Rs. III Rs.
Material 15084 5200 3960 5924
Direct wages 18000 4000 6000 8000
Production 18000 - - -
Over heads
1000 Units @ Rs. 6 per unit were introduced in process - I.
Production over heads to be distributed as 100% on direct wages.
Process Actual Normal Value of scrap
Output Units Loss Per Unit Rs.
I 950 5% 4
II 840 10% 8
III 750 15% 10
OR
Gajanan Construction, Nasik a contract No. 203 for construction of a
school building on 1st January 2010 the contract price is fixed at
Rs. 15,00,000; subject to a retention of 20% of work certified. The
following are the details of expenditure made by contractor on this
contract during the year.
Rs.
Direct labour charges 4,05,000
Materials issued from stores 4,20,000
Materials Directly purchased 81,200
Plant installed at site on 30th June 10 60,000
Direct Expenses 23,000
Management overheads 37,200
Material transferred to Contract No. 105 6,300
Outstanding wages 7,800
Material transferred from contract No. 505 1,600
Work Certified 11,00,000
Work Uncertified 16,500
Cash received from contractee 8,80,000
up to 31st Dece. 2010
Depreciation on plant is provided @ 40% p.a. on the original Cost.
Prepare : a) Contract Account.
b) Contractee Account.
[5521]-23 3
Q5) An Engineering factor has the following particulars for the period ended
31-03-2010. Compute the departmental Overhead rate for each of the production
department, assuming that overheads are recovered as a percentage of direct
wages. [16]
Particulars Production Deptt. Service Deptt.
A Rs. B Rs. C Rs. X Rs. Y Rs.
Direct wages 30,000 45,000 60,000 15,000 30,000
Direct Material 15,000 30,000 30,000 22,500 22,500
Staff Number 1,500 2,250 2,250 750 750
Electricity KWH 6,000 4,500 3,000 1,500 1,500
Assets Value 60,000 40,000 30,000 10,000 10,000
Light points 10 16 4 6 4
Area (sq.ft.) 1,500 2,500 500 500 500
The Expenses for the period were :
Rs.
Power 1,100
Lighting 200
Store overheads 800
Staff welfare 3,000
Depreciation 30,000
Repairs 6,000
General overheads 12,000
Rent and Taxes 550
Apportion the expenses of service department ‘Y’ on the basis of Direct
wages and those of service department ‘X’ in the ratio 5:3:2 to the production
Department.
OR
[5521]-23 4
Prepare a cash Budget of MICO Ltd. Nasik. from March 2010 to August
2010.
Month Sales Selling Purchases Wages Factory Admini
Rs. Exp. Rs. Rs. Exp. strative
Exp.
Rs. Rs. Rs.
January 1,70,000 7,000 80,000 15,000 10,000 5,000
February 1,60,000 7,500 84,000 16,000 11,000 5,500
March 1,82,000 6,500 83,000 16,800 8,000 4,500
April 1,55,000 6,800 83,000 12,000 10,500 4,750
May 1,65,000 7,400 76,000 18,000 12,000 5,400
June 2,00,000 7,000 68,000 16,000 9,600 5,700
July 1,80,000 6,000 70,000 17,000 8,000 5,000
August 2,20,000 5,500 58,000 16,500 9,600 5,500
Other information :
a) Opening cash Balance on 1st March 2010 Rs. 20,000.
b) Period of credit allowed to customers and by suppliers - One month.
c) Lag in the payment of factory Expenses. Administrative Expenses and
selling Expenses - One month.
d) Machinery purchased for Rs. 30,000 in March payable on delivery.
e) Building purchased in April for Rs. 1,50,000 payable in two equal
instalments in May and July.
f) 5% Commission of sales payable two months after sales.
g) Delay in the payment of wages - one month.
[5521]-23 5
Total No. of Questions : 5] SEAT No. :
Q1) Define Management Accounting. What are the Advantages and Limitations of
Management Accounting?
OR
What do you mean by ‘Ratio Analysis’? Explain the various types of
accounting ratios.
Q2) Distinguish between find flow statement and cash flow statement.
OR
Write short notes on any four.
a) Common size income statement.
b) Assumptions of Break Even Analysis.
c) Under capitalisation.
d) Master Budget.
e) Trend Analysis.
f) Inter - firm comparison
Balance Sheet
8% Redeemable
Provision for
Additional Information -
a) Depreciation of Rs. 10,000 and Rs. 20,000 has been charged on plant
and Land and Buildings respectively during the year ending 31-3-10.
b) An Interim Dividend of Rs. 20,000 has been paid during the year ending
31-3-10.
c) Income Tax Rs. 35,000 has been paid during the year ending 31-3-10.
[5521]-24 2
Q5) Ajay Corporation Ltd. has prepared the following Budget estimates for the
year 2009-10.
Sales (Units) 15,000
Particulars Rs.
Fixed Expenses 34,000
Sales Value 1,50,000
Variable Costs (Per unit) 6
You are required to :
a) Find the P/V ratio, Break even point and Margin of safety.
b) Calculate the revised P/V ratio, Break even point and margin of safety in
each of the following cases.
i) Decrease of 10% in selling price.
ii) Increase of 10% variable cost.
iii) Increase of sales volume by 2,000 units.
iv) Increase of Rs. 6,000 in fixed costs.
[5521]-24 3
Total No. of Questions : 5] SEAT No. :
[5521]-25 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q3) Attempt any four: [4 × 4 = 16]
a) What is Array? Explain its types.
b) Write a program that accepts name of books from command line and
store, display them in ascending order.(using array)
43
432
4321
e) Write a Java program to read line of integers. Display each integer and
also display sum of all integers.
[5521]-26 2
Q5) A) Trace output: (Consider there is no syntax error in given code) [2 × 4 = 8]
a) class Test {
protected int x, y;
}
class Main {
public static void main(String args[]) {
Test t = new Test ( );
System.out.println (t.x +" " + t.y);
}
}
b) #include <stdio.h>
class Test
{
Static int i;
int j;
};
int Test::i;
int main( )
{
cout << sizeof(Test);
return 0;
}
}
yyy
[5521]-26 3
Total No. of Questions : 5] SEAT No. :
Q2) State true or false and justify your answer (any 4) : [4 × 4 = 16]
a) An invalid rectangle is the area on the screen which is not part of any
window.
P.T.O.
Q3) Answer the following (Any 8) [16]
a) Define Caret.
b) Define Pipe.
c) Define Shell.
d) What are child window controls?
e) Enlist scrollbar messages.
f) What is Handle?
g) What is call back function?
h) What are metafiles?
i) Explain Peek Message ( ).
j) Define valid and invalid rectangles.
[5521]-31 2
Total No. of Questions : 8]
SEAT No. :
P5108 [Total No. of Pages : 1
[5521]-33
M.C.A. (Commerce Faculty)
303 : Enterprise Resource Planning and Management
(2008 Pattern) (Semester - III)
Time :3 Hours] [Max. Marks :80
Instructions to the candidates:
1) Solve any five questions.
2) Figures to right indicate full marks.
Q2) What is Data Warehousing? Explain structure of Data ware housing. [16]
Q3) What is ERP? Explain characteristics and benefits for ERP. [16]
Q4) What is EDI? Explain EDI standard and EDI services. [16]
Q1) What do you mean by strategy? Explain the importance of Business strategies.
Q2) State and explain the elements and importance of Financial policies.
Q4) What do you mean by strategic control? Explain the steps involved in strategic
control.
Total No. of Questions : 6] SEAT No. :
Q1) Explain the term “Mutual Fund”. What are the advantages and disadvantages
of Mutual Funds?
Total No. of Questions : 5] SEAT No. :
[5521]-41 2
Total No. of Questions : 5] SEAT No. :
e) Explain
P.T.O.
Q3) Answer the following (Any 4) [4 × 4 = 16]
a) Explain Inband & Outband Mointoring.
b) "In theory, you get more than enough money for constructing a data
center,but in practice, this rarely happens." Comment.
c) Explain the factors need to be considered for selecting location of data
centre.
d) Explain various components provided by ISP within data center.
e) Explain what do you mean by Plenum with example.
yyy
[5521]-42
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q4) Attempt any four : [4 × 4 = 16]
a) Explain role of Mediator Pattern in E-Business.
b) Write a note on cookie.
c) Explain importance of tag libraries in web application development.
d) Explain doGet() and doPost( ) Method.
e) List steps for creating XML Document.
[5521]-43 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
c) Write a ASP program to insert the data in employee table (empno,
empname, designation). Display the records in employee table.
d) Write a program using a ASP script to for web page to display the
following
#
##
###
e) Write a JavaScript to calculate the factorial of a given number.
yyy
[5521]-45 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q3) Write a short note on any four : [4 × 4 = 16]
a) Chief knowledge officer.
b) Repertory Grid Analysis.
c) Knowledge Repository.
d) Interviews.
e) Uncertainity.
[5521]-46 2
Total No. of Questions : 5] SEAT No. :
Q5) Write the steps for the following (Any four) : [4 × 4 = 16]
a) Create a website for book of all subjects and navigate to computer books.
b) Create a website for Cosmetics such that Navigation to the Types of
cosmetics.
c) Create a website for college and add a new article having subjects of
MCA (Commerce).
d) Create a website for Ready-made Cloths and insert images.
e) Create a website for wrist watch showroom and edit the prices of watches
[5521]-51 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q4) Attempt Following (Any Four) : [4 × 4 = 16]
a) Define:
i) Secure Electronic Transaction
ii) Digital Payment System
b) What is distributed database system? What are advantages and
disadvantages?
c) What is use of catalog in distributed databases?
d) What are objectives of the design of data distribution?
e) Write a note on parametric queries.
[5521]-52 2
c) Consider the following relational schema Book(bno,bame,pubname,price)
Author(ano,aname)
BA(bno,ano)
Construct optimized operator tree for the following query. Select bname
from Book, Author, BA
where Book.bno=BA.bno and
Author.ano=BA.ano and
pubname= “Techmax” and price<300
d) Consider the following schema
Student (Sno, Sname, City, Class)
Fragment the given relation into fragments Studentl, Student2, Student3
using following predicates
Studentl = 6class=“F.Y” (Student)
Student2= 6class=“S.Y” (Student)
Student3= 6class=”T.Y” (Student)
e) Consider the following relational schema
Emp (Eno, Ename, City, Dname)
Proj (Pno, Pname, Status)
Emp_Proj(Eno, Pno)
Convert the following tree into optimized operator tree.
[5521]-52 3
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q3) Attempt any four of the following : [4 × 4 = 16]
a) Explain features of E-commerce in detail.
b) Explain types of online auction with example.
c) Write a note in phishing.
d) Explain secret key Cryptography.
e) Explain use of digital envelope in E-commerce.
[5521]-53 2
Total No. of Questions : 5] SEAT No. :
P.T.O.
Q4) Answer the following (any two) : [2 × 8 = 16]
a) Explain star schema with example and diagram.
b) What is knowledge base? Explain any five data mining techniques.
c) What are the three techniques used in decision tree? Explain any one in
detail.
[5521]-54 2
Total No. of Questions : 5] SEAT No. :
A 3 5 4 9 6
B 5 6 3 7 8
Player A
C 8 7 9 8 7
D 4 4 8 5 3
O1 8 12 23
O2 9 13 22
Demand 28 17
e) Solve the following assignment problem for maximization
Z1 Z2 Z3 Z4
S1 7 12 37 18
S2 25 27 18 25
S3 16 3 17 23
S4 10 25 14 9
f) Explain Vogel’s Approximation method for obtaining an initial basic
feasible solution of a transportation problem.
[5521]-56 4
Q4) Attempt any two of the following : [16]
a) Discuss the role of sensitivity analysis in linear programming. Under
what circumstances is it needed and under what conditions do you think
it is not necessary?
b) Solve the following L.P.P. by Big - M method:
Maximize Z = 3x1 – x2
Subject to :
2x1 + x2 > 2
x1 + 3x2 < 3
x2 < 4
x1, x2 > 0
c) Obtain an IBFS for the following transportation problem by VAM method.
To
From D1 D2 D3 D4 Supply
O1 23 27 16 18 30
O2 12 17 20 51 40
O3 22 28 12 32 53
Demand 22 35 25 41
Also find the Corresponding Transportation Cost.
[5521]-56 5