HSEB || Important model questions for Computer Science Class 12

Object Oriented Programming, Artificial Intelligence, Cyber Law, Multimedia, Computer Technology

Class: 12 || Subject: Computer Science

Unit-2 Database

Long Answer Questions

  1. What do you understand by the term data integrity? Why it is an important thing to be considered while designing a database. State and describe different types of data integrity. [20]
  2. a. What do you understand by the term data integrity? Why is it important thing to be considered while designing a database? State and describe types of data integrity. [5]

b. What is data security? How it can be implemented?

Short Answer Questions

  1. What is DBMS? Explain data integrity with suitable example. [2+3=5]
  2. Define DML and DDL with example. [3+2=5]
  3. What is DBMS? Different between centralized and distributed database. [2+3=5]
  4. Explain Relational data base model. [5]
  5. Define DBMS. List out the objectives of DBMS. [1+4=5]
  6. What is Relational database model? List the advantages and disadvantages of Relational database model. [1+4=5]
  7. Describe the terms ‘SQL’ and ‘DML’. [2.5+2.5=5]
  8. Describe any two database model with diagram. [5]
  9. What is Ms-Access? What are the uses of Ms-Access? [2+3=5]
  10. What is normalization? What the advantages of normalization. [2+3=5]
  11. What are the advantages of RDBMS. [5]
  12. What is MS-Access? What are the basic components of micro-soft Access? List out. [1+4=5]
  13. Who is database administrator? List the roles of database administrator. [1+4=5]
  14. What is database? List out the advantages of Database Management System. [1+4=5]
  15. Describe the centralized and distributed database systems. [5]
  16. What is RDBMS? List out the function of RDBMS. [1+4=5]
  17. Explain the database models with clear diagrams. [5]
  18. What is Hierachical database model? List out the advantages and disadvantages of Hierarchical database model. [1+4=5]
  19. Explain the centralized and distributed database models. [2.5+2.5=5]
  20. What is database? List the major uses of database application software. [1+4=5]
  21. What is E-R diagram? Explain the advantages of E-R diagram in system design. [1+4=5]
  22. Explain the database model with suitable examples. [5]
  23. Define the term RDBMS. State the guiding principles used in database design. [2+5=7]
  24. What is data integrity? State and describe different types of data integrity. [2+5=7]
  25. What  is normalization? How it us used in data analysis? Explain. [2+5=7]
  26. What do you understand by the term data integrity? Why it is important in designing a database? [2+5=7]
  27. Explain the benefits of centralized database. [7]
  28. What is normalization? Explain the normalization  process with examples. [2+5=7]
  29. What do you understand by the term data integrity? Why it is important thing to be considered while designing a database? Explain. [2+5=7]
  30. Define database and DBMS. Explain the advantages of Database system over flat-file system. [2+5=7]
  31. What are the advantages of distributed database system over centralized database system? [7]
  32. What is data mode? Explain about different modeling techniques. [2+5=7]
  33. What is the purpose of E-R diagram? List out the different symbols used in E-R diagram with their meanings and examples. [7]
  34. Differentiate between database and database management system. Explain the top down methodology of database design. [3+4=7]
  35. Explain the benefits of centralized database. What are the major responsibilities of Database Administrator? Explain in detail. [3+4=7]
  36. Give two advantages of using a database rather than a number of separate files. What are major responsibilities of a database administrator? [3+4=7]
  37. Name the different models of DBMS. Write short notes on: [1+6=7]

a. SQL

b. Data Dictionary

c. DDL

38. What are Domains and Tuples? What are the characteristics of good data model? [2+5=7]

39. What is prototyping? Write short notes on any two of the following? [2+5=7]

a. Normalization of data

b. Data security

c. RDBMS

40. What is the role of Database Administrator? What are the duties and responsibilities of a System Analyst? [2+5=7]

41. Define the term RDMBS. State the four guiding principles used in database design. [2+5=7]

Write Short Notes On:

  1. DBMS [2.5]
  2. Normalization [2.5] {Important}
  3. Data security [2.5]
  4. Data Dictionary [2.5]
  5. DML  [3.5]
  6. Data modeling [3.5]
  7. Advantage of DBMS [3.5]