Make your own free website on Tripod.com
ICSK SALMIYA
QuestionBank

Home

short | Theory Questions

CLASS 12 INFORMATICS PRACTICES

QUESTION BANK

ORACLE :

  1. What is meant by cardinality of a table ? 1
  2. What is privilege ? What are the two types of privilege? 2
  3. How is PRIMARY KEY constraints different from UNIQUE constraints. 1
  4. What is exception handling? 2
  5. What is mutating and constraining table . 1
  6. What do you understand by the term alternate key ? 1
  7. What is the function of a database management system? 2
  8. Differentiate between DDL and DML Commands. 2
  9. What is DATA dictionary ? 1
  10. Differentiate between two-tier and three-tier computing model. 2
  11. What is data ware house? 1
  12. What is the syntax for creating explicit cursor? 1
  13. Explain Reference data type and Composite data type. 2
  14. What is Oracle? What are its functions? 2
  15. What happens when you close and then re-open a cursor? 1
  16. What is business computing? What role does the data base play in business . 2
  17. What is the Difference between BEFORE and AFTER trigger. 1
  18. What are procedures? What are its different types. 2
  19. What is the structure of an information system. 2
  20. Define what is meant by an entity , attributes ,entity set, relationship? 2
  21. What is distributed data base ? What is its signficance? 2
  22. What is the need for Normalization? Define Second normal form. 2
  23. What is a cursor ? What are its different types. 2
  24. What is the significance of triggers. 1
  25. Differentiate between CREATE TABLE and ALTER TABLE commands. 2
  26. What is Trigger ? Write the Syntax for defining a Trigger. 2
  27. Why are named procedures referred as stored procedure. 1
  28. Define 1NF, 2NF, 3NF. 3
  29. What is the Difference between a key field and a composite key? 2
  30. Compare and contrast triggers and constraints. 2
  31. Compare Char and Varchar2 data types. 2
  32. Why is %ISOPEN always false for an implicit cursor? 1
  33. How are the following statements differ from one another?
  34. i) commit and commit work 2

    ii) ROLLBACK AND ROLLBACK TO

  35. What are Constraints ? What are its different types. 2
  36. What are functions? How are they Different from procedures? 2
  37. What is Synonyms ? How is it different from view ? 2
  38. What are the various data models available for database systems? 2
  39. How is FOREIGN KEY commands related to the PRIMARY KEY ? 2
  40. Differentiate CREATE PROCEDURE and CREATE OR REPLACE PROCEDURE 2
  41. What is the difference between TRUNCATE and DELETE commands 1
  42. What are object privilege ? What are its type. 2
  43. What are the three components of client/server architecture? 2
  44. What do you meant by relational database? Explain. 3
  45. What is the syntax to create triggers. 2
  46. What is the difference between private synonym and public synonym? 2
  47. What is the advantage of Stored Procedure . 1
  48. What is a Transaction . Explain 2
  49. If a view is dropped, what happens to its base table? 1
  50. What is a Protocol. Explain network protocol. 2
  51. Write short notes process chart and Data dictionary. 2
  52. What are the advantages of synonyms. 1
  53. What do you meant by ACID properties?. Explain. 2
  54. Define the following terms.
  55. i) Atomicity ii) Consistency iii) Isolation iv) Durability 2

  56. What is Back End tool ? Give an example. 1
  57. What do you understand by the term User Interface ? 1
  58. Define Meta Data. 1
  59. Expand the term SQL. Name any two SQL command categories. 2
  60. What do you mean by attribute? Explain with an example. 2
  61. Write about the different types of relationships that can exists between entities?
  62. Give one example of each. 4

  63. What do you understand by the term Tuple ? 1
  64. What is the difference between procedure and triggers ? 2
  65. What does degree of a table mean? 1
  66. What is Normalization ? Explain its need. 2
  67. What do the commands COMMIT , ROLLBACK and SAVEPOINT do ?
  68. Also give SQL category to which they belong. 3

  69. What do you understand by Cursor ? What are the different types of Cursor ?
  70. Explain Cursor attributes. 4

  71. What is front-end tool ? Give an example. 1
  72. Name various type of UML diagrams. 2
  73. Expand and Explain the abbreviation UML. 1
  74. Explain one-to-many relationships of RDBMS with a suitable example. 2
  75. How does a back end linked to a data base and a server. 1
  76. What are the three components of client/server architecture. 2
  77. What is an attribute ? Explain composite attribute with an example. 2
  78. What is data base fragmentation? How is it related to distributed database? 2
  79. What is the role of TCP/IP Protocol ? 1
  80. What is meant by data abstraction and data encapsulation 2
  81. What is a Stored procedure? Explain with example. 2
  82. Give different ways in which data may be fragmented. 1
  83. Differentiate between horizontal fragmentation and vertical fragmentation. 2
  84. What are row level triggers and statement level triggers ? How are these created? 2
  85. Explain INSTEAD OF triggers. 2
  86. What is system development life cycle ? Write the steps of system development
  87. life cycle. 4

  88. What is the need of Data Dictionary ? 1
  89. What is meant by DATA MINING ? 1
  90. Differentiate between session control commands and system control commands. 1
  91. Explain the term Client and Server in Client/Server computing. 2
  92. Specify any four, application areas of Databases. 2
  93. Differentiate between partial replication and full replication of database. 2
  94. What are the conventions of E-R modeling to represent
  95. (a) Entity (b) Attribute (c) Relationship (d) Database 4

  96. What is a foreign key in a table ? 1
  97. What is classes and object. 1
  98. How is serial execution of transaction different from concurrent execution . 2
  99. What is first normal form of data ? 1
  100. Differentiate between SQL command insert and alter. 2
  101. Differentiate between row-level and statement-level triggers. 2
  102. What is the concept of database transaction? 2
  103. What are data types ? Name some scalar data types of PL/SQL? 2
  104. What is a named block? How it is different from anonymous block? 1
  105. What command is used to create a host /bind variables in SQL Plus? 1
  106. What is the advantage of an anchored data type. 1
  107. What is the need for a trigger. 1
  108. What is a type conversion ? What are its different forms. 2
  109. What is meant by implicit and explicit type conversion? 2
  110. What do you understand by static cursor? 1
  111. What is the significance of object modelling? 1
  112. What does a FETCH statements do? 1
  113. What is the Difference between OPEN and FETCH commands. 2
  114. How would you drop a trigger. Give an example. 1
  115. What is a Parameter?. What are its Different types. 2
  116. What do you understand by active set. 1
  117. What is meant by robustness? 1
  118. In which order triggers are fired if multiples triggers exits for same table? 1
  119. What is the structure of the information system. 1
  120. What are the three models in the OMT ? Briefly explain. 2
  121. How is data modeling ? How it is linked to mining. 2
  122. Explain what is meant by Generalization and specialization mean? 2
  123.  

    VISUAL BASIC :

     

  124. Name any two properties that are common for the controls on standard toolbar
  125. in Visual Basic. 1

  126. Differentiate between a Label Control and a Text Box control. 1
  127. "VB is an Object Based Event Driven programming language" Explain. 2
  128. Differentiate between SDI Form and MDI Form in Visual Basic. In the similar
  129. context, explain the concept of parent and child forms. 4

  130. Differentiate between check box and Radio Button control. 1
  131. Differentiate Combo box and List Box in VB. 1
  132. Expand the abbreviation ODBC. What does ODBC mean ? 2
  133. What do you find as the difference in Syntax Error and Run Time Error ? 2
  134. What do you understand by event driven programming ? 1
  135. What is Dialog box ? 1
  136. Expand the term ADO. What is ADO ? 2
  137. What does the following code do : 2
  138. For Each Control in Form1.controls

    Control.font "Times New Roman"

    IF not typeof control is commandbutton then

    control.forcolor = "BLUE"

    End If

  139. Differentiate between public and private variables and discuss their scope
  140. of visibility. 2

  141. Differentiate between private and public scopes 1
  142. How is a static variable Different from other variables. 1
  143. What is a record set and bound control? 2
  144. Differentiate between module and public scopes 1

Enter subhead content here

CLASS 12 INFORMATICS PRACTICES

QUESTION BANK

ORACLE :

  1. What is meant by cardinality of a table ? 1
  2. What is privilege ? What are the two types of privilege? 2
  3. How is PRIMARY KEY constraints different from UNIQUE constraints. 1
  4. What is exception handling? 2
  5. What is mutating and constraining table . 1
  6. What do you understand by the term alternate key ? 1
  7. What is the function of a database management system? 2
  8. Differentiate between DDL and DML Commands. 2
  9. What is DATA dictionary ? 1
  10. Differentiate between two-tier and three-tier computing model. 2
  11. What is data ware house? 1
  12. What is the syntax for creating explicit cursor? 1
  13. Explain Reference data type and Composite data type. 2
  14. What is Oracle? What are its functions? 2
  15. What happens when you close and then re-open a cursor? 1
  16. What is business computing? What role does the data base play in business . 2
  17. What is the Difference between BEFORE and AFTER trigger. 1
  18. What are procedures? What are its different types. 2
  19. What is the structure of an information system. 2
  20. Define what is meant by an entity , attributes ,entity set, relationship? 2
  21. What is distributed data base ? What is its signficance? 2
  22. What is the need for Normalization? Define Second normal form. 2
  23. What is a cursor ? What are its different types. 2
  24. What is the significance of triggers. 1
  25. Differentiate between CREATE TABLE and ALTER TABLE commands. 2
  26. What is Trigger ? Write the Syntax for defining a Trigger. 2
  27. Why are named procedures referred as stored procedure. 1
  28. Define 1NF, 2NF, 3NF. 3
  29. What is the Difference between a key field and a composite key? 2
  30. Compare and contrast triggers and constraints. 2
  31. Compare Char and Varchar2 data types. 2
  32. Why is %ISOPEN always false for an implicit cursor? 1
  33. How are the following statements differ from one another?
  34. i) commit and commit work 2

    ii) ROLLBACK AND ROLLBACK TO

  35. What are Constraints ? What are its different types. 2
  36. What are functions? How are they Different from procedures? 2
  37. What is Synonyms ? How is it different from view ? 2
  38. What are the various data models available for database systems? 2
  39. How is FOREIGN KEY commands related to the PRIMARY KEY ? 2
  40. Differentiate CREATE PROCEDURE and CREATE OR REPLACE PROCEDURE 2
  41. What is the difference between TRUNCATE and DELETE commands 1
  42. What are object privilege ? What are its type. 2
  43. What are the three components of client/server architecture? 2
  44. What do you meant by relational database? Explain. 3
  45. What is the syntax to create triggers. 2
  46. What is the difference between private synonym and public synonym? 2
  47. What is the advantage of Stored Procedure . 1
  48. What is a Transaction . Explain 2
  49. If a view is dropped, what happens to its base table? 1
  50. What is a Protocol. Explain network protocol. 2
  51. Write short notes process chart and Data dictionary. 2
  52. What are the advantages of synonyms. 1
  53. What do you meant by ACID properties?. Explain. 2
  54. Define the following terms.
  55. i) Atomicity ii) Consistency iii) Isolation iv) Durability 2

  56. What is Back End tool ? Give an example. 1
  57. What do you understand by the term User Interface ? 1
  58. Define Meta Data. 1
  59. Expand the term SQL. Name any two SQL command categories. 2
  60. What do you mean by attribute? Explain with an example. 2
  61. Write about the different types of relationships that can exists between entities?
  62. Give one example of each. 4

  63. What do you understand by the term Tuple ? 1
  64. What is the difference between procedure and triggers ? 2
  65. What does degree of a table mean? 1
  66. What is Normalization ? Explain its need. 2
  67. What do the commands COMMIT , ROLLBACK and SAVEPOINT do ?
  68. Also give SQL category to which they belong. 3

  69. What do you understand by Cursor ? What are the different types of Cursor ?
  70. Explain Cursor attributes. 4

  71. What is front-end tool ? Give an example. 1
  72. Name various type of UML diagrams. 2
  73. Expand and Explain the abbreviation UML. 1
  74. Explain one-to-many relationships of RDBMS with a suitable example. 2
  75. How does a back end linked to a data base and a server. 1
  76. What are the three components of client/server architecture. 2
  77. What is an attribute ? Explain composite attribute with an example. 2
  78. What is data base fragmentation? How is it related to distributed database? 2
  79. What is the role of TCP/IP Protocol ? 1
  80. What is meant by data abstraction and data encapsulation 2
  81. What is a Stored procedure? Explain with example. 2
  82. Give different ways in which data may be fragmented. 1
  83. Differentiate between horizontal fragmentation and vertical fragmentation. 2
  84. What are row level triggers and statement level triggers ? How are these created? 2
  85. Explain INSTEAD OF triggers. 2
  86. What is system development life cycle ? Write the steps of system development
  87. life cycle. 4

  88. What is the need of Data Dictionary ? 1
  89. What is meant by DATA MINING ? 1
  90. Differentiate between session control commands and system control commands. 1
  91. Explain the term Client and Server in Client/Server computing. 2
  92. Specify any four, application areas of Databases. 2
  93. Differentiate between partial replication and full replication of database. 2
  94. What are the conventions of E-R modeling to represent
  95. (a) Entity (b) Attribute (c) Relationship (d) Database 4

  96. What is a foreign key in a table ? 1
  97. What is classes and object. 1
  98. How is serial execution of transaction different from concurrent execution . 2
  99. What is first normal form of data ? 1
  100. Differentiate between SQL command insert and alter. 2
  101. Differentiate between row-level and statement-level triggers. 2
  102. What is the concept of database transaction? 2
  103. What are data types ? Name some scalar data types of PL/SQL? 2
  104. What is a named block? How it is different from anonymous block? 1
  105. What command is used to create a host /bind variables in SQL Plus? 1
  106. What is the advantage of an anchored data type. 1
  107. What is the need for a trigger. 1
  108. What is a type conversion ? What are its different forms. 2
  109. What is meant by implicit and explicit type conversion? 2
  110. What do you understand by static cursor? 1
  111. What is the significance of object modelling? 1
  112. What does a FETCH statements do? 1
  113. What is the Difference between OPEN and FETCH commands. 2
  114. How would you drop a trigger. Give an example. 1
  115. What is a Parameter?. What are its Different types. 2
  116. What do you understand by active set. 1
  117. What is meant by robustness? 1
  118. In which order triggers are fired if multiples triggers exits for same table? 1
  119. What is the structure of the information system. 1
  120. What are the three models in the OMT ? Briefly explain. 2
  121. How is data modeling ? How it is linked to mining. 2
  122. Explain what is meant by Generalization and specialization mean? 2
  123.  

    VISUAL BASIC :

     

  124. Name any two properties that are common for the controls on standard toolbar
  125. in Visual Basic. 1

  126. Differentiate between a Label Control and a Text Box control. 1
  127. "VB is an Object Based Event Driven programming language" Explain. 2
  128. Differentiate between SDI Form and MDI Form in Visual Basic. In the similar
  129. context, explain the concept of parent and child forms. 4

  130. Differentiate between check box and Radio Button control. 1
  131. Differentiate Combo box and List Box in VB. 1
  132. Expand the abbreviation ODBC. What does ODBC mean ? 2
  133. What do you find as the difference in Syntax Error and Run Time Error ? 2
  134. What do you understand by event driven programming ? 1
  135. What is Dialog box ? 1
  136. Expand the term ADO. What is ADO ? 2
  137. What does the following code do : 2
  138. For Each Control in Form1.controls

    Control.font "Times New Roman"

    IF not typeof control is commandbutton then

    control.forcolor = "BLUE"

    End If

  139. Differentiate between public and private variables and discuss their scope
  140. of visibility. 2

  141. Differentiate between private and public scopes 1
  142. How is a static variable Different from other variables. 1
  143. What is a record set and bound control? 2
  144. Differentiate between module and public scopes 1

 

Enter supporting content here