1. What are database systems? List out its characteristics.
2. What are logical levels is used in data abstraction?
3. Define data, database, DBMS and data base system.
4. Define DBMS.
5. What is meant by data abstraction?
6. Distinguish between physical and logical data independence.
7. What do you understand by data independence? How can it be achieved?
8. What are the data models present in DBMS?
9. What is a data dictionary? What are the information’s stored in the data dictionary?
10. What are the benefits of data dictionary? Who are the users of data dictionary?
11. What is meant by an Instance of the database and schema?
12. Explain briefly about E-R data model.
13. What is the purpose of Meta data?
14. Define the terms: (a) meta data (b)Canned transaction
15. What are the problems in data redundancy?
16. What is the purpose of buffer manager?
17. Define the term Atomicity in transaction management.
18. What are the characteristics that distinguish a DBMS from traditional file processing system?
19. What is the purpose of transaction manager?
20. List out the functions of DBA.Explain.
21. Who are all the database users present in DBMS?Give role of each.
22. Describe the different types of database end users.
23.Define database schema.
24.What are the different database languages?Explain.
25.What is the need for Normalisation ?
26.What is a referential integrity?
27.What is logical data independence and why is it important?
28.What is the difference between physical data independence and logical data independence?
29. What is Physical data independence?
30.Differentiate between XML and HTML.
31.Explain Semi-structured data model with an example.
33.What is object relational data model?
34.What is difference between object oriented data model and object relational data model?
35.What is difference between machine learning and data mining?
36.What is KDD?
37.Differentiate between KDD and Data Mining.
38.What is market basket analysis?
39.What is association rule mining?Give an example.
40.Describe the structure of a DBMS.
41.What do you mean by a data model?
Describe the different types of data models used.
42.Describe the main components of a DBMS.
43.Discuss the advantages and characteristics of the three-tier-architecture.
44.Compare the two-tier and three-tier client server architecture.
45.Why null values are introduced in the database?
46.What is meant by the term client/server architecture and what are the advantagesand disadvantages of this approach?
47.Consider the following relational schema
Account (account-number, branch-name, balance)
Loan (Loan-number, branch-name, balance)
Depositor (Customer-name, Account-number)Borrower (Customer-name, Loan-number)
Write queries in SQL for the following:
(a)Find all loan numbers for loan made at Bombay branch.
(b)Find all customers who have both a loan and an account at the bank.
(c)Find the average account balance at each branch.
(d)Find the number of depositors at each branch.
48.What is data mining?
49.What is data warehouse?
50.List four significant differences between a file-processing system and a DBMS.
51.Describe a circumstance in which you would choose to use embedded SQL rather than using SQL alone.
52.What is meant by an entity, attributes, entity set and relationship ?
53.How is E-R data model useful ?
54.Give example of following relationships :
(i) Many-to-One
(ii) One-to-One
(iii)One-to-Many
(iv) Many-to-Many
55.What do you mean by redundancy ?How this can be avoided ?
56.What is the difference between Procedural DML and Non-Procedural DML ?
57.What do you mean by instance & schema ? Explain the difference between these.
58.What is the role of three levels of Data Abstraction ?
59.Give SQL statement which creates a STUDENT table consisting of following fields.
Name CHAR(40)
Class CHAR(6)
Marks NUMBER(4)
Rank CHAR(8)
60.Explain the type of relationship the following have :
Student and ID card
Customer and Bank
Student and Roll No
Customer and Car
61.Differentiate between SQL commands DROP TABLE and DROP VIEW.
62.Is Data Dictionary an essential part of DBMS. Why ?
63.What do you mean by integrity constraints ?give example.
64.Explain the term Distributed DBMS and Client-Server DBMS
65.What is query processing .explain the various steps involved in it.
66. Explain the four types of mapping cardinality with example.
67.Define the terms 1) physical schema 2) logical schema
2. What are logical levels is used in data abstraction?
3. Define data, database, DBMS and data base system.
4. Define DBMS.
5. What is meant by data abstraction?
6. Distinguish between physical and logical data independence.
7. What do you understand by data independence? How can it be achieved?
8. What are the data models present in DBMS?
9. What is a data dictionary? What are the information’s stored in the data dictionary?
10. What are the benefits of data dictionary? Who are the users of data dictionary?
11. What is meant by an Instance of the database and schema?
12. Explain briefly about E-R data model.
13. What is the purpose of Meta data?
14. Define the terms: (a) meta data (b)Canned transaction
15. What are the problems in data redundancy?
16. What is the purpose of buffer manager?
17. Define the term Atomicity in transaction management.
18. What are the characteristics that distinguish a DBMS from traditional file processing system?
19. What is the purpose of transaction manager?
20. List out the functions of DBA.Explain.
21. Who are all the database users present in DBMS?Give role of each.
22. Describe the different types of database end users.
23.Define database schema.
24.What are the different database languages?Explain.
25.What is the need for Normalisation ?
26.What is a referential integrity?
27.What is logical data independence and why is it important?
28.What is the difference between physical data independence and logical data independence?
29. What is Physical data independence?
30.Differentiate between XML and HTML.
31.Explain Semi-structured data model with an example.
33.What is object relational data model?
34.What is difference between object oriented data model and object relational data model?
35.What is difference between machine learning and data mining?
36.What is KDD?
37.Differentiate between KDD and Data Mining.
38.What is market basket analysis?
39.What is association rule mining?Give an example.
40.Describe the structure of a DBMS.
41.What do you mean by a data model?
Describe the different types of data models used.
42.Describe the main components of a DBMS.
43.Discuss the advantages and characteristics of the three-tier-architecture.
44.Compare the two-tier and three-tier client server architecture.
45.Why null values are introduced in the database?
46.What is meant by the term client/server architecture and what are the advantagesand disadvantages of this approach?
47.Consider the following relational schema
Account (account-number, branch-name, balance)
Loan (Loan-number, branch-name, balance)
Depositor (Customer-name, Account-number)Borrower (Customer-name, Loan-number)
Write queries in SQL for the following:
(a)Find all loan numbers for loan made at Bombay branch.
(b)Find all customers who have both a loan and an account at the bank.
(c)Find the average account balance at each branch.
(d)Find the number of depositors at each branch.
48.What is data mining?
49.What is data warehouse?
50.List four significant differences between a file-processing system and a DBMS.
51.Describe a circumstance in which you would choose to use embedded SQL rather than using SQL alone.
52.What is meant by an entity, attributes, entity set and relationship ?
53.How is E-R data model useful ?
54.Give example of following relationships :
(i) Many-to-One
(ii) One-to-One
(iii)One-to-Many
(iv) Many-to-Many
55.What do you mean by redundancy ?How this can be avoided ?
56.What is the difference between Procedural DML and Non-Procedural DML ?
57.What do you mean by instance & schema ? Explain the difference between these.
58.What is the role of three levels of Data Abstraction ?
59.Give SQL statement which creates a STUDENT table consisting of following fields.
Name CHAR(40)
Class CHAR(6)
Marks NUMBER(4)
Rank CHAR(8)
60.Explain the type of relationship the following have :
Student and ID card
Customer and Bank
Student and Roll No
Customer and Car
61.Differentiate between SQL commands DROP TABLE and DROP VIEW.
62.Is Data Dictionary an essential part of DBMS. Why ?
63.What do you mean by integrity constraints ?give example.
64.Explain the term Distributed DBMS and Client-Server DBMS
65.What is query processing .explain the various steps involved in it.
66. Explain the four types of mapping cardinality with example.
67.Define the terms 1) physical schema 2) logical schema
