12th Std / +2 / Plus Two Himachal Pradesh : Informatics Practices Model Question Paper www.hpeducationboard.nic.in

[mariammal]

Document Described : Informatics Practices Question Paper, Himachal Pradesh Question Paper

Himachal Pradesh Board of School Education
MODEL QUESTION PAPERS
Plus Two Examination March 2009
INFORMATICS PRACTICES
Time Allowed : 3 Hrs. Max. Marks 60
Note : All questions are compulsory.

http://hpeducationboard.nic.in/ModelQP.htm
http://hpeducationboard.nic.in/plus2_model_paper.pdf

Q1. State whether the following statements are True or False :
i) GNU / Linux is a open source software operating system.
ii) DBMS is defined as a collection of interrelated data.
iii) Modules and Procedures are the basic structure of a VB program .
iv) You can not create dynamic array in Visual Basic.
v) MDI stands for Multiple Data Interface.
vi) ROLL BACK is a database transaction feature.
vii) Like SQL, PL / SQL is a case sensitive.
viii) A Lexical unit is a sequence of characters.
ix) A module is a logically grouped set of SQL and PL / SQL statements.
x) DROP TRIGGER Command is not used to drop the trigger.
Q2. (a) What is Freeware and Shareware. Explain.
(b) Explain Human Resource Development System.
OR
(a) Write the components of open source based software and explain them in short.
(b) What are the characterstics of a Dataware house ? Explain.
Q3. (a) What are the advantages of Procedures ? Explain them.
(b) Explain the following Modules :
(i) Class Modules
(ii) Standard Modules Modules %
OR
(a) What do you mean by control structure ?
(b) Explain the following function in VB
(i) str ( ) (ii) Len ( )
(iii) RTrim ( ) (iv) Chr ( )
Q4. (a) Write a program in Visual Basic to find sum of 10 numbers.
Visual Basic program
(b) What do you mean by Single Document Interface (SDI)
(c) What is ADO ? Explain.
Q5. (a) What do you understand by SQL and explain the following SQL functions.
(i) Single Row Function
(ii) Character Function
(b) What do you understand by data base transactions ?
OR
(a) Define Data Replication. Explain.
(b) Explain properties of Database Transactions.
Q6. (a) Write PL/ SQL Code to display series of numbers 2, 4, 6, 8, . . . . 100.
(b) Differentiate between implicit cursors and explicit cursors.
(c) What is trigger ? What are the limitations of using triggers ?
Write one Maseetkhani Gat from your syllabus along with Aroh, Avaroh and Pakadand two Todas of Chaugun Laya. (5)
Write Ghaptaal and Rupak Taal in Ekgun and Dugun Layakaris. (2½+2½)
Write about the history and construction of your opted Instrument and show the parts of your instrument with the help of diagram. (5)
Compare any two pairs from the following :
(a) Gram - Murchana (b) Krintan - Zamjama (c) Varan - Alankar(2½+2½)
Write in detail about the time theory of Ragas. (5)
Write in brief about 'Sangeet Ratnakar' written by Pt. Sharang Dev or - 'Sangeet Parijata' written by Pt. Ahobal. (5)
Write Razakani gat in Rag Bhairav or Rag Khamaj with three Todas. (5)

[Guest]

What is the differencd between implicit and explecit cursor?