CS8492 Question Bank Database Management Systems
CS8492 Question Bank Database Management Systems Regulation 2017 Anna University free download. Database Management Systems Question Bank CS8492 pdf free download.
Sample CS8492 Question Bank Database Management Systems:
1. What are the disadvantages of file processing system?
2. Explain the basic structure of a relational database with an example.
3. What do you mean by weak entity set? CS8492 Question Bank Database Management Systems
4. Give example for one to one and one to many relationships.
5. What is the need of normalization?
6. Write a note on functional dependencies.
7. Who is a DBA? What are the responsibilities of a DBA?
8. What is a data model? List the types of data models used.
9. What are the components of storage manager?
10. What is a data dictionary? CS8492 Question Bank Database Management Systems
11. What is an entity relationship model?
12. Define single valued and multi valued attributes.
13. What are stored, composite and derived attributes?
14. What is meant by the degree of relationship set?
15. Define weak and strong entity sets? CS8492 Question Bank Database Management Systems
16. Explain the two type’s o f participation constraint.
17. Define the two levels of data independence. CS8492 Question Bank Database Management Systems
18. Write down any two major responsibilities of a database administrator.
19. Define irreducible sets of dependencies.
20. Define the normal forms.
1. List the string operations supported by SQL?
2. List the set operations of SQL?
3. What are aggregate functions? And list the aggregate functions supported by SQL? CS8492 Question Bank Database Management Systems
4. What is the use of group by clause?
5. What is the use of sub queries? CS8492 Question Bank Database Management Systems
6. What is view in SQL? How is it defined?
7. Write a SQL statement to find the names and loan numbers of all customers who have a loan at Chennai branch.
8. Consider the following relation :
EMP (ENO, NAME, DATE_OF_BIRTH, SEX, DATE_OF_JOINING, BASIC_PAY,
DEPT) Develop an SQL query that will find and display the average BASIC_PAY in each DEPT.
| Subject name | Database Management Systems |
| Short Name | DMS |
| Semester | 4 |
| Subject Code | CS8492 |
| Regulation | 2017 regulation |
CS8492 Database Management Systems Question Bank Click Here To Download
CS8492 Database Management Systems Important Questions
CS8492 Database Management Systems Syllabus
CS8492 Database Management Systems Notes