
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

HIMACHAL PRADESH MAR 2008 : Informatics Practices

3 pages, 31 questions, 0 questions with responses, 0 total responses,

	himachal	+Fave Message
	Profile Timeline Uploads Q & A

Home > himachal >

Formatting page ...

INFORMATICS PRACTICES Time Allowed : 3 Hrs. Max. Marks 60 Note : All questions are compulsory. Q1. State whether the following statements are True or False : fuEufyf[kr dFku esa lgh o xyr crkb, % i) ii) iii) iv) v) vi) GNU / Linux is a open source software operating system. GNU / Linux ,d open source software operating system gSA 1 DBMS is defined as a collection of interrelated data. DBMS ,d interrelated Data lewg gSA 1 Modules and Procedures are the basic structure of a VB program . Modules vkSj Procedures, VB Program ds Basic structure gSaA 1 You can not create dynamic array in Visual Basic. vki Visual Basic esa dynamic array create ugha dj ldrs gSaA 1 MDI stands for Multiple Data Interface. MDI dk vFkZ Multiple Data Interface gSA 1 ROLL BACK is a database transaction feature. ROLL BACK ,d Database transaction dh fo'ks"krk gSA 1 vii) Like SQL, PL / SQL is a case sensitive. SQL dh rjg PL/SQL case sensitive gSA 1 viii) A Lexical unit is a sequence of characters. Lexical unit, characters dh ,d sequence gSA 1 ix) x) Q2. (a) A module is a logically grouped set of SQL and PL / SQL statements. Module SQL vkSj PL/SQL statements dk ,d logically grouped set gSA 1 DROP TRIGGER Command is not used to drop the trigger. DROP TRIGGER Command, Trigger drop djus ds iz;ksx esa ugha vkrh gSA 1 (1 10=10) What is Freeware and Shareware. Explain. Freeware vkSj Shareware D;k gSa \ O;k[;k dhft,A (69) 3 (b) Explain Human Resource Development System. Human Resource Development System dh O;k[;k dhft,A 3 OR (a) Write the components of open source based software and explain them in short. 3 Open source based software ds components dks laf{kIr :i esa fyf[k,A (b) What are the characterstics of a Dataware house ? Explain. Dataware house dh fo'ks"krk, D;k gSa \ O;k[;k dhft,A 3 What are the advantages of Procedures ? Explain them. Procedures dh D;k advantages gSa \ O;k[;k dhft,A 5 Q3. (a) (b) Explain the following Modules : (i) Class Modules (ii) Standard Modules fuEufyf[kr Modules dh O;k[;k dhft, % (i) Class Modules (ii) Standard Modules 5 OR (a) (b) Q4. (a) (b) (c) What do you mean by control structure ? Control structure ls vki D;k le>rs gSa \ 5 Explain the following function in VB (i) str ( ) (ii) Len ( ) (iii) RTrim ( ) (iv) Chr ( ) fuEufyf[kr VB function dh O;k[;k dhft, % (i) str ( ) (ii) Len ( ) (iii) RTrim ( ) (iv) Chr ( ) 5 Write a program in Visual Basic to find sum of 10 numbers. nl vadksa dk tksM+ Kkr djus ds fy, Visual Basic esa ,d program fyf[k,A 4 What do you mean by Single Document Interface (SDI) Single Document Interface (SDI) ls vki D;k le>rs gSa \ 4 What is ADO ? Explain. ADO D;k gS \ O;k[;k dhft,A 4 (70) Q5. (a) What do you understand by SQL and explain the following SQL functions. (i) Single Row Function (ii) Character Function SQL ls vki D;k le>rs gSa \ fuEufyf[kr SQL function dh O;k[;k dhft, % (i) Single Row Function (ii) Character Function (b) What do you understand by data base transactions ? Data base transactions ls vki D;k le>rs gSa \ 5 OR (a) (b) Q6. (a) Define Data Replication. Explain. Data Replication D;k gS \ O;k[;k dhft,A 5 Explain properties of Database Transactions. Data base transactions dh fo'ks"krkvksa dh O;k[;k dhft,A 5 Write PL/ SQL Code to display series of numbers 2, 4, 6, 8, . . . . 100. 2, 4, 6, 8, . . . . 100 series dks display djus ds fy, PL/SQL code fyf[k,A 4 (b) (c) Differentiate between implicit cursors and explicit cursors. Implicit cursors vkSj explicit cursors ds chp vUrj crkb,A 4 What is trigger ? What are the limitations of using triggers ? Trigger D;k gS \ Triggers dk mi;ksx djus dh D;k limitations gSa \ 4 (71)

Formatting page ...

Additional Info : Model Question Papers Of Plus Two Examination March 2008 Informatics Practices (Theory)
Tags : himachal , himachal pradesh board of school education model question papers , himachal pradesh board exam papers , solved board question papers of hp , hp board exam papers , hp solved specimen question papers 2008 , hp board hsc exam papers , Model Question Papers 2008 , himachal pradesh board sample papers

himachal chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: