SRM ARTS AND SCIENCE COLLEGE SRM ARTS AND SCIENCE COLLEGE
(Accredited with A+ Grade by NAAC & An ISO 9001:2015 Certified Institution) (Accredited with A+ Grade by NAAC & An ISO 9001:2015 Certified Institution)
Kattankulathur – 603 203 Kattankulathur – 603 203
II - UNIT TEST, OCTOBER 2023 II - UNIT TEST, OCTOBER 2023
DEPARTMENT OF COMPUTER SCIENCE DEPARTMENT OF COMPUTER SCIENCE
Date : 06.10.2023 Duration : 1 Hr Class : III BSc (CS)-II Date : 06.10.2023 Duration : 1 Hr Class : III BSc (CS)-II
Subject Name & Code: RDBMS & SE25C Max : 25 Marks Subject Name & Code: RDBMS & SE25C Max : 25 Marks
SECTION – A SECTION – A
Answer any FIVE Questions (5 x 2 = 10) Answer any FIVE Questions (5 x 2 = 10)
CO1 BL1 1. Define Meta Data. CO1 BL1 1. Define Meta Data.
CO1 BL1 2. Define Entity and give example. CO1 BL1 2. Define Entity and give example.
CO1 BL4 3. Differentiate composite attributes and simple attributes? CO1 BL4 3. Differentiate composite attributes and simple attributes?
CO4 BL1 4. Define DDL and DML. CO4 BL1 4. Define DDL and DML.
CO4 BL1 5. List down the various data types in SQL? CO4 BL1 5. List down the various data types in SQL?
CO5 BL1 6. Find the use of DISTINCT keyword in SQL? CO5 BL1 6. Find the use of DISTINCT keyword in SQL?
CO1 BL1 7. List down the advantages of DBMS? CO1 BL1 7. List down the advantages of DBMS?
SECTION – B SECTION – B
Answer any ONE Question (1 x 5 = 5) Answer any ONE Question (1 x 5 = 5)
CO1 BL1 8. Explain the components of DBMS. CO1 BL1 8. Explain the components of DBMS.
CO4 BL1 9. Explain Constraints and its types. CO4 BL1 9. Explain Constraints and its types.
SECTION – C SECTION – C
Answer any ONE Question (1 x 10 =10) Answer any ONE Question (1 x 10 =10)
CO1 BL1 10. Explain E-R model with an example. CO1 BL1 10. Explain E-R model with an example.
CO5 BL2 11. Discuss about Triggers and its types with examples. CO5 BL2 11. Discuss about Triggers and its types with examples.
