All DBMS Guided Questions #everythingforhelp #EverythingForHelp "everything for help" "Everything For Help"

All DBMS Questions and answers for Preparation in 4th Semester :-

1 Mark Questions and Answers :-

1. Define record 
2. Define degree
3. Define foreign key
4. Define SQL
5. Define mapping 
6. Define DDL
7. Define DML 
8. Define query processor 
9. Define primary key
10. Define candidate key
11. Define Entity
12. Define Tuple
13. Define DCL
14. Define PL/SQL
15. Define Null
16. What is Schema
17. Examples of RDBMS,  DBMS
18. Define File
19. Define grant (command)
20. Define revoke

2 marks : - 

1. What do you mean by Data independence? 
2. What are three levels of DBMS architecture? 
3. What do you mean by degree of relationship? 
4. Different between candidate key and foreign key
5. What are various types of access control? 
6. Write steps to create a view.
7. Name various types of indexes
8. Different between trivial and non trivial dependencies
9. What do you mean by decomposition? 
10. What are various notations used in E-R diagram? 
11. What are various issues of data security? 
12. Write commit and rollback commands
13. Write create table statement with example
14. What are used of alter command? 
15. What are big data activities? 

5 Marks :-

1. Compare conventional system and data system (dbms)
2. Explain structure of DBMS
3. Explain insert,  update and delete commands with example
4. What are various types of joins? 
5. Differentiate between authentication and authorisation
6. Explain BCNF in brief
7. What are various normal forms of DBMS? 
8. Explain use of conditional expression in select command with example
9. Different between 3NF and BCNF
10. Explain multiple valued dependencies
11. What are various mapping constraints
12. What is trigger and explain its characteristics? 

10 Marks 

1. Explain various users of DBMS
2. Explain database administrator
3. Explain relational model with constraint with keys
4. Explain DBMS architecture with three levels

Thanks for Visiting

Written and Designed by "Everything For Help" and "AbdurRahman G"