Class: 12 || Subject: Computer Science
Unit-2 Database
Long Answer Questions
- 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]
- 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
- What is DBMS? Explain data integrity with suitable example. [2+3=5]
- Define DML and DDL with example. [3+2=5]
- What is DBMS? Different between centralized and distributed database. [2+3=5]
- Explain Relational data base model. [5]
- Define DBMS. List out the objectives of DBMS. [1+4=5]
- What is Relational database model? List the advantages and disadvantages of Relational database model. [1+4=5]
- Describe the terms ‘SQL’ and ‘DML’. [2.5+2.5=5]
- Describe any two database model with diagram. [5]
- What is Ms-Access? What are the uses of Ms-Access? [2+3=5]
- What is normalization? What the advantages of normalization. [2+3=5]
- What are the advantages of RDBMS. [5]
- What is MS-Access? What are the basic components of micro-soft Access? List out. [1+4=5]
- Who is database administrator? List the roles of database administrator. [1+4=5]
- What is database? List out the advantages of Database Management System. [1+4=5]
- Describe the centralized and distributed database systems. [5]
- What is RDBMS? List out the function of RDBMS. [1+4=5]
- Explain the database models with clear diagrams. [5]
- What is Hierachical database model? List out the advantages and disadvantages of Hierarchical database model. [1+4=5]
- Explain the centralized and distributed database models. [2.5+2.5=5]
- What is database? List the major uses of database application software. [1+4=5]
- What is E-R diagram? Explain the advantages of E-R diagram in system design. [1+4=5]
- Explain the database model with suitable examples. [5]
- Define the term RDBMS. State the guiding principles used in database design. [2+5=7]
- What is data integrity? State and describe different types of data integrity. [2+5=7]
- What is normalization? How it us used in data analysis? Explain. [2+5=7]
- What do you understand by the term data integrity? Why it is important in designing a database? [2+5=7]
- Explain the benefits of centralized database. [7]
- What is normalization? Explain the normalization process with examples. [2+5=7]
- 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]
- Define database and DBMS. Explain the advantages of Database system over flat-file system. [2+5=7]
- What are the advantages of distributed database system over centralized database system? [7]
- What is data mode? Explain about different modeling techniques. [2+5=7]
- What is the purpose of E-R diagram? List out the different symbols used in E-R diagram with their meanings and examples. [7]
- Differentiate between database and database management system. Explain the top down methodology of database design. [3+4=7]
- Explain the benefits of centralized database. What are the major responsibilities of Database Administrator? Explain in detail. [3+4=7]
- 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]
- 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:
- DBMS [2.5]
- Normalization [2.5] {Important}
- Data security [2.5]
- Data Dictionary [2.5]
- DML [3.5]
- Data modeling [3.5]
- Advantage of DBMS [3.5]