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

[mariammal]

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

Informatics practices
Time- 3 Hours Maximum Mark – 100

Instructions :
i. All question are compulsory.
ii. Please the instructions carefully before writing the answer.
iii. In section A Q. No. 1 to 5 are objective type which contain fill up the Blank, True/False, match the column, one sentence answer and choose the correct answers. Each question is allotted 5 marks. 1x1 = 5x5 =25 Marks.

http://mpbse.nic.in/Model%20Que-Ans%20paper.htm
http://mpbse.nic.in/12TH/Informatics...0Practices.PDF

iv. Internal options are given in Q. No. 6 to 20 in section B.
v. Q. No. 6 to 10 carry 4 marks each and answer should be given in about 75 words.
vi. Q. No. 11 to 15 carry 5 marks each and answer should be given in about 120 words.
vii. Q. No. 16 to 20 carry 6 marks each and answer should be given in about 150 words.

Choose the correct answer :
(a) PL/SQL commands by -
(i) Embedded SQL (ii) DDL (iii) DML
(b) Extension of Activex control is
(i) OCX (ii) OLE (iii) DLL
(c) Trim Function is used to remove -
(i) Space (ii) Character (iii) Number
(d) A Graphical data control is -
(i) ADODC (ii) ADODB (iii) DAO
(e) PL/SQL is a language -
(i) Procedural (ii) Non-Procedural (iii) Object Oriented

Fill in the blanks given below :
(i) PL/SQL is based on ……………. programming language.
(ii) ……………. and ROLL Back cannot be a part of Trigger.
(iii) By Ref and by val are used to pass ……………. to a Subroutine.
(iv) In client/server system the server is called …………….
(v) Value of Derived attribute is determined by ……………. attribute.

State true or false :
(i) TCP/IP protocol supports client/server Computing.
(ii) SYBASE is a front -end tool.
(iii) Space function removes the spaces.
(iv) Data control connects a data aware control to a database.
(v) Database can be accessed multiple times by accessing connections.

Match the Column :
EOF - For DML Operations
Commit - Many conditions
Case - End of file
Old and New - Instead of trigger
View level Trigger - Default table and Corelation names
Write down the names of types of SQL statements with commands.
Or
Explain the benefits and limitation of relation model?
Explain the process of creating MDI Form and their child form?
Or
Discuss the SDI with their Drawbacks?
Discuss the main types of errors in VB?
Or
What is subroutines? Write the advantages of subroutines.
Discuss location Scope and duration of variables?
Or
Explain data control and its methods?
Differentiate between SQL and PL/SQL.
Or
Select Command dh lHkh Condition dks Syntax lfgr le>kb,\
Explain all the contition of select command with syntax?
Discuss different types of triggers in PL/SQL
Or
How we can combine the triggers?
Disccuss different types of joins in SQL.
Or
Draw the flow chart for types of control structure (Statement)?
Explain select case statement of VB with syntax and example?
Or
Explain for next loop of VB with syntax and example?
Defien
(i) Key Attribute (ii) Derived Attribute (iii) Entity (iv) Entity set
Or
What is mapping Cordialities? Explain all its condition?
Explain loop end loop with example in PL/SQL
Or
Explain distributed database types?
Explain all comparision operators and logical operators with syntax in VB
Or
What are the main objects of ADO? Explain with syntax.
Expain implicit cursor and explicit cursor with example.
Or
Discuss different section of PL/SQL program construct?