HSEB || Important model questions for Computer Science Class 12

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]

Comments

comments

Hemant

Hemant Chaudhary is an student 19 years old. He is interested in Hacking, Blogging,coding. He like to Visit new Places and make new Friends. He used to Learn His web works From Friends and Currently is is CEO and Founder of Meropaper and meroreview.com