Get documents about "OUR OWN HIGH SCHOOL_ AL WARQA'A_ DUBAI
Shared by: linzhengnd
-
Stats
- views:
- 50
- posted:
- 9/1/2011
- language:
- English
- pages:
- 78
Document Sample
(055-1)
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ACCOUNTANCY (THEORY)
Grade: XII Max. Marks: 80
Date: Time: 3 hours.
----------------------------------------------------------
General Instructions:
1.This question paper consists of two parts A and B.
2.Part A is compulsory for all candidates.
3.Candidates can attempt only one of the remaining parts B.
4.All parts of a given question should be attempted at one
place.
______________________________________________________________
PART A
(Not for Profit Organisation, Partnership Firms and
Company Accounts)
1. What is a ‘not for profit organization’? [1]
2. A and B are partners in a firm. During the year A [1]
withdraws Rs.6000 at the beginning of every quarter
and B withdraws Rs.1000 at the beginning of every
month for the last 6 months. Calculate interest on
drawings to be charged to A and B at the rate of 10%
per annum.
3. A, B and C are partners sharing profits and losses in [1]
the ratio of 3:2:1. They admitted D as a partner for
1/6th share in future profits. C wanted to retain his
old share in the new firm. Calculate the new profit
sharing ratio.
4. X, Y and Z are partners in a firm sharing profits and [1]
losses in the ratio of 3:2:1. Z decided to retire from
the firm selling his share to X and Y in the ratio
1:1. On Z’s retirement, goodwill of the firm was
valued at Rs.36000. Make an adjustment entry for Z’s
share of goodwill without raising a goodwill account.
Goodwill was appearing in the books of the firm at
Rs.4200.
5. State two differences between shares and debentures. [1]
Page 1 of 8
6. State the amount of subscriptions to be credited to [3]
income and expenditure account after considering the
following details.
1) Opening balances:
Subscriptions outstanding – 5000
Subscriptions received in advance – Rs.6000
2) Subscriptions received during the year Rs.62000
3) Closing balances:
Subscriptions outstanding Rs.7000
Subscriptions received in advance – Rs.3000
7. AB Ltd acquired fixed assets costing Rs.880000 from [2]
XY Ltd. Rs.70000 was paid by means of a bank draft and
the balance was settled by issue of 10% debentures of
Rs.10 each at a discount of 10%.
8. Pioneer Ltd. has an authorized capital of Rs.2000000 [3]
divided into equity shares of Rs.10/- each. The
company invited applications for 100000 shares.
Applications were received for 80000 shares. The
directors made all the calls. All amounts were
received except the final call of Rs.2 on 2000 shares.
These shares were subsequently forfeited. Show how
share capital will appear in the balance sheet of the
company as per schedule VI of Companies Act.
9. Ram, Rahim and Robert are partners with capitals fixed [2]
at Rs.200000, Rs100000 and Rs.300000 respectively.
During the year 2008 interest on capital was provided
at 12% instead of 10%. You are required to pass an
adjustment entry at the beginning of 2009 for
rectifying the error.
10. A, B and C were partners sharing profits and losses in [2]
the ratio of 2:2:1. On 31.12.2008, the following
balances appeared in the books of the firm:
1) General reserve Rs.33000
2) Profit and loss account(cr) Rs.12000
On 31.12.2008 they decided to share the profits and
losses equally. For this purpose goodwill was valued
at Rs15000. It was decided not to disturb general
reserve and profit and loss account and not to open
any account for goodwill.
Pass an adjustment entry for bringing the above
decision into effect.
11. Watermelon Ltd. forfeited 2000 shares of Rs.50 each [3]
(Rs.40 called up) issued at a discount of 10% on which
the shareholder had paid Rs.20 on application and
Page 2 of 8
Rs.10 on allotment. 1000 of these shares were reissued
at Rs.40 as fully paid up. Pass journal entries for
forfeiture and reissue shares.
12. M.Ltd forfeited 1000 shares of Rs.100 each (Rs.80 [3]
called up) issued at a premium of 10%, for non payment
of allotment money of Rs.60 (including premium). Out
of these 750 shares were reissued at Rs.100 as fully
paid up. Pass journal entries in the books of the
company for forfeiture and reissue of shares.
13a. B.Ltd issued Rs.200000 8% debentures. Assuming that [3]
all the debentures issued are taken up and paid for.
Pass journal entries in the following cases.
1) The debentures are issued to the vendor of a
building acquired for Rs.180000.
2) The debentures are issued at par and redeemable at
a premium of 10%.
3) The debentures are issued at a premium of 5% and
redeemable after 3 years at a premium of 7%.
13b. X Ltd. redeemed Rs.200000 12% debentures of Rs.100 [2]
each by purchasing in the open market for immediate
cancellation in the following manner.
Rs.140000 debentures at Rs.90
Rs.60000 debentures at Rs.95
Expenses of purchase amounted to Rs.5000. Pass journal
entries in the books of the company.
14. From the under mentioned receipts and payments account [6]
of Nehru Club for the year ended 31.12.2006, prepare
an income and expenditure account and balance sheet as
on 31.12.2006.
Receipts and payments account
Receipts Payments
To cash in hand 7000 By Rent 3000
To cash at Bank 30000 By Salary 6000
To Subscriptions By Postage 150
Arrears 2500 By Telephone 3000
Current 41500 By Furniture 10000
Advance 1500 By Books 1500
To sale of By Investments 75000
Investment 45000 By Charity 11000
To Interest on By Cash in hand 5450
Investment 1000 By Cash at Bank 15000
To Sale of
furniture 1600
(book value 1500)
________ _______
130100 130100
Page 3 of 8
Additional information:
1) Subscriptions outstanding Rs.3500.
2) Accured interest on investments 3500.
3) Outstanding salaries Rs.500.
4) The value of investments on 01.01.2006 was
Rs.55000.
(Book value of investments sold was 40000)
5) Value of furniture on 01.01.2006 was 6000.
6) Furniture was to be depreciated at 10% including
additions.
15. A, B and C were partners in a firm sharing profits and [6]
losses in the ratio of 2:1:1. Their balance sheet on
31.12.2006 was as follows:
Liabilities Assets
Creditors 9000 Machinery 24000
General Reserve 9600 Stock 18000
Capitals: Debtors 18000
A 30000 Bills receivable 3000
B 15000 Bank 15600
C 15000
_________ _______
78600 78600
A died on 31st March 2007. According to the
partnership deed, the executors of A were entitled to
the following:
1) Amount standing to the credit of partner’s capital
account.
2) Interest on capital at 5%.
3) Share of profit from the date of last balance sheet
to the date of death based on last year’s profit.
4)Share of goodwill on the basis of twice the average
of past 3 years’ profits.
Profits for 2004, 2005 and 2006 were:
Rs.18000, Rs.24000 and Rs.21000 respectively.
A’s executors to be paid 50% of the amount due
immediately and the balance was to be transferred to a
loan account carrying interest at 6% per annum.
Prepare A’s account to be rendered to his executors.
16. Yasim Ltd. offered 20000 preference shares of Rs.100 [8]
each at a premium of Rs.10 each payable as follows:
On application Rs.30
On allotment Rs.40 (including premium)
On 1st call Rs.20
On final call – the balance.
Applications were received for 40000 shares and
allotment was made pro-rata to the applicants of 30000
Page 4 of 8
shares. The remaining applications were rejected.
Manoj who applied for 1500 shares failed to pay the
allotment money and on his subsequent failure to pay
the first call his shares were forfeited. Mohan
holding 2000 shares failed to pay two calls and these
shares were forfeited after the final call. 2500 of
these shares were reissued at Rs.90 per share as fully
paid up (the whole of Manoj’s shares being included).
Pass journal entries in the books of the company for
recording the above transactions.
OR
Pioneer Ltd. Offered 50000 equity shares of Rs.10 each
at a discount of 5% payable as follows:
On application Rs.2
On allotment Rs.3
On 1st call Rs.3
On final call – the balance.
Applications were received for 75000 shares.
Applications for 15000 shares were rejected and the
remaining applicants got a pro-rata allotment. Pawan
holding 2000 shares, failed to pay the allotment and
1st call money on his shares and those shares were
forfeited and Dhawan holding 1000 shares failed to pay
the 2 calls. These shares were forfeited after the
final call. Out of these 2000 shares were reissued at
Rs.9 as fully paid (the whole of Dhawan’s shares being
included). Pass journal entries in the books of the
company.
17. Pass journal entries in the following cases at the [4]
time of dissolution.
a) Payment of unrecorded liabilities of Rs.5200
b) Stock worth Rs.10000 is taken over by a partner
Rahul.
c) Profit on realization amounting to Rs.18000 is to
be distributed between the partners Rohit and
Rahul in the ratio 5:7.
d) An unrecorded asset realized Rs.4000.
18. The following is the balance sheet of A and B, sharing [8]
profits in the ratio of 3:1, on 31.12.2003
Liabilities Assets
Creditors 75000 Cash at Bank 45000
Reserve fund 8000 Bills receivable 6000
Capitals Accounts: Debtors 32000
A 60000 Stock 40000
B 32000 Furniture 2000
Buildings 50000
______ ______
Page 5 of 8
165000 165000
On 01.01.2004 they agreed to admit C into partnership
on the following terms.
1) C brings 28000 as his capital for 1/5th share in
profits.
2) C brings 4000 as premium for 1/5th share, which
is withdrawn by A and B.
3) Stock and furniture to be depreciated by 10% and
provision of 5% is required on Debtors for
doubtful debts.
4) Building has to be appreciated by 20%.
The capital of A and B to be adjusted in the new
profit sharing ratio taking C’s capital as the basis.
Prepare revaluation account, capital account and
Balance Sheet of A,B and C.
OR
X,Y and Z are partners sharing profits and losses in
the ratio of 3:2:1 respectively. Their balance sheet
on 31.12.2006 was as follows:
Balance Sheet on 31.12.2006
Liabilities Assets
Bills payable 6000 Land & Buildings 20000
Sundry Creditors 14000 Machinery 15000
Reserves 6000 Furniture 6000
Capitals: Stock 11000
X 15000 Sundry Debtors 10000
Y 10000 - Reserve for 500
Z 14000 Bad debts 9500
Cash 3500
_____ _____
65000 65000
Y retires from the business and the partners agree to
the following:
1) Building and furniture appreciated by 20%.
2)Machinery and stock to be depreciated by 10% and 5%.
3) Reserve 10% on debtors for had and doubtful debts.
4) Goodwill of the firm was valued at 18000 and Y’s
share thereof to be adjusted without opening a
goodwill account. Y was to be paid off through cash
brought in by X and Z in such a way that their
capitals are in the new profit sharing ratio.
Prepare revaluation account, capital account and
balance sheet of X and Z after Y’s retirement.
Part B [Analysis of financial statements]
19. A company earns a gross profit of 25% on cost. Its [1]
credit sales are twice its cash sales. Its credit
sales are Rs.60000. Calculate the gross profit ratio
Page 6 of 8
of the company.
20. State two advantages of financial analysis. [1]
21. From the following details prepare a comparative [3]
balance sheet of X Ltd. as on 31.12.2006
Balance Sheet of X Ltd.
Liabilities 2005 2006 Assets 2005 2006
Equity Share Fixed Assets 450000 540000
Capital 375000 375000
Reserves & Investments 75000 75000
Surplus 75000 90000
Secured Current
loans 225000 225000 Assets 225000 157500
Current
Liabilities 60000 66000
Prov. for
taxation 15000 16500
______________ ______________
750000 772500 750000 772500
22. State the headings under which the following items [2]
will be shown in the balance sheet of a company
prepared under schedule VI of the Companies Act, 1956.
a) Live stock
b) Forfeited shares account.
c) Underwriting commission.
d) Shares in ICICI Ltd.
23. From the following information, find out the cost of [3]
goods sold, sales and closing stock.
a) Stock velocity : 8
b) Gross profit ratio : 25%
c) Gross profit : 120000
d) Closing stock was Rs.5000 in excess of opening
stock.
24. From the following details calculate the inflow and [4]
outflow of cash from financing activities.
Particulars 01.01.2007 31.12.2007
Equity share capital 1000000 1500000
12% Debentures 600000 400000
Additional information:
1) During the year equity shares of Rs.200000 were
issued to the vendors of machinery purchased.
2) Debentures were redeemed at a premium of 10%.
Page 7 of 8
25. The balance sheet of Alpha Ltd. as at 31.12.2006 and [6]
31.12.2007 were as follows:
Liabilities 31.12.06 31.12.07 Assets 31.12.06 31.12.07
Equity Share Fixed Assets 660000 810000
Capital 300000 350000
Investments 30000 80000
Preference
share capital 200000 100000 Other current
assets 200000 300000
14% Debentures 100000 200000 Cash 40000 75000
Profit & Discount on
Loss app a/c 110000 270000 issued
debentures 10000 5000
Current
Liabilities 80000 160000
Accumulated
Depreciation 150000 190000
______________ ______________
940000 1270000 940000 1270000
Additional information:
a) Machinery costing 70000 (book value Rs.40000)
was sold for Rs.25000.
b) Preference shares were redeemed at a premium of
15%.
You are required to prepare a cash flow statement as
on 31.12.2007.
Page 8 of 8
055/2
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ACCOUNTANCY (THEORY)
Grade: XII Max. Marks: 80
Date: Time: 3 hours.
----------------------------------------------------------
General Instructions:
1.This question paper consists of two parts A and B.
2.Part A is compulsory for all candidates.
3.Candidates can attempt only one of the remaining parts B.
4.All parts of a given question should be attempted at one
place.
PART A
(Not for Profit Organisation, Partnership Firms and Company Accounts)
1. State two differences between Income and expenditure [1]
account and receipts and payments account.
2. X and Y are partners in a firm. During the year X withdrew [1]
Rs2000 at the end of every quarter and Y withdrew Rs1000
at the end of every month for the first 6 months.
Calculate interest on drawings to the charged to X and Y
at the rate of 12% per annum.
3. A, B and C are partners in a firm sharing profits and [1]
losses in the ratio of 3:2:1. On 31.12.08 B retired and
his share was taken over by A and C in the ratio of 1:1.
Calculate the new profit sharing ratio.
4. A and B are equal partners in a firm. They admitted C [1]
into the firm for 1/4th share. C brings Rs1000 for
goodwill out of his share of Rs1800. Pass a journal entry
for adjusting C’s share of goodwill.
5. What is collateral security? [1]
6. Show how will you deal with the following information in
different cases while preparing financial statements of a
club for the year ended 31.12.08.
Prizes awarded Rs150000. [3]
Prize fund on 31.12.07 Rs.600000.
Donations for prize fund Rs50000.
Prize fund investment on 31.12.07 Rs.600000.
Interest received on investment Rs.75000.
Page 1 of 7
7. X Ltd acquired a building costing Rs720000 from Y Ltd. [3]
Rs90000 was paid in cash and the remaining amount was
settled by issue of 10% debentures of Rs.100 each at a
discount of 10%. Pass journal entries.
8. A Ltd had an authorized capital of Rs20000000 divided [4]
into equity shares of Rs10 each. A Ltd issued 50% of the
shares at a premium of Rs2 per share payable as follows:
On application Rs2
On allotment Rs5 (including premium)
On 1st call Rs2
On final call Rs3
The company received applications for 1200000 shares. The
company rejected applications for 200000 shares and
allotted shares to the remaining. The directors did not
make the final call. Arjun, the holder of 1000 shares
failed to pay the allotment and 1st call. You are required
to show the details of share capital in the balance sheet
of A Ltd as per requirement of the companies Act 1956.
9. X and Y are partners in a firm sharing profits in the [2]
ratio of 3:2. Their capitals were fixed at 200000 and
100000 respectively. They were entitled to interest at
the rate of 10% on capital. The firm made a profit of
Rs20000 in the year 2009. You are required to distribute
the profits assuming that the partnership deed provided
for payment of interest on capital only.
10. Ajith, Akash and Arjun were partners in a firm sharing [2]
profits and losses in the ratio 3:2:1. They decided to
share the profits and losses in equal proportion with
effect from 31.12.08. For this purpose goodwill was
valued at Rs90000. The books showed a general reserve of
Rs30000 and a debit balance in the P & L account to the
extent of Rs15000. You are required to pass an adjustment
entry for making the above changes without disturbing the
accounts relating to general reserve and P & L account
and not recording goodwill in the books.
11. Anjana Ltd. forfeited 200 shares of Rs10 each held by [3]
‘Akash,’ issued at a discount of 5%, on which he had paid
Rs3 on application and Rs.4 on allotment. Half of these
shares were reissued to Anand at Rs9.50 as fully paid up.
Pass journal entries in the books of the company for
recording the above transactions.
12. a) Beta Ltd issued 200000, 10% debentures of Rs100 each [3]
on 1.1.2005 redeemable at a premium of 10% after 4 years.
The company decided to create necessary reserve as per
the companies Act. Pass journal entries for issue of
debentures.
Page 2 of 7
12b On 1.1.2006 Teja Ltd. had outstanding 10% debentures of [3]
Rs200000. On 31.12.06 the company decided to redeem
Rs75000 of the debentures and bought Rs50000 debentures
in the open market at Rs98 each and redeemed the
remaining debenture by drawing lot. The expenses on
purchase of own debentures amounted to Rs500. Pass
journal entries in the books of the company.
13. Following is the receipts and payments account of a club
for year ended 31.12.04
Receipts and payments account
Receipts Rs. Payments Rs.
To Bal. b/d 10250 By Salaries 6000
To Sub Subscriptions: By Expenses 750
03 400 By Drama expenses 4500
04 20500 By News papers 1500
05 600 By Municipal taxes 400
To Donations 5400 By Electric charges 4950 [6]
To Sale of drama By Furniture 20000
tickets 9500 By Balance c/d 9000
To Sale of waste
papers 450
47100 47100
Additional information
a)Subscriptions outstanding for 2004 – 4500.
b)Subscriptions still in arrears for 2003 – 900.
c)Taxes prepaid Rs100 at the beginning as well as at the
end.
d)Buildings on 1.1.04 amounted to Rs50000.
e)Depreciate fixed assets at 5% p.a.(including additions)
14. Following is the balance sheet of A, B and C as on
31.12.05 sharing profits in the ratio of 2:2:1.
Liabilities Rs Assets Rs
Creditors 40000 Building 30000
General reserve 25000 Plant & Machinery 60000
Capitals: Stock 10000
A 30000 Sundry Debtors 20000
B 25000 Bank 15000
C 15000
135000 135000 [6]
B died on March 31 2006. According to the deed, his legal
representatives are entitled to:
a) Capital balance as per last balance sheet.
b) Share of goodwill valued on the basis of 3 times the
average of the past 4 years profits.
Page 3 of 7
c) His share of profit based on the basis of average
profits for the past 4 years.
d) Interest on capital account @ 10% per annum.
Profits for the past 4 years were 2004-15000, 2005-17000,
2006-19000 and 2007-13000. B’s legal representatives were
to be paid 50% of the amount due immediately and the
balance should be transferred to B’s executors loan
carrying interest at 6% p.a. Show B’s account to be
rendered to the executors of B.
15. Sun enterprises Ltd offered 100000 equity shares of Rs10
each at a premium of 10%. The amount payable was as
follows:
On application Rs.3
On allotment Rs.4 (including premium)
On 1st call Rs.2
On final call – the balance
Applications were received for 130000 shares.
Applications for 5000 shares were rejected and the
remaining applicants got a prorata allotment. ‘Azad’
holding 1000 shares failed to pay the allotment money and [8]
on his subsequent failure to pay the 1st call, his shares
were forfeited. ‘Tiwari’ holding 2000 shares failed to
pay the two calls and his shares were forfeited. 2000 of
the forfeited shares were reissued at Rs8 per share [the
whole of Azad’s shares being included]. Pass journal
entries in the books of the company.
OR
Moon Ltd. issued 60000 equity shares of Rs50 each at a
discount of 10% payable as follows:
On application Rs20
On allotment Rs15
On 1st and final call – the balance
Applications were received for 75000 shares and prorata
allotment was made to all the applicants. Jeevan who
applied for 3750 shares failed to pay the allotment money
and his shares were forfeited immediately. ‘Jwala’
holding 2000 shares failed to pay the call money and
these shares were forfeited. 3500 of these shares were
reissued at Rs40 per share as fully paid up. Pass journal
entries in the books of the company.
16. Pass journal entries in the following cases at the time [8]
of dissolution.
1) Partners wife’s loan Rs20000 was taken over for
Rs18000 by partner X.
2) Plant and machinery worth Rs50000 was taken over by
partner Y at Rs48000.
3) Stock worth Rs20000 was disposed of at a discount of
20%.
Page 4 of 7
4) General reserve of Rs30000 was distributed among
partners X, Y and Z in the ratio of 3:2:1.
17. Following is the balance sheet of A and B who share [8]
profits in the ratio of 3:2.
Balance sheet of A and B as of 1.1.2007
Liabilities Rs. Assets Rs.
Sundry Creditors 40000 Cash at Bank 6000
Capitals: Sundry Debtors 24000
A 60000 Stock in trade 30000
B 40000 Furniture 20000
Plant & Machinery 60000
140000 140000
On the above date C is admitted into the partnership on
the following terms:
1) C is to bring Rs30000 as capital and Rs10000 as
premium for goodwill for 1/6th share.
2) The value of stock is reduced to 90% while plant and
machinery is increased by 10%.
3) Furniture is reduced by Rs1000.
4) A provision of 10% is needed for bad and doubtful
debts.
5) Rs400 is to be provided for outstanding repairs bill.
6) Accrued income of Rs1000 is to be brought into books.
7) An amount of Rs200 included in creditors is not
likely to be paid. The capital accounts of the
partners are to be adjusted in the profit sharing
ratio by bringing in or withdrawing cash, as the case
may be. Prepare a revaluation account, capital
accounts and the balance sheet of the new firm.
OR
The balance sheet of A,B and C who are partners in a firm
sharing profits and losses in the ratio of 2:1:1 as on
31.3.2007 was as follows:
Liabilities Rs. Assets Rs.
Creditors 10500 Building 50000
General Reserve 10000 Machinery 25000
Capitals: Stock 9000
A 40000 Debtors 10000
B 20000 - reserve 500 9500
C 20000 Cash at Bank 7000
100500 100500
On the above date B decided to retire and the following
terms were agreed upon:
1) Building to be increased by 10000.
2) Machinery to be depreciated by 20%.
3) Provision to be created at 15% on debtors for doubtful
debts.
Page 5 of 7
4) Goodwill of the firm to be valued at Rs36000 and B’s
share to be adjusted without raising a goodwill
account.
5) Amount due to B was to be paid in cash brought in by A
and C in such a way that their capitals are in the
profit sharing ratio. Prepare a revaluation account,
capital account and the Balance sheet of A and C.
PART B
(Analysis of Financial Statements)
18. The current ratio of a company is 2:1. State giving reasons [1]
which of the following transactions would improve, reduce
or and not change the current ratio:
1) Repayment of current liability.
2) Purchase of goods on credit.
19. State 2 limitations of financial analysis. [1]
20. From the following details prepare a common size income [3]
statement for the year ended 31.12.04 and 31.12.05.
Particulars 2004 2005
Net sales 250000 247500
Cost of Goods sold 189000 180000
Operating expenses 31250 30000
Depreciation 11000 11000
Income from investments 35000 44500
Income tax 16250 20000
21. State the headings under which the following items will [2]
be shown in the balance sheet of a company prepared under
schedule V1 of the companies act, 1956.
1) Outstanding interest on secured debentures.
2) Securities premium.
3) Preliminary expenses.
4) Public deposits.
22. Calculate the opening debtors and closing debtors from [3]
the following figures:
Debtors turnover ratio: 4 times
Cost of goods sold: 480000
Gross profit is 20% on sales
Closing debtors are 20000 more than at the beginning.
Page 6 of 7
23. From the following details calculate the inflow and [4]
outflow of cash from financing activities.
Particulars 1.1.08 31.12.08
Equity Shares capital 200000 300000
10% Debentures 300000 450000
Additional information:
1) During the year bonus shares were issued to existing
shareholders in the ratio 4:1.
2) Debentures were issued to vendors of machinery
purchased at a cost of 50000.
24. The balance sheet of Sangeeta Ltd. as at 31.12.05 and [6]
31.12.06 were as follows:
Liabilities 31.12.05 31.12.06 Assets 31.12.05 31.12.06
Equity share capital 90000 130000 Fixed Assets 93400 166000
General reserve 10000 15000 Stock 22000 26000
Profit and Loss A/c 20000 30000 Debtors 36000 39000
12% Debentures 20000 40000 Cash 4000 5000
Trade creditors 17400 22000 Preliminary 2000 1000
Exp.
157400 237000 157400 237000
Additional information:
1) Depreciation provided on fixed assets amounted to
Rs.23400.
2) Machinery of the book value of Rs20000 was sold for
Rs.16000.
You are required to prepare a cash flow statement for the
year ended 31.12.06
Page 7 of 7
055/3
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ACCOUNTANCY (THEORY)
Grade: XII Max. Marks: 80
Date: Time: 3 hours.
-------------------------------------------------------
General Instructions:
1.This question paper consists of two parts A and B.
2.Part A is compulsory for all candidates.
3.Candidates can attempt only one of the remaining parts B.
4.All parts of a given question should be attempted at one
Place.
PART A
(Not for Profit Organisation, Partnership Firms and
Company Accounts)
1. What do you mean by fund based accounting? [1]
2. X and Y are partners in a firm. Their capitals were fixed [1]
at 50000 and 30000 respectively. Y had provided a loan of
Rs20000 to the firm. Show the amount of interest
receivable by the partners assuming that they don’t have
a partnership deed.
3. A and B are partners in a firm. During 2009 A withdrew [1]
Rs3000 at the end of every quarter whereas B withdrew
Rs5000 at the end of every six months. Calculate interest
on drawings chargeable to A and B if the rate of interest
is 10% p.a.
4. Define goodwill. [1]
5. What is the difference between redeemable debentures and [1]
convertible debentures?
6. State the amount of stationery to be debited to income [3]
and expenditure account of the year 2009, after
considering the following details. Show also the amounts
to be shown in the Balance sheet on 31.12.09.
Creditors for stationery on 1.1.09 Rs3000
Stock of stationery on 1.1.09 Rs4000
Page 1 of 7
Payment made to creditors in 2009 Rs4000
Advance paid for stationery in 2008 Rs700
Creditors for stationery on 31.12.09 Rs3500
Stock of stationery on 31.12.09 Rs2500
7. Fortune Ltd purchased assets worth Rs500000 from Unlucky [2]
Ltd. The purchase price was settled by a bank draft of
Rs140000 and the balance by issue of 10% debentures of
100 each at a discount of 10%. Pass journal entries.
8. B Ltd had issued 20000 equity shares of Rs10 each payable [3]
as follows:
On application Rs.2
On allotment Rs4
On final call Rs4
Allotment was made on 1st June and Sajith holding 1000
shares paid the final call along with the allotment
money. The final call was due on Sept 1. The company
adopted table A as it’s A/A. Calculate interest on calls
in advance and pass journal entries for recording
interest on calls in advance.
9. P,Q and R are partners with fixed capitals of Rs40000, [2]
Rs30000 and Rs20000 respectively. During the year 2009,
the firm made a profit of Rs30000 which was divided
equally between the partners. Later it was realized that
interest on capital was not provided at the rate of 10%
to make an adjustment entry for the above omission.
10. X, Y and Z are partners in a firm sharing profits and [2]
losses in the ratio of 3:2:1. They decided to share
profits and losses equally with effect from 31.12.09. On
the above date general reserve appeared in the books of
the firm at Rs30000 and goodwill was valued at Rs45000.
You are required to make an adjustment entry to give
effect to the above without disturbing general reserve
and not recording goodwill as an asset in the books.
11. Silver Star Ltd forfeited 1000 shares of Rs10 each (Rs6 [3]
called up) issued at a discount of 10% on which the
shareholder had paid Rs2 as application money. 600 of
these shares were reissued at Rs5 as Rs6 paid up. Pass
journal entries for forfeiture and reissue of shares.
12. Sudarshan Ltd forfeited 2000 shares of Rs10 each (Rs8 [3]
called up) issued at a premium of Rs3 per share for non
payment of the allotment money Rs8 (including premium).
Out of these 1000 shares were reissued at Rs12 as fully
paid up. Pass journal entries relating to forfeiture and
reissue of shares.
Page 2 of 7
13a a) Star Ltd issued 4000, 10% debentures of Rs100 each. [3]
Assuming that all the debentures issued are taken up and
paid for, pass journal entries in the books of the
company in each of the following cases:
1) The Debentures are issued to a supplier of furniture
amounting to Rs450000.
2) The Debentures are issued at par and repayable at a
premium of 3%.
The Debentures are issued at a premium of 5% redeemable
at a premium of 10%.
13b On 1.1.2005 Rama Ltd issued 50000 12% debentures of 100 [2]
each at a discount of 5%. Debenture holders have the
option to convert their holdings into 14% preference
shares of 100 each at a premium of Rs25 per share. On
31.12.2005 a holder of 200 debentures notified his
intention to convert his holdings to preference shares.
Journalise the above transactions.
14. From the following receipts and payments account of a [6]
club and from the additional information provided,
prepare an income and expenditure account for the year
ended 31.12.2003 and a balance sheet as on that date.
Receipts and Payment Account
Receipts Rs. Payments Rs.
To Bal. b/d 2300 By Salaries 4500
,, Sub Subscriptions: 6000 ,, Office expenses 1500
,, Rent of hall 2000 ,, Sports equipment 1000
,, Sale of grass 200 ,, Machinery 2000
,, Sale of furniture 100 ,, 6% investments 1000
,, Balance c/d 600
10600 10600
Subscription received included Rs1000 for 2002 and Rs500
for 2004. Outstanding subscriptions for 2003 amounted to
Rs800. Sports equipment on hand on 31.12.2002 was Rs3000.
The value of this equipment on 31.12.03 was 3100.
Salaries Rs200 for 2003 are yet to be paid. Interest on
investments is accrued for 6 months. On 1.1.03 club
possessed Land and Building valued at Rs1500 and
furniture at Rs600.
Page3 of 7
15. Following is the balance sheet of A, B and C sharing [6]
profit in the ratio 2:1:1 as on 31.12.04.
Liabilities Rs. Assets Rs.
Sundry Creditors 3000 Tools 1000
Reserve fund 3200 Furniture 8000
Capital accounts: Stock 6000
A 10000 Debtors 6000
B 5000 Cash at Bank 5000
C 5000 Cash in hand 200
26200 26200
B died on 31.3.05. Under the partnership agreement the
executors of ‘B’ were entitled to:
a) Amount standing to the credit of his capital account.
b) Interest on capital Rs65.
c) His share of goodwill Rs4000.
d) His share of profit from 1.1.05 to 31.3.05 amounting
to Rs.435.
B’s executors were paid Rs1500 on 1.4.05 and the balance
in four equal yearly installments starting from 31.3.06
with interest at 6%p.a. Pass necessary journal entries
and show B’s executors account until it is paid.
16. Viba Ltd offered 50000 shares of Rs10 each at a discount [8]
of 10%. The amount was payable as follows:
On application Rs2
On allotment Rs3
On 1st and final call – the balance
Applications were received for 65000 shares. Applications
for 5000 shares were rejected and pro rata allotment was
made to the remaining applicants. ‘Kumar’ holding 2000
shares failed to pay the allotment money and his shares
were forfeited before the call. Kailash holding 3000
shares did not pay the call money and as a consequence his
shares were forfeited. All the forfeited shares were
reissued to ‘Kamal’ at Rs11 as fully paid up. Pass
necessary journal entries for recording the above
transactions.
OR
A company issued for public subscription 60000 shares of
Rs10 each at a premium of Rs2 per share payable as
follows:
On application Rs2
On allotment Rs5 (including premium)
On first call Rs2
On final call Rs3
Applications were received for 80000 shares. The company
rejected applications for 5000 shares and the remaining
Page 4 of 7
applicants got a pro-rata allotment. Excess application
money was adjusted towards allotment except in the case
of those rejected. Sethi holding 3000 shares failed to
pay the allotment money and the 2 calls. ‘Bimal’ holding
2000 shares failed to pay the 2 calls. All these shares
were forfeited and 4000 of these were reissued to
‘Shankar’ at Rs7.50 per share as fully paid [all the
shares of Sethi being included]. Pass journal entries in
the books of the company.
17. What journal entries would you pass for the following [4]
transactions on the dissolution of a firm after the
various assets (other than cash) and outside liabilities
have been transferred to Realisation account?
1) Bank loan Rs20000 was paid.
2) Stock worth Rs25000 was taken over by Partner B.
3) Partner A agrees to take over a creditor Rs30000.
4) Profit on realisation Rs18000 is to be distributed
between A and B in the ratio 5:4.
18. A, B and C are partners sharing profits in the ratio of [8]
3:2:1 respectively. The balance sheet of the firm on
31.12.2004 was as follows:
Liabilities Rs. Assets Rs.
Sundry Creditors 25200 Cash in hand 8200
Provident Fund 6000 Debtors 60000
Reserve fund 18000 Less prov.: 2000 58000
Capital: Stock 50000
A 80000 Investments 20000
B 73000 Patents 10000
C 40000 Plant & Machinery 96000
242200 242200
C retired on 31.12.04 on the basis of the following
terms:
1) Goodwill of the firm was valued at 54000, partners
decided not to show goodwill in the books of the new
firm.
2) Patents to be reduced by 20% and plant and machinery
by10%.
3) Provision for bad and doubtful debts to be raised to
6%.
4) Investments were valued at 31600.
5) Liability for provident fund was to be reduced by
Rs1000.
Page 5 of 7
C was to be paid in cash brought in by A and B in such a
way that their capitals are in profit sharing ratio and
leaving cash in hand at Rs10000. Prepare revaluation A/c,
partners’ capital accounts and new balance sheet.
OR
The following is the balance sheet of X and Y who had
been sharing profits and losses in the ratio of 3:1 on
31.12.2005.
Liabilities Rs. Assets Rs.
Creditors 75000 Cash at Bank 45000
Contingency reserve 8000 Bills receivable 6000
Capital accounts: Sundry Debtors 32000
X 60000 Stock 40000
Y 32000 Furniture 2000
Land & Building 50000
175000 175000
They agreed to take Z into partnership on 1.1.2006 on
the following terms:
1)That Z brings in proportionate capital for acquiring
1/5th share in the future profits.
2)That goodwill of the firm was valued at 40000 and Z
brought his share of goodwill in cash.
3)Stock and furniture are to be reduced by 10%.
4)That the value of land and building be increased by 20%.
Prepare a revaluation account, partners’ capital accounts
and the Balance sheet of the new firm.
PART B
(Analysis of Financial Statements)
19. The current ratio of a company is 2:1. The company issued [1]
equity shares of Rs100000 to a short term creditor. What is
the effect of the above transaction on the current ratio?
20. List two objectives of financial analysis. [1]
21. Prepare a comparative income statement from the following [3]
details:
Particulars 31.3.08 31.3.09
Rs Rs
Sales 250000 400000
Cost of Goods sold 150000 250000
Direct expenses 20000 10000
Indirect expenses 15000 20000
Income tax 50% 50%
Page 6 of 7
22. State the headings under which the following items are to [2]
be shown in the balance sheet of a company as per
schedule VI of Companies Act 1956.
1) Outstanding interest on secured loans
2) Forfeited shares account
3) Deferred revenue expenditure
4) Unclaimed dividend
23. What do you mean by cash and cash equivalent? [1]
24. If the cost of goods sold is 180000 and inventory [3]
turnover 6 times, calculate the value of opening and
closing stocks assuming that stock at the beginning is
1.5 times the stock at the end.
25. From the following details calculate the inflow and [3]
outflow of cash to be shown under investing activities.
Machinery (1.1.2008) 2000000
Machinery (31.12.2008) 3500000
Accumulated depreciation on machinery (1.1.08) 300000
,, ,, ,, ,, (31.12.08) 450000
During the year machinery costing 100000(acc depreciation
Rs40000) was sold for 50000.
26. Prepare a cash flow statement from the following [6]
statement information.
Balance Sheet
Liabilities 2004 2005 Assets 2004 2005
Equity shares 500000 700000 Patents 100000 95000
Profit& Loss A/c 200000 350000 Equipments 200000 230000
Bank Loan 100000 50000 Furniture 300000 270000
Prop. dividend 50000 70000 Investments 100000
Provision for Debtors 80000 120000
taxation 30000 50000 Stock 50000 130000
Creditors 50000 45000 Cash 5000 27000
Outstanding Rent 5000 7000 Bank 20000 300000
935000 127200 935000 127200
During the year, Equipments costing Rs80000 were
purchased. Loss on sale of equipment amounted to Rs5000.
Depreciation provided on equipment and furniture amounted
to Rs15000 and Rs30000 respectively.
Page 7 of 7
066/1
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ENTREPRENEURSHIP
TIME: 3 hrs Max Marks: 70
General Instructions:
i. All questions are compulsory.
ii. Marks are indicated against each question
iii. Questions No.1 to 5 are very short answer
questions carrying 1 mark each. Answer to each of
these should not exceed 15 words.
iv. Questions No.6 to 10 are short answer questions
carrying 2 marks each. Answer to each of these
should not exceed 50 words.
v. Questions No.11 to 17 are short answer questions
carrying 3 marks each. Answer to each of these
should not exceed 75 words.
vi. Questions No.18 to 21 are short answer questions
carrying 4 marks each. Answer to each of these
should not exceed 150 words.
vii. Questions No.22 to 24 are long answer questions
carrying 6 marks each. Answer to each of these
should not exceed 250 words.
1. Give any 2 entrepreneurial competencies which the
entrepreneurs may require to manage their own
motivation in order to shoulder the responsibility
effectively. 1
2. What are strategies? 1
3. What are the major factors to be kept in mind
while purchasing materials? 1
4. Name two factors that determine the location of an
enterprise. 1
5. What do you mean by the term ‘Target Market’? 1
6. Explain with the help of an example the term
‘collateral’. 2
7. Why does an entrepreneur need a feasibility plan? 2
8. Identify any four problems faced by the first
generation entrepreneurs. 2
9. Mention the incentives and facilities provided by
the government that encourage and develop
entrepreneurship. 2
10. What is meant by marketing orientation? 2
11. Explain the factors that are involved in the
process of sensing opportunities. 3
12. Discuss the importance of ‘No Objection
Certificate’. 3
13. Describe ‘Financial profile’ and ‘Futuristic
projections’ as a characteristic of a feasibility
plan. 3
14. How does the project report help the entrepreneur
in taking decisions? 3
15. Why is the customer called a King? 3
16. Differentiate between shares and debentures on the
basis of:
a) Right to vote
b) Return
c) Charge on assets 3
17. Explain the features of ‘Factoring’ as a source of
finance. 3
18. Illustrate with viable examples the factors that
influence growth. 4
19. Discuss any four areas of work in which the
entrepreneur must shoulder the social
responsibility effectively. 4
20. How are financial resources important for an
enterprise? 4
21. Explain the various aspects to be considered by an
entrepreneur while assessing the market. 4
22. ‘Scanning of environmental factors is considered
as an interface between spotting and product
identification’- Discuss.
6
OR
Idea fields can be described as convenient frames
of reference for generating ideas. Elaborate those
Idea fields.
23. Ashwathi sells designer wear sarees to Vinaya, who
agrees to make the payment after three months –
Ashwathi agrees and claims the same must be done
within six months.
Name and explain this source of finance which
Ashwathi claims for. Also explain any other two
sources of finance that can be done on monthly
basis.
OR 6
The proportion of current assets to total assets
measures the requirements of working capital. Name
this factor that determines working capital and
also list three other factors that determine the
above.
State with reason the working capital requirements
for the following:
a)Automobile enterprise; b)Real estate enterprise;
c)Hotel enterprise and d)Transport services.
24. Physical, Technical and Human Resources are
various types of resources. Emphasize on the
importance of these resources.
6
OR
Describe in detail any four aspects of a Project
Report.
--------------------------------------------------
066/2
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ENTREPRENEURSHIP
TIME: 3 hrs Max Marks: 70
General Instructions:
i. All questions are compulsory.
ii. Marks are indicated against each question
iii. Questions No.1 to 5 are very short answer
questions carrying 1 mark each. Answer to each of
these should not exceed 15 words.
iv. Questions No.6 to 10 are short answer questions
carrying 2 marks each. Answer to each of these
should not exceed 50 words.
v. Questions No.11 to 17 are short answer questions
carrying 3 marks each. Answer to each of these
should not exceed 75 words.
vi. Questions No.18 to 21 are short answer questions
carrying 4 marks each. Answer to each of these
should not exceed 150 words.
vii. Questions No.22 to 24 are long answer questions
carrying 6 marks each. Answer to each of these
should not exceed 250 words.
1. List any 2 marketing functions under the head
‘Facilitation’. 1
2. What is meant by Demand driven ideas? 1
3. What do you understand by the term Product mix? 1
4. Installation of machinery has to be done with
great care. Give two reasons to support your
answer. 1
5. What does psychographic segmenting show? 1
6. Mr. Daniel claims that preparing a project report
is useless especially when there is less
intervention of governmental authorities.
Enlighten your answer in reference to the above
statement. 2
7. What should the entrepreneur do to mobilize
resources? 2
8. What is called the stage of consolidation for an
enterprise? 2
9. Mention the supporting agencies provided by the
government that encourage and develop
entrepreneurship. 2
10. What is meant by retained profits? State the other
name of it. 2
11. Discuss any three idea fields. 3
12. Explain the importance of preliminary project 3
report.
13. Describe ‘Attributes of the product’ and 3
‘Operational plan’ as a characteristic of a
feasibility plan.
14. Why is technical feasibility study essential? 3
15. List any 3 aspects that the production manager 3
should have in his action plan.
16. Differentiate between Owner’s funds and Borrowed 3
funds on the basis of:
a) Risk Capital
b) Permanence
c) Security of assets
17. Explain the features of ‘Leasing’ as a source of 3
finance.
18. Illustrate with viable examples any 4 techniques
of sales promotion. 4
19. Discuss the various inputs that go into designing
a sales budget. 4
20. How are technical resources important for an
enterprise? 4
21. Explain any four process of testing ideas for
assessing their opportunity potential. 4
22. Explain the different factors that are involved in
the process of sensing opportunities.
OR 6
Describe the different stages involved in setting
up a Small Scale Enterprise.
23. TVS, a famous Indian company started as an
enterprise in transport. Soon it enlarged into
manufacturing brakes linings, tyres and
motorcycles. Name and explain this activity that
sustains growth and also explain two other
activities with examples that sustains growth.
OR 6
Tom is a small entrepreneur involved in the
manufacture of toys. He wants to make 500 pencil
cases for which he calculates the cost of raw
materials, wages of labour and expenses for making
the toys.
Name and explain this category of cost and also
explain other two categories of cost with viable
examples.
24. Financial ratios are devices for measuring
financial conditions of financial changes.
Describe some important financial ratios.
OR 6
Physical, Financial and Human Resources are
various types of resources. Emphasize on the
importance of these resources.
--------------------------------------------------
066/3
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
ENTREPRENEURSHIP
TIME: 3 hrs Max Marks: 70
General Instructions:
i. All questions are compulsory.
ii. Marks are indicated against each question
iii. Questions No.1 to 5 are very short answer
questions carrying 1 mark each. Answer to each of
these should not exceed 15 words.
iv. Questions No.6 to 10 are short answer questions
carrying 2 marks each. Answer to each of these
should not exceed 50 words.
v. Questions No.11 to 17 are short answer questions
carrying 3 marks each. Answer to each of these
should not exceed 75 words.
vi. Questions No.18 to 21 are short answer questions
carrying 4 marks each. Answer to each of these
should not exceed 150 words.
vii. Questions No.22 to 24 are long answer questions
carrying 6 marks each. Answer to each of these
should not exceed 250 words.
1. Name any two activities that have to be carried
out to create the demand for a good or a service.
1
2. State the main objectives of trained manpower. 1
3. List any 2 methods of inspection of quality
control 1
4. State the two key behavioral characteristics of an
entrepreneur. 1
5. Mention the factors that influence pricing. 1
6. The company manager feels ‘Development of quality
essentially lies in the hands of the working
team’. Name and explain this feature of a
feasibility plan. 2
7. Why is a project report required? 2
8. Define a Planning paradigm. 2
9. Identify any four ways in which creative ideas can
be created. 2
10. What is meant by cash credit? 2
11. Explain the creative and practical framework with
a diagram. 3
12. Describe any three ways in which ideas can be
generated. 3
13. Discuss ‘Executive summary’ and ‘Objectives of the
business’ as a characteristic of a feasibility
plan. 3
14. How can costs be classified? 3
15. What are the features of effective communication? 3
16. Differentiate between Preference share and Equity
share on the basis of:
a) Voting rights
b) Redemption
c) Convertibility 3
17. Explain the advantages of ‘Retained profit’ as a
source of finance. 3
18. Illustrate with viable examples the classification
of consumer products. 4
19. How does the consumer’s buying habits affect the
distribution pattern? 4
20. What are the major objectives of preparing the
project report? 4
21. Describe in brief the different stages involved in
the establishment of a small scale unit. 4
22. Explain the process of testing ideas for assessing
their opportunity potential.
6
OR
What are the resources needed to start, sustain
and develop an enterprise? What factors decide the
relative importance of the resource
23. Some entrepreneurs adopt different prices from
different customers upon the prevailing market
situation. Name this pricing method. Explain with
examples the considerations which decide this kind
of pricing.
OR 6
Mr. Sam has some old stock of garments and
footwear and he wants to clear this stock of
goods. Illustrate with examples the different
sales promotional tools that he can adopt to clear
the stock of goods.
24. Explain any four aspects of a Project Report.
OR 6
Financial ratios are devices for measuring
financial conditions of financial changes.
Describe some important financial ratios.
--------------------------------------------------
CENTRE FOR THE ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(Gems Asian Schools)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION
GRADE - XII
Subject: Business Studies 054/1
Time allowed: 3 hours Maximum Marks: 100
General Instructions:
(i) Answer to questions carrying 1 mark may be from one
word to one sentence.
(ii) Answer to questions carrying 3 marks may be from 50
to 75 words.
(iii) Answer to questions carrying 4-5 marks may be
about 150 words.
(iv) Answer to questions carrying 6 marks may be about
200 words.
(v) Attempt all parts of a question together.
1. Banking sector reforms have led to easier credit terms
and better services. This is an example of a key
component of the ‘Business Environment’. Name the key
component. 1
2. ‘Competitive Spirit’ is an advantage derived through
external sources of recruitment. Explain. 1
3. Taylor believed that there was only one best method to
maximise efficiency. This method can be developed
through study and analysis. Which principle
is indicated by Taylor. 1
4. Distinguish between the principle of ‘unity of command’
and ‘unity of direction’ on the basis of ‘aim’. 1
5. ‘Planning is not a solution to all problems’. ‘Planning
is not a useless exercise despite its limitations’.
Which of these statements is correct? 1
6. How does planning involve choice? 1
7. Promotion is a vertical shifting of employees. How does
it affect the employees? 1
8. Controlling should not be misunderstood as the last
function of management. Why? 1
9. Why should business firms aim at long-term profit?
maximisation through customer satisfaction? 1
10. Which consumer right entitles the consumer to get
relief in case the product or service fall short of his
expectations? 1
11. Explain the significance of the terms ‘efficient
utilization of resources’ and ‘effectiveness’ in
management. 3
12. Explain how proper financial management helps in the
growth of business. 3
13. The Directors of a newly established company having
paid up equity share capital of Rs.2.5 crores, desire
to get its shares traded at an All India level Stock
Exchange. As Finance Manager of the company, suggest
the name of the Stock Exchange for the purpose. Give
any two reasons in support of your answer. 3
14. Explain the following functions of marketing.
(i) Product designing and development
(ii) Standardization and grading
(iii) Customer support services. 3
15. State any three factors affecting financial planning. 3
16. Identify the process by which a manager synchronizes
the activities of different departments and explain any
of its three features. 4
17. How the economic changes initiated by the Government of
India influences the working of Indian business.
Explain the impact of changes under:
(a) ‘Threat from MNC’
(b) Buyer’s market. 4
18. Ram a sales manager, achieved his sales targets one
month in advance. This achievement was displayed on the
notice board and a certificate for the best performance
was awarded to him by the CEO of the company.
(a) Name the incentive provided to Ram.
(b) Identify the type of incentive.
(c) List two other incentives of the type identified in
part (b). 4
19. The business of Alpha-Beta-Gama-Ltd. is on a large
scale. Smt. Rukmani is the CEO of the company. She
directs the Marketing Manager that he can take
decisions to spend upto Rs. 1 lakh in order to improve
the performance of his division. For example, if the
Marketing Manager wishes to run an advertising
campaign within the limit of Rs. 1 lakh, then this
decision can be taken without the consent of the CEO.
This authority is not delegated to the remaining
Departmental heads. After the umpteen times insistence
of other departmental managers, they are provided with
this authority. After some days, another decision was
taken with which authority was further delegated by
Departmental Managers to their supervisors.
(a) What would you call the authority given to the
Marketing Manager to take decisions upto Rs.1 lakh?
(b) What does the change introduced in the organization
with the delegation of authority to all the
Departmental Managers signify?
(c) The filtration of authority to the level of
Supervisors – what does this situation indicate?
(d) Distinguish between delegation of authority and
decentralization on the basis of ‘Purpose’. 4
20. What are the main features of the Consumer Protection
Act, 1986? 4
21.Why is budgeting important in controlling and planning?5
22. Identify the method of sales-promotion in the
following cases :
(a) A mobile company offers a discount of Rs.1000 to
clear off excess inventory.
(b) A Company offers a pack of ½ kg. of sugar with
the purchase of a 5 kg. bag of wheat flour.
(c) A company offers 40% of extra shaving cream in a
pack of 500 grams.
(d) Scratch a card and get a gold coin with the
purchase of a cold drink.
(e) Purchase goods worth Rs.50,000 and get a holiday
package worth Rs.10,000 free. 5
23. ‘F’ limited was engaged in the business of food
processing and selling its products under a popular
brand. Lately, the business was expanding due to good
quality and reasonable prices. Also, with more people
working the market for processed food was increasing.
New players were also coming in to cash in on new
trend. In order to keep its market share in the short
run the company directed its existing workforce to work
overtime.
But this resulted in problems. Due to the increased
pressure of work the efficiency of the workers declined.
The divisions that were previously working on one
Product were also made to work on two or more products.
This resulted in a lot of overlapping and wastage. The
workers were becoming undisciplined. The spirit of
teamwork, which had characterised the company
previously, was beginning to wane. Workers were feeling
cheated and initiative was declining. The quality of the
product was beginning to decline as also the market
share. Actually the company had implemented changes
without creating the required infrastructure.
(a) Identify the Principle of Management violated by the
company.
(b) What steps should the company management take in
relation to the above principle to restore the
company to its past glory? 5
24. Which type of plan is referred through each of the
following statements? Name the plan and give an example
for each one.
(a) They are defined as ends which the management seeks
to achieve by its operations.
(b) These are general statements that guide thinking or
channelize energies towards a particular direction.
(c) They provide details in the exact manner in which
any work is to be performed.
(d) They provide the prescribed ways or manner in which
the task has to be done considering the objective.
(e) These are specific statements that inform what is to
be done and it does not allow for any flexibility. 5
25. “Securities and Exchange Board of India (SEBI) is the
watchdog of the securities market.” Do you agree? Give
four reasons in support of your answer. 5
26. Distinguish between formal and informal organisation on
the basis of:
(a) Formation (b)Purpose (c)Structure (d)Behavior of
members (e) Stability (f) Adherence to rules
OR
How does organising as function of management help in
bringing administrative efficiency? 6
27. What are the advantages of training and development to
the organisation and to the employees?
OR
What is staffing? Describe briefly the steps involved
in the process of staffing. 6
28.Explain the various barriers to effective communication.
OR
Explain how motivation contributes to the success of
an organisation. 6
29. What is meant by ‘Fixed Capital’? Describe any four
factors which affect the fixed capital requirements of
company.
OR
Explain the following factors to be kept in mind while
determining the capital structure of a company.
(a) Cost of capital.
(a) Risk.
(b) Interest coverage ratio.
(c) Cost of equity.
(d) Stock market conditions.
(e) Debt service coverage ratio. 6
30. How can promotion tools like premium and contests,
free goods and novelties help in motivating
intermediaries like wholesales and retailers?
OR
What is price mix? Explain the factors which should be
considered before fixing price of a product or service 6
***************************
CENTRE FOR THE ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(Gems Asian Schools)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION
GRADE - XII
Subject: Business Studies 054/2
Time allowed: 3 hours Maximum Marks:100
General Instructions:
(i) Answer to questions carrying 1 mark may be from one
word to one sentence.
(ii) Answer to questions carrying 3 marks may be from 50
to 75 words.
(iii) Answer to questions carrying 4-5 marks may be
about 150 words.
(iv) Answer to questions carrying 6 marks may be about
200 words.
(v) Attempt all part of a question together.
1 What is the main focus of principles given by Henry
Fayol and F.W.Taylor? 1
2 Name the process which aims at giving greater role to
the private sector in nation building and a reduced role
to the public sector? 1
3 ‘Activities involved in managing an enterprise are
common to all organisations whether economic, social or
political’. Which characteristic of management is
highlighted in the statement? 1
4 If an organisation does not provide the right place for
physical and human resources, name the principle which
is being violated. 1
5 Control should focus on key result areas (KRAs) which
are important to the success of an organisation. Which
concept is suggested here while analyzing deviations in
performance of activities? 1
6 Name the type of budget indicated in the following
statements:
(a) Anticipated cash inflows and outflows for the
budgeted period.
(b) A statement of estimated quantity and cost of
material required for production. 1
7 Mention some service industries where competition for
Indian firms has increased due to Government policy
changes. 1
8 Directing facilitates introduction of needed changes in
the organisation. Give one example to support this
statement. 1
9 Why are coordination and cooperation complimentary to
each other? 1
10 Financial planning strives to achieve twin objectives.
Enumerate them. 1
11 Nimit and Amit are working in the same organisation but
in different departments. One day at lunch time Nimit
informed Amit that due to recession many people are
going to be retrenched soon.
Name, which type of communication is this. State any two
limitations of this type of communication. 3
12 If planning involves working out details for the future,
why does it not ensure success? Discuss. 3
13 ‘The present marketing is consumer oriented.’ Explain
this statement. 3
14 Mr. Atul Mahajan’s father has a good business of
Electronic goods. Atul wishes to go abroad for further
studies, but his father wants him to join the business.
On the basis of emerging trends, do you think that Mr.
Mahajan should send his son abroad? Give any two reasons
in support of your answer. 3
15 State the meaning and importance of Performance
appraisal. 3
16 “Planning is looking ahead”. Explain this statement and
state any three features of planning. 4
17 Sachin Ltd is manufacturing shirts and has production,
marketing, finance and personnel departments in the
organisation. Name the type of organisational structure
Sachin Ltd is following. State any three advantages of
this kind of Organisational structure. 4
18 Describe the steps involved in the process of
controlling. 4
19 The directors of a company want to modernise its plant
and machinery by making a public issue of shares. They
wish to approach the Stock exchange, while the finance
manager prefers to approach a consultant for the new
public issue of shares. Advice the directors whether to
approach the Stock exchange or a consultant for the new
public issue of shares and why? Also, advice about the
different methods which the company may adopt for the
new public issue of shares. 4
20 How does trading on equity increase the return on equity
shares? Explain with an example. 4
21 “Lack of proper management results in wastage of time,
money and effort”. Do you agree with this statement?
Give reasons in support of your answer. 5
22 Explain briefly the different types of employment tests
used in the selection process. 5
23 How do the techniques of scientific management improve
productivity of workers? 5
24 Distinguish between ‘Capital Market’ and ‘Money Market’
on the following bases:
(a) Participants
(b) Instruments traded
(c) Duration of securities traded
(d) Liquidity
5
(e) Safety
25 Domino’s Pizza has 230 stores across India and over 7000
stores worldwide. It was the first pizza delivery
company in the world to offer online pizza ordering.
Domino’s estimated to have a 20% share of the India
pizza and delivery market.
Domino’s heat wave delivery bags are specially designed
to keep the pizzas oven-hot during delivery. They
contain a patented disc that is preheated as well as
being specially lined. The inner material of the bag is
made of Thinsulate insulation, which eliminates unwanted
moisture and keeps the pizza hot and crisp.
The pizza is contained in a corrugated pizza box. This
design keeps moisture from weakening the box, while
preventing cheese from sticking to the top during
delivery. The packaging also shows company’s logo. It
has been suggested that more than 80% of the pizza’s box
is made from recycled paper.
What factors might be important to the business in
deciding the packaging for its take-away pizzas? 5
26 How does organising as a function of management help in
bringing administrative efficiency?
Or
Explain the meaning of organising and the steps involved
in the process of organising.
6
27 What is price mix? Explain the factors which should be
considered before fixing price of a product or service.
Or
What does ‘Channels of distribution’ refer to?
Explain different factors determining choice of channels
of distribution. 6
28 Explain Maslow’s hierarchy of needs and its importance
in the motivation process.
Or
Explain ‘Assignment of Challenging Jobs’, ‘Recognition’
and ‘Knowledge of results’ as Non – Monetary Incentives. 6
29 You are a finance manager of a company. The board of
directors have asked you to decide the dividend policy
for the company. Explain the factors that you would take
into consideration while determining the dividend policy
for the company.
Or
What is meant by ‘Working Capital’? Describe any five
factors which affect the working capital requirements of
a company. 6
30 Explain the role/functions of consumer organisations and
NGOs in protecting and promoting consumers’ interests.
Or
Explain the following rights of consumers as provided
under the Consumer Protection Act, 1986.
(a) Right to safety
(b) Right to be informed
(c) Right to choose
(d) Right to be heard 6
*************
CENTRE FOR THE ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(Gems Asian Schools)
COMMON REHEARSAL EXAMINATIONS – JANUARY 2010
ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION
GRADE - XII
Subject: Business Studies 054/3
Time allowed: 3 hours Maximum Marks:100
General Instructions:
(i) Answer to questions carrying 1 mark may be from one
word to one sentence.
(ii) Answer to questions carrying 3 marks may be from 50
to 75 words.
(iii) Answer to questions carrying 4-5 marks may be
about 150 words.
(iv) Answer to questions carrying 6 marks may be about
200 words.
(V) Attempt all parts of a question together.
1 Ganesh is working as a supervisor in a company. Due to
his hard work he is promoted to the post of a Production
Manager. Now the post of supervisor is vacant and no one
can be transferred or promoted to his post. Name the
source of recruitment the company will use to fill up
this post and state one advantage of such a source. 1
2 Give a practical example from current scenario to prove
that business environment helps the firm to identify
threats and early warning signals. 1
3 ‘The application of principles of management is dependent
upon the prevailing situation at a particular point of
time’. State and explain the feature referred here. 1
4 What is meant by Work Study? 1
5 Why are rules considered to be plans? 1
6 It helps the manager to look into future and make a
choice amongst various alternative courses of action.
Enumerate the importance of planning indicated here. 1
7 What is case study method of training? 1
What difficulty arises in the control system when 1
8 standards are not defined in quantitative terms?
9 Anand filed a case against ‘Motiram & Sons’ in the
‘National Commission’. He was not satisfied with the
orders given by the ‘National Commission’. Name the
authority where he can appeal against the decision given
by the ‘National Commission’. 1
10 A shopkeeper sold you some spices, claiming that they
were pure. Later a laboratory test showed that those were
adulterated. Suggest any two remedies that are available
to you for the wrong act? 1
11 The directors of Angad Ltd. have decided to modernise the
plant and machinery at an estimated cost of Rs. 1 crore,
but are in a fix whether to issue equity shares or
debentures for this purpose. As finance manager of the
company, advise the directors whether to issue equity
shares or debentures in the interest of the company and
why? 3
12 Name the level of management for a post of a Supervisor
in an organisation. State any two important functions
performed at this post. 3
13 List some examples of the malpractices in capital market
which necessitated for government to set up a separate
regulatory body – SEBI. 3
14 Suggest three benefits of market research to a business. 3
15 Enumerate any three important objectives of financial
planning. 3
16 Identify the process by which a manager synchronizes the
activities of different departments and explain any of
its three features. 4
17 Explain any four positive impacts of Globalization and
liberalization on business and industry in India. 4
18 “Managerial functions cannot be carried out without an
efficient system of communication” Do you agree? Give any
three reasons in support of your answer. 4
19 The Marketing Manager of an organisation has been asked
to achieve target sales of 50 ceiling fans per day. He
delegates the task to 7 sales managers working under him.
Two of them could not achieve their respective targets.
Is the Marketing Manager responsible? Briefly explain the
relevant principle in support of your answer. 4
20 State any four responsibilities of a consumer while
purchasing/consuming/services. 4
21 Controlling provides direction to all activities and
efforts for achieving organisational goals. Give any five
points explaining the importance of controlling. 5
22 What is Marketing Mix? State four factors that influence
a business’s choice of marketing mix. 5
23 Highlight the significance of Management Principles. 5
24 Setting the objectives is the first step in planning.
Briefly discuss the other steps taken by management in
the planning process. 5
25 Distinguish between Primary Market and Secondary Market
on the following basis.
(a) Securities (Trading).
(b) Capital formation.
(c) Location.
(d) Flow of funds.
(e) Determination of price. 5
26 How does organising as function of management help in
bringing administrative efficiency?
OR
Distinguish between Functional Structure and Divisional
Structure. 6
27 Define Human Resource Management. Explain four
specialised activities done by HRM.
OR
Despite the advantages derived from different sources of
recruitment the internal sources and external sources of
recruitment suffer from certain limitations. Enumerate
three such limitations from both internal and external
sources. 6
28 Explain ‘Assignment of Challenging Jobs’, ‘Recognition’
and ‘Knowledge of results’ as Non – Monetary Incentives.
OR
Explain how motivation contributes to the success of an
organisation. 6
29 What is meant by ‘Fixed Capital’? Describe any five
factors which affect the fixed capital requirements of a
company
OR
Explain the following factors to be kept in mind while
determining the capital structure of a company.
(a) Cost of capital.
(b) Risk.
(c) Interest coverage ratio.
(d) Cost of equity.
(e) Stock market conditions.
(f) Debt service coverage ratio. 6
30 Explain different factors determining choice of
channels of distribution.
Or
How can promotion tools like premium and contests, free
goods and novelties help in motivating intermediaries
like wholesales and retailers. 6
***************
030/1
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
COMMON REHEARSAL EXAMINATION - JANUARY 2010
ECONOMICS
TIME ALLOWED: 3 HRS. MAXIMUM MARKS: 100
General Instructions:
1. All questions in both the sections are compulsory.
2. Marks for questions are indicated against each.
3. Questions 1-5 and 17-21 are very short-answer questions
carrying 1 mark each. They are required to be answered in one
sentence each.
4. Questions 6-10 and 22-26 are short-answer questions carrying 3
marks each. Answer to them should not normally exceed 60 words
each.
5. Questions 11-13 and 27-29 are also short-answer questions
carrying 4 marks each. Answer to them should not normally
exceed 70 words each.
6. Questions 14-16 and 30-32 are long-answer questions carrying 6
marks each. Answer to them should not normally exceed 100 words
each.
7. All parts of a question should be answered at one place.
8. Answers should be brief and to the point and the above word
limit be adhered to as for as possible.
SECTION A
Introductory Microeconomics
1. What is the necessity of economizing resources? 1
2. What is the change in demand called when the demand for a
good falls due to a rise in its own price? 1
3. What will be the value of elasticity of demand on any
point on the demand curve if it is a rectangular
hyperbola? 1
4. Which feature separates monopolistic competition from
perfect competition? 1
5. What do you mean by Demand function? 1
Page 1 of 5
6. Distinguish between fixed cost and variable cost 3
7. Suppose the firms TFC is Rs.100 and the marginal cost 3
schedule is the following:
OUTPUT 1 2 3 4 5 6 7
MC(Rs.) 10 20 30 40 50 60 70
(a) Is MC curve U-shaped?
(b) Derive AVC schedule. Will the AVC curve be
U-shaped? Discuss why or why not.
8. While the seller is a price-taker under Perfect 3
Competition, he is a Price-maker under Monopoly.
Explain.
OR
Why is the demand curve facing a firm under Perfect
Competition perfectly elastic?
9. “Choice is the consequence of scarcity”. Explain. 3
10. Explain how Total utility changes with the change in
Marginal Utility. 3
11. Explain the effect of rise in the prices of “related”
goods on the demand for a good X. Use a diagram.
4
OR
Explain the effect of rise in income on the demand for a
good. Use a diagram.
12. The market demand for a good at RS.4 is 100 units. The
price rises and as a result its market demand falls to
75 units. Find out the new price if the price elasticity
of demand for that good is -1.? 4
13. How does the expenditure method tell us about the 4
elasticity of demand?
14. When variable factors are combined with fixed factors, 6
total product, at first, increases and then starts
declining and finally turn negative. Explain the theory
with the help of diagrams.
Page 2 of 5
15. Explain with the help of TR and TC data and with the 6
help of the diagram, how a producer chooses the
maximum profit position.
16. What do you mean by excess supply? Explain with the help 6
of a diagram the effect of excess supply on the price of
the commodity.
OR
At a given price of a commodity, there is excess demand.
Is this price an equilibrium price? If not how will
equilibrium price be reached? use diagrams
SECTION B
Introductory Macroeconomics
17. What is investment? 1
18. Name the instrument through which the commercial banks
remit money at distant places. 1
19. Why is entertainment tax an indirect tax? 1
20. What is cash credit? 1
21. If the Marginal propensity to save is 1, how much will
be the Marginal propensity to consume? 1
22. What are visible and invisible items in the Balance of
Payments accounts? Give two examples of each. 3
23. What is barter system? Briefly explain any two of its
shortcomings.
OR 3
Explain any three developmental functions of commercial
banks?
24. Distinguish between Tax revenue receipts and Non-tax
revenue receipts, giving two examples of each. 3
Page 3 of 5
25. Estimate Gross Value Added at factor cost from the data 3
mentioned below :
(crores)
(i) Sales 500
ii)Opening Stock 30
iii)Closing Stock 20
iv)Purchase of intermediate products 300
v) purchase of machinery 150
vi)Subsidy 40
26. What are Open Market Operations? What is their effect on
the availability of credit? 3
27. What is meant by Fiscal deficit and Revenue deficit?
What problems can the Fiscal deficit create for the 4
economy?
28. What is meant by foreign exchange rate? Why does the
supply of foreign exchange rise when its rate of
exchange rises?
4
OR
Distinguish between autonomous and accommodating items in
BOP
29. Explain with the help of the “Savings=Investment”
approach the determination of equilibrium output and 4
income level in the economy.
30. Are the following included whiles estimating a country
national income? Give valid reasons. 6
a)Financial help given flood victims
b)Profits earned by a company in India which is owned by
a non-resident
c)Profits earned by an Indian bank from its branches
abroad
31. What is meant by deficient demand? How do the following 6
affect it?
(a)Changes in the bank rate
(b)Changes in the taxation rates
OR
How can the problems of excess demand and deficient
demand be overcome?
Page 4 of 5
32. Calculate a) private income b) personal disposable 6
income.
Rs(in crores)
i)Income from domestic product
accruing to the private sector 4000
ii)Savings of non departmental public
enterprises 200
iii)Current transfers from government
administrative departments. 150
iv)Savings of private corporate sector 400
v)Current transfers from rest of the world 50
vi)Net factor income from abroad -40
vii)Corporation tax 60
viii)Direct personal taxes 140
Page 5 of 5
030/2
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
COMM0N REHEARSAL EXAMINATION - JANUARY 2010
ECONOMICS
TIME ALLOWED: 3 HRS. MAXIMUM MARKS: 100
General Instructions:
1. All questions in both the sections are compulsory.
2. Marks for questions are indicated against each.
3. Questions 1-5 and 17-21 are very short-answer questions
carrying 1 mark each. They are required to be answered in one
sentence each.
4. Questions 6-10 and 22-26 are short-answer questions carrying 3
marks each. Answer to them should not normally exceed 60 words
each.
5. Questions 11-13 and 27-29 are also short-answer questions
carrying 4 marks each. Answer to them should not normally
exceed 70 words each.
6. Questions 14-16 and 30-32 are long-answer questions carrying 6
marks each. Answer to them should not normally exceed 100 words
each.
7. All parts of a question should be answered at one place.
8. Answers should be brief and to the point and the above word
limit be adhered to as for as possible.
------------------------------------------------------
SECTION A
Introductory Microeconomics
1. If we move from one point to another on the PPC curve,
what does it signify? (1)
2. How is total utility derived from marginal utility?
(1)
3. What happens to equilibrium price of a commodity if there
is “decrease” in its demand and “increase” in its supply? (1)
4. What is break even price?
(1)
5. How is equilibrium price of a commodity affected when
demand increases less than supply? (1)
Page 1 of 5
6. State three changes leading to the shift of the demand
curve of a consumer to the left. (3)
7. What is monopolistic competition? Can a seller in such a (3)
market influence the price? Explain.
8. “An economy always produces on, but not inside the PPC”-
Defend or refute.
(3)
OR
Explain the problem of “What to produce” with the help of
an illustration.
9. From the following data on the cost of production of a
firm, calculate (a) Average Fixed Cost and (b) Average
Variable Cost of producing 5th unit of output. (3)
Output 0 3 5
TC(1000s) 50 80 120
10. What changes should take place in Total Revenue so that
(a) marginal revenue is positive and constant, and (b)
marginal revenue is falling. (3)
11. A consumer buys 80 units of a good at a price of Rs.4 per
unit.When Price falls,he buys 100 units. If price
elasticity of demand is 1, Find out the new price.
(4)
12. When both under monopoly and monopolistic competition,
the firms demand curve slopes downward, how can we
distinguish which demand is of monopoly and which is
monopolistic competition? (4)
OR
Explain how in the long run equilibrium with free entry
and exit, firms under perfect competition earn zero
abnormal profit.
13. ‘Price and demand are inversely related’. Explain the
reasons. (4)
Page 2 of 5
(6)
14. 1)Classify the following into fixed and variable costs
a)Salary of permanent staff b)Interest payments
c)Wages to daily workers d)Expenditure on raw materials
e)Excise Duty f)Sales tax
2)Why AC curve in the short run “U” shape?
15. State the law of diminishing marginal utility. Explain
the relationship between total utility and additional
utility with the help of a diagram.
OR
Distinguish between an inferior good and a normal good. (6)
Explain the effect of change in income on each, giving
suitable examples.
16. What do you understand by production function? State and
explain the returns to a factor in production. (6)
SECTION B
Introductory Macroeconomics
17. At what level of income, planned savings is equal to
planned investment? (1)
18. Give the formula of Multiplier. (1)
19. Why are borrowings treated as capital receipts? (1)
20. Is income tax a direct tax or an indirect tax? Why? (1)
21. Give reasons why none can refuse to accept the payment in (1)
terms of currency of the country.
22. From the following data related to a firm, calculate its
Net Value Added at market price: (3)
Items Rs.in lakhs
(a) Purchase of materials 30
(b) Depreciation 12
(c) Sales 200
(d) Excise Tax 20
(e) Opening Stock 15
(f) Intermediate consumption 48
(g) Closing Stock 10
Page 3 of 5
23. How is a Deficit budget used to correct deficient demand
in an economy? (3)
OR
Explain “Plan Expenditure” and “Non Plan Expenditure” of
the government. Give an example of each.
24. State three main sources of demand for foreign exchange. (3)
25. Giving reasons, categorize the following into revenue
receipts and capital receipts:
(a) Corporation tax
(b) Dividends on investment made by the government
(c) Loans received from foreign governments (3)
26. Explain the meaning and any two functions of a commercial
bank. (3)
27. List four items of current account and capital account of
BOP account. (4)
28. How is the Central bank different from a Commercial bank?
OR
Give four major functions of a Central bank. (4)
29. An increase of 250 crores in investment in an economy
in total increase in income of Rs.1000 crores. Calculate
the following:
(a) Value of Multiplier
(b) MPC
(c) S
(d) C (4)
30. Explain briefly each of the components of Factor income. (6)
31. Explain the Theory of determination of equilibrium level of
income and employment with the help of aggregate demand and
aggregate supply curves. (6)
Page 4 of 5
32. From the following data, calculate a)private income and
b)personal Disposable income. (6)
a. Income from domestic product accruing to the
private sector 4000
b. Savings of non-departmental public enterprises 200
c. Current transfers from government administrative
d. departments 150
e. Savings of private corporate sector 400
f. Current transfers from rest of the world 50
g. Net factor income from abroad (-)40
h. Corporation tax 60
i. Direct personal tax 140
Page 5 of 5
030/3
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATION
(GEMS ASIAN SCHOOLS)
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
COMMON REHEARSAL EXAMINATIONS - JANUARY 2010
ECONOMICS
TIME ALLOWED : 3 HRS MAXIMUM MARKS: 100
General Instructions:
1. All questions in both the sections are compulsory.
2. Marks for questions are indicated against each.
3. Questions 1-5 and 17 -21 are very short answer questions
carrying 1 mark each. They are required to be answered in
one sentence each.
4. Questions 6-10 and 22-26 are short answer questions
carrying 3 marks each. Answer to them should not normally
exceed 60 words each.
5. Questions 11-13 and 27-29 are also short answer questions
carrying 4 marks each. Answer to them should not normally
exceed 70 words each.
6. Questions 14-16 and 30-32 are long answer questions
carrying 6 marks each. Answer to them should not normally
exceed 100 words each.
7. All parts of a question should be answered at one place.
8. Answers should be brief and to the point and the above word
limit be adhered to as far as possible.
SECTION A
Introductory Microeconomics
1. What do you understand by positive economics? 1
2. Define market period. 1
3. When will rise in demand be called expansion and when
will it be called an increase? 1
1
4. What is equilibrium quantity? 1
5.State the 2 ways by which a monopolist eliminates competition.
1
6. Explain with the help of a diagram the geometric method
of measuring price elasticity of demand. 3
7. ‘Products are homogenous in a competitive market.’ What
is its implication? 3
8. Explain, why production possibility curve is concave to
the origin? 3
OR
Why does an economic problem arise? Explain the problem
of ‘how to produce’.
9. “A firm decided to shift to power loom from handloom”.
Explain the behavior of the supply curve. 3
10. Give meanings of a) Real cost, b)private cost and
c)Social cost. 3
11. Explain a)Elastic demand b)Inelastic demand c)Unitary
Elastic demand with the help of diagrams. Why coefficient
Of price elasticity is always negative? 4
12.“Under perfect competition, the seller is a price taker, 4
but under monopoly he is a price maker”. Prove.
2
OR
What are the important characteristics of monopolistic
competition? Compare firm’s demand curve under monopoly and
monopolistic competition.
13. Explain the effect of following changes on the demand
of a commodity. 4
a. A fall in the price of substitute.
b. A favorable change in the taste of the buyer.
14. Using total cost and total revenue curves, explain the
equilibrium of a producer.
OR
‘To increase the production of a good, only one input is
increased, while all others are held constant’. Explain its
effect on total physical product and marginal physical product
with the help of a diagram. 6
15. Distinguish between change in demand and change in quantity
demanded. Explain any two factors responsible for shift of
demand curve to the left. 6
16. Draw average total cost, average variable cost and marginal
cost in a single diagram. Also explain the relation between
marginal cost and average total cost with its help. 6
3
SECTION B
Introductory Macroeconomics
17. Define propensity to consume. 1
18.When does a situation of deflationary gap arise in an
economy? 1
19. What do you mean by administrative revenue? 1
20. Why is repayment of loans a capital expenditure? 1
21. Name two general utility services provided by
commercial banks. 1
22. From the following data , calculate gross value added
at factor cost 3
Items Rs. In lakhs
i) Sales 500
ii)Change in Stocks 30
iii)Consumption of fixed capital 60
iv) Subsidies 40
v)Purchases of intermediate products 350
vi)Profit 70
4
23) What is a tax? Distinguish between direct and indirect tax.
3
OR
Explain the concepts of ‘Primary deficit’ and ‘Revenue deficit’
in a government budget. What does Primary deficit indicate?
24)Distinguish between revenue expenditure and capital
expenditure. Give two examples of each. 3
25.”Demand curve for foreign exchange is negatively sloped”.
Justify the statement with the help of a diagram. 3
26.Explain any two drawbacks of barter system and how money
helped to overcome the problem of ‘lack of store of value’ in
barter system. 3
27.Explain the economic factors that cause disequilibrium
in BOP. 4
28.How do bank rate help in expanding or contracting credit in
an economy? 4
29. Define saving. Explain the components of S=-a+(1-b)Y
OR
Define Multiplier and derive its value as K= 1/1-Mpc.What can be
its minimum value and why? 4
5
30.Define National Income. Explain the circular flow of
income in a two sector economy. 6
OR
Distinguish between
a) Private income and personal income.
b) Factor payment and Transfer payments
c) Intermediate product and final product
d) Nominal GNP and Real GNP.
31. Draw on a diagram a saving curve for an economy. From it
derive the consumption curve, explain the method of derivation.
Show a point on the consumption curve at which APC=1 6
32.Calculate NNP(fc)by a) Income Method and B) Expenditure
method from the following data. 6
Items Rs.in crore
I. Rent 40
II. Interest 60
III. Private final consumption expenditure 550
IV. Net Exports (-)5
V. Net Factor Income from abroad (-)10
VI. Mixed Income 10
VII. Employee compensation 500
VIII. Profits 100
IX. Government final consumption expenditure 150
X. Net domestic capital formation 45
XI. Net Indirect taxes 30
XII. Depreciation 5
6
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION –JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
INFORMATICS PRACTICES (065)
Set 1
Time Allowed : 3 hours Maximum Marks : 70
Note:
(i)This Question Paper is divided into 3 Sections.
(ii)Section A consists of 30 Marks.
(iii)Section B and Section C are of 20 Marks Each.
(iv)Answer the following Questions after carefully reading the Text.
SECTION A
1. Answer the following Questions
(a) What is the difference between freeware and free 2
software?
(b) What is the advantage of a computerized result 2
analysis system?
(c) Briefly explain review and maintenance stage of SDLC. 2
(d) Why is high performance database and machines needed 2
for data warehouse?
(e) Consider the scenario faced by the administrative 2
block of Cotton Bishop’s High School.The main
building has 20 rooms.Due to logistics problems more
than one class may be conducted in the same
room.(though not at the same time!). But each class
will be conducted only in one particular room.Draw an
E/R diagram to represent this.
2. Answer the following Questions
(a) What do you understand by container controls? 2
(b) Differentiate between event procedure and sub 4
procedure giving suitable examples.
(c) Explain the objects required to program an ADO object 4
model
3. Answer the following Questions
(a) Define Relation, Primary Key with respect to RDBMS 2
(b) What is anchored declaration? State the need of %type 2
(c) What is Exception Handling? Explain the need of 2
DUP_VAL_ON_INDEX.
(d) Explain the following trigger terminology with the 4
help of an example.
trigger timing, trigger restriction, trigger
type,trigger action
1
SECTION B
4. The Meat Is Murder Society have decide to cash in on their bludgeoning
popularity by opening a restaurant of the same name.They encourage
others to join their ethical endeavours by offering strategic discounts
to their members.Below is the form
Object Object Name Description
Type
Form frmMeatMurder The Main Form Object
Text Box txtChapathi To specify number of Chapathis
txtParatha To specify number of Parathas
txtBiryani To specify number of Biryanis
txtAloo To specify number of Aloo
Masala
txtPeas To specify number of Green
Peas Masala
txtTomato To specify number of Tomato
Fry
txtBill To display the Total Bill
Option OptMember Lifetime Member of MIM
Button
optProbation Member on probation
optNonVeg Non Vegetarian
Check Box chkTip To tip the waiter 20 Rs
Command cmdBill To calculate total bill
Button
cmdNext To reset all controls to start
position
2
(a) Write 2 differences between an option button and a check box. 2
(b) Make the textbox txtbill invisible on form load and provide an 1
access key Alt C to the command button “Calculate Bill “
(c) When the command button next customer is clicked, all the text 2
boxes should be cleared and option buttons should be deselected
and check box unchecked.
(d) Write code for click event of cmdBill to calculate total Bill as 2
per the rules below.
Item Unit Price (Rs)
Chapathi 10
Paratha 20
Paneer Biryani 50
Aloo Masala 25
Green Peas Masala 25
Tomato Fry 20
Cost of each food item is the product of the unit price of that
item and the quantity ordered.The Bill is the total cost of all
the food items.Additionally a discount is offered on the Bill
according to the following criteria.
2
Customer status Discount
(percentage of bill)
Lifetime member 20%
Member on probation 10%
Non Vegetarian 0
If the customer is generous to provide a tip, an additional 20 Rs 1
is added to this amount.
Total Bill is Bill – discount + tip
5. Answer the following Questions
(a) What is the Output of the Following Code? 2
Dim x As Integer
x = 1
Do While x <= 8
If (x Mod 2=0 And x < 4) Then
Print "OK"
Else
Print "NOT OK"
End If
If x = 5 Then
x = x * 2
End If
x = x + 1
Loop
3
(b) Rewrite the following VB code segment replacing the If 2
Construct with Select Case Construct.
If St_marks = 0 Or St_marks = 1 Or St_marks = 2 Then
Print "Pathetic"
ElseIf St_marks >= 3 And St_marks < 35 Then
Print "Fail"
ElseIf St_marks >= 35 And St_marks < 60 Then
Print "Below Average"
ElseIf St_marks >= 60 And St_marks < 75 Then
Print "Average"
ElseIf St_marks >= 75 And St_marks < 90 Then
Print "Above Average"
ElseIf St_marks >= 90 Then
Print "Outstanding!"
End If
(c) Write the following code segment using Do…Loop Until: 2
For m = 20 To 0 Step -2
If m Mod 3 = 0 Then
Print m
End If
Next m
(d) Write a Visual basic Function StringReverse which takes a 4
string as argument and returns it reversed.
SECTION C
6. Read the Questions given below and answer accordingly.
(a) Look at the PL/SQL code given below and give the output. 2
DECLARE
m number;
n number;
o number;
BEGIN
m:=-3;
n:=4;
o:=5;
FOR I IN 3..6 LOOP
m:=m-2;
n:=n*2;
o:=o+1;
IF ABS(m)+ ABS (o)> ABS (n) THEN
DBMS_OUTPUT.PUT_LINE(TO_CHAR(m+n+o));
ELSE
DBMS_OUTPUT.PUT_LINE(TO_CHAR(m+n-o));
END IF;
END LOOP;
END;
(b) Identify the errors in the following PLSQL code.Rewrite the 2
code underlining the corrections.
Declare
Y number(2);
Total number(2);
begin
total=0;
4
loop
total=total+y;
dbms_output(total)
y=y-1;
exit if y=-1;
end;
(c) State the explicit cursor attributes? 2
(d) Write a PL/SQL user defined Function Print_Even which takes 2 4
numbers as arguments and returns the sum of all even numbers
between them.
7. Answer the following Questions based on the table Product given below:
Table: Product
Column Name Data Size Description Constraint
Type
Product_Number Number 4Product’s Primary Key
Identification
Number
Product_Name Varchar2 20 Name of Not Null
Product
Brand Varchar2 20 Brand Name of Can only be ‘Samsung’,
the Product ‘Onida’ or ‘Grundig’.
Price Number 8,2 Price of the Can only be in Range
Product 10000 to 50000
Quantity Number 8 Quantity of
the Product
available in
Stock
Supplier_Number Number 2 No of
wholesale
dealer
(a) Write an SQL query to display the details of all the product whose 2
supplier_number is the same as the supplier_number of the
Product_number 111.
(b) Write the SQL command to create a View which contains the product 2
name, quantity,brand,price and supplier number of products whose
Supplier Number is empty, Quantity is not in the range 1 to 10 and
Brand is not Onida or Grundig.
(c) Create a Procedure which takes Product Name and Brand as two 3
arguments. Product name is an IN argument while Brand is an IN OUT
argument.If the Brand of the Product input by the user is the same
as in the table, assign the string ‘CORRECT’ to the IN OUT
argument.If the Brand is not same then Assign the original brand as
in the table to the IN OUT Argument. Display “Brand matching” if the
Brand entered is correct otherwise display the correct brand.
(d) Write PL/SQL code which modifies all product names by appending the 3
first Character of the Brand at the end of each Product name for
items which cost more than 25000.eg if the product name is
LCD_Monitor and brand is ‘Samsung’ the new product name should be
LCD_MonitorS. Display the message ”Names changed”
5
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION –JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
INFORMATICS PRACTICES (065)
SET 2
Time Allowed : 3 hours Maximum Marks : 70
Note:
(i)This Question Paper is divided into 3 Sections.
(ii)Section A consists of 30 Marks.
(iii)Section B and Section C are of 20 Marks Each.
(iv)Answer the following Questions after carefully reading the Text.
SECTION A
1. Answer the following Questions
(a) State one advantage of Mozilla firefox and Appache web 2
server.
(b) What do you understand by the Personnel Management System? 2
(c) What do you understand by “on site observation”? 2
(d) What is Metadata? State any two contents of metadata. 2
(e) Identify the type of relationship represented by the 2
following statements and draw an entity relationship
diagram to show it.
A tourist company organizes many tours. Each tour is
managed by one tour manager
2. Answer the following Questions
(a) Differentiate between design mode and run mode of a visual 2
basic form.
(b) Define a module. Sate the different modules in a VB 4
project with their file extensions. Also state the need of
sub main()?
(c) Define the data control.Explain any 2 data control methods. 4
3. Answer the following Questions
(a) Explain the terms candidate key and alternate key. 2
(b) State the implicit cursor attributes. Also state their 4
respective values when the cursor is opened.
(c) Differentiate between statement level triggers and row 4
level triggers.
1
SECTION B
4. Read the following Case Study and answer the Questions that follow
Rahul Kumar a programmer with GEMS Cinemas has created the following
form to book the tickets for the different shows in the theatre. A
customer can book tickets for various types of seating area. Write
VB code for the following requirement:
Tool Name Description
Option button Optbox Stores the kind of seating
Optstall area you would like to book
Optreserve
Text Boxes Txtcost The cost of each ticket
Txtnum The number of tickets you
want to book
Txtbill To display the total bill
Check Boxe Chkbulk Is checked if you book more
than 20 tickets
Chkmorning To select the morning show
Form Form1(Caption –The booking counter Display the Booking form
Label Name Caption To display the different
Label1 Cost per tiket details
Label2 Number of tickets
required
Label3 GEMS Cinemas
Label4 To be displayed only if
checkbulk is checkedd
Command CmdBill To calculate the bill
Button
2
(a) On form load event clear all the textboxes, option 2
buttons, check boxes and make the text boxes txtcost and
txtbill invisible. Also provide an access key Alt B to the
command button cmdbill.
(b) Identify the event and write an event procedure such that 2
when the user clicks on the option button the rate per
ticket should be displayed in the text box txtcost
(c) Write the code for the click of the command button
cmdbill. The rates for each area is given as
Area Cost of
Ticket
BOX 45
Stall 30
Reserve 25
If the number of seats is more than 20 the group gets a
15% discount on the total bill. The chkbulk should be 4
checked in that case. Label4 should display “You get a 15%
discount”
If the user selects the morning show give him a 5%
discount.
Total bill=cost per ticket * number of seats. Display the
Rate and the total bill in their respective text boxes and
also make them visible.
(d) Check if the number of tickets entered by the user is a 2
numeric value. Also a user can book only less than 75
tickets at a time as the capacity of the hall(per seating
arrangement) is only 75 tickets
5. Answer the following Questions
(a) Following is a code which prints the sum of square of even 2
numbers between 0 and 10. Identify and Correct the error(s)
if any.Rewrite the code underlining the corrections.
Dim x As Double
Dim total
x = 1
While x<20
total = total + x*2;
x = x + 2
Loop
(b) Find the output of the following code 2
Dim astr As String
Dim k As Integer
astr = "DASBOOT"
k = 1
Do While k <= Len(astr)
3
Print Left(astr, k)
k = k + 1
Loop
(c) Rewrite the following using Do Until…Loop 2
For A= 10 To 100 Step 10
Print A
Next A
(d) Create a VB procedure Ret_date which takes date of birth of 4
a person and displays his date of retirement. Date of
Retirement is when a person is 60 years of age. Also print
the number of years remaining for his retirement as on
today.
SECTION C
6. Read the Questions given below and answer accordingly.
(a) Write the output produced by the following part of code 2
in PL/SQL.
declare
nstart number(3):=10;
n number(3):=0;
i number(3):=0;
nstop number(3):=50;
begin
while n<=nstop
loop
n:=nstart+i*nstart;
i:=i+1;
dbms_output.put_line(n);
end loop;
End;
(b) Find error(s) in the following PL/SQL code and rewrite the 2
correct code after underlining the corrections made.
DECLARE
C NUMBER;
S NUMBER;
BEGIN
C:=0;
S:=0;
LOOP
S:=S+C;
PRINT(TO_CHAR(S));
C:=C-2;
IF C>-4 THEN
EXIT;
END LOOP
(c) State the three transaction Specifications available in 2
PL/SQL . State the need of COMMIT;
(d) Create a user defined PL/SQL function named FindGrade 4
4
which has an Argument which is the Student’s Mark. The
function should calculate and return the Grade
according to the marks,as given below.
Mark Grade
90-100 A
75-89 B
60-74 C
35-59 D
0-34 E
7. Answer the following Questions:
Consider the following table Flight
Column Data Type Size Constraint Description
Name
Fl_no Varchar2 4 Primary Key Flight
Number
Start_P Varchar2 20 Not Null Starting
Point
Dest_P Varchar2 15 Not Null Destination
point
Dep_Time Number 2 Between 0 to 23 Departure
time
Arr_Time Number 2 Between 0 to 23 Arrival time
Company Varchar2 15 Not Null Displays the
company to
which the
(a) Write an SQL command to display the details of all 2
flights that belong to the same company as the flight
whose flight number is IC768 or EM675.
(b) Write an SQL command which displays flight number, 2
starting point,departure point and arrival time of
flights starting from ‘Mumbai’ and ending at ‘Delhi’
and arrival time is between 6:00PM and 11:00PM.
(assume 24 hour clock)
(c) Write an Pl/SQL program which displays the details of 3
the flight when the user enters a flight number. Also
display the total number of flights available to the
same destination as that of the flight number entered
by the user.
(d) Write PL/SQL procedure having an IN parameter for the 3
Flight Number . Delete the record of that Flight if the
Starting Point is Bombay.Give Confirmation message if
the record has been Deleted and error messages if the
Flight Number is Invalid or if the Starting Point is
not Bombay.
5
CENTRE FOR ADVANCEMENT OF STANDARDS IN EXAMINATIONS
(GEMS ASIAN SCHOOLS)
COMMON REHEARSAL EXAMINATION –JANUARY 2010
(ALL INDIA SENIOR SCHOOL CERTIFICATE EXAMINATION)
INFORMATICS PRACTICES (065)
Set 3
Time Allowed : 3 hours Maximum Marks : 70
Note:
(i)This Question Paper is divided into 3 Sections.
(ii)Section A consists of 30 Marks.
(iii)Section B and Section C are of 20 Marks Each.
(iv)Answer the following Questions after carefully reading the Text.
SECTION A
1. Answer the following Questions
(a) Mention one point of difference between MySQL with 2
postgreSQL.
(b) Define the terms-OLTP,Information System 2
(c) State the need of a feasibility report in SDLC. 2
(d) Define UML and state the need of UML Diagrams 2
(e) Identify the type of relationship represented by the 2
following statements and draw an entity relationship
diagram to show it.
Every customer gets only one DEWA bill. The bill contains
the information bill and usage about utilities like gas,
water, electricity for each customer.
2. Answer the following Questions
(a) Explain the following parts of the Visual basic IDE 2
-Toolbox, Codewindow.
(b) What are library functions in Visual Basic? Explain 2
working of mod() function.
(c) Differentiate between Formload and Form activate events. 2
(c) Explain the terms OLE DB and ADO. 4
3. Answer the following Questions
(a) What is a join? Explain Equi-Join with an example 4
(b) What do you understand by substitution variables? 2
(c) Define a trigger.Differentiate between Before Triggers and 4
After Trigger.
1
SECTION B
4. Read the following Case Study and answer the Questions that follow
Madhavan Nath has always been a gourmet.A chance to
realise his love for gastronomic (ad)ventures
materialised when he was finally able to start his own
vegetarian restaurant.His friend has helped computerize
his billing section.The form is given below,
The List of the Main Objects for the Above Form is as
Follows
Object Object Name Description
Type
Form FrmMotel The Main Form Object
Option optVeg To order vegetarian meals
Button
optNonVEg To order non vegetarian
meals
optNonAC To sit in Non AC room
optic To sit in AC room
Check Box chkPapad To order additional papad
chkCurd To order additional curd
chkSidedish To order additional sidedish
chkSweet To order sweet
Text Box txtQuantity To specify quantity of meals
txtRate To display the total rate
for one meal
txtBill To display the final bill
Command cmdRate To calculate the total rate
Button (including extras) for one
meal
cmdBill To calculate the total bill
cmdReset To reset all the controls to
starting position
2
(a) Write the code for cmdRate which will calculate the rate 4
for one meal including supplementary items and display it
in txtRate as per the following criteria.
Standard meal
Standard Vegetarian Meal Rs 70
Standard Non Vegetarian Meal Rs 150
Supplementary Items
Extra Papad Rs 10
Extra Curd Rs 15
Extra Sidedish Rs 50
Extra Sweet Rs 30
Rate is (cost of standard meal)+(cost of supplementary
items).
(b) Write the code for cmdBill which will calculate the total 2
bill.If the customer opts to use AC room, an additional 20
Rs is charged. No charge is added if it is a Non A/C room.
Total bill=quantity*rate+Room charge
(c) Identify the event that will check if the customer has 2
entered only numeric values in the textbox txtquantity.
Give a message “please enter numeric values only” if the
user has not entered a numeric value.
(d) Write the code for cmdReset will deselect all option 2
buttons, uncheck the checkboxes and initialise all text
boxes to zero
5. Answer the following Questions
(a) Find the Error(s) in the Following Code Segment: 2
Rewrite the corrected code underlining the corrections.
x = 50
Select x
Case Is x = 5
Print "Five"
Case Is >= 5 AND Is <=40
Print "Between 5 and 40"
Case Is 50
Print "OK"
End Case
Print RTrim(x)
(b) Rewrite the code using Do while…Loop. 2
x = 10
For I = 10 To 1 Step -3
x = x - 2
If x = 4 Then
Print "Zero"
End If
Print I
3
Next I
(c) What is the Output of the Following Code. 2
Value1 = 30
Value2 = 60
Sum = 0
Do While Value1 < 50
Print Value1; Value2; Sum
Sum = Sum + Value1 - Value2
Value1 = Value1 + 5
Value2 = Value2 - 10
Loop
(d) Create a Function which takes n as argument and returns 4
the sum of all even numbers less than n.
SECTION C
6. Read the Questions given below and answer accordingly.
(a) Write the output produced by the following part of code 2
in PL/SQL.
declare
stx number(3):=5;
sty number(3):=4;
n number(3):=1;
m number(3):=2;
nstop number(3):=50;
begin
while m<=nstop
loop
stx:=stx+sty;
n:=n+stx;
m:=n+m;
dbms_output.put_line(m);
end loop;
End;
(b) Following is a PL/SQL code that prints numbers 100 to 2
20 in steps of 20.There are a few errors in the
code.Identify them and rewrite the corrected code.
begin
for i in reverse 10..1
loop
if i mod 2=0 then
dbms_output.put_line(to_char(i*10))
end if;
end loop;
(c) The following is a PL/SQL script that inputs 2
department number and displays name and commission of
all employees in that department.
What is the error in the program? Rewrite the code so
that the required functionality is obtained.
4
Table name :Emp
Required fields (deptno number(2),ename varchar2(20)
and comm number(4)).
declare
v_deptno emp.deptno%type:=&deptno;
v_ename emp.ename%type;
v_comm emp.comm%type;
begin
select ename,comm into v_ename, v_comm
from emp where deptno=v_deptno;
dbms_output.put_line(vename||’ ‘|| v_comm);
end;
(d) Write a PL/SQL Function named Factorial which takes a 4
number as argument and returns it’s Factorial. Eg if
number is 5, function should return 120 (1*2*3*4*5)
7. Answer the following Questions
Consider the following table Shop:
Column Name Data Size Constraint Description
Type
Shop_no Number 4 Primary Stores the
Key shop no
Shop_name Varchar2 20 Not Null The name of
the shop
Location Varchar2 30 The
location of
the shop
Area Number 10 In the Area in
Range 100 city
and 1000
Sales_Percent Number 4 In the
range 50
and 100
City Varchar2 30 The name of
the city
2
(a) Write a SQL query to display all the shops in the area
of the shop whose shop_no is input by the user.
(b) Write SQL command to display the Shop_no, Shop_name and 2
Location of shops located in Mumbai,Chenai or Bangaluru
whose sales_percent is not in the range 80 to 90.
(c) Create a Pl/SQL procedure which takes the city as 3
argument displays the count of shops in that city.
(d) Create a PL/SQL program to update the sales percent of 3
the shop whose shop_no is entered by the user. The user
inputs the new sales percent.
5
