Government Degree College, Baramulla (Autonomous) Government Degree College, Baramulla (Autonomous)
Term End External Examination 4th Semester (Session- July 2024) vii. We use this to ensure maintain transactional integrity and
Subject: Computer Science consistency in databases:
Course No and Title: CAPC1422N/Introduction to database System A Pointers B Cursors
Time: 2.15 hours Max Marks:100 Min. Marks:40 C Locks D Triggers
viii. ACID Properties of database are used to ensure_____ before and
Section A: Objective Type Questions after transactions.
Q1. Choose the appropriate Answer: (8x1.5=12) A Consistency B Redundancy
C Latency D Anonymity
i. Data Integrity refers to
A Completeness, B Quality, availability and security Section-B: Descriptive Type Questions (Short Type)
correctness and accuracy of data. Q2: Answer all the Questions (8 x 4 =32)
of data
C Store, retrieve and update D Flexibility, sharing and
i. What is a Database? Explain basic operations performed on
data inconsistency.
Databases.
ii. In ER model, a number of entities are clubbed together into one
entity based on their similar characteristics. The process is called ii. What is abstraction? Briefly explain three levels of Database
A Specialization. B Generalization. Abstraction?
C Aggregation D Abstraction iii. What are Keys? List different types of keys used in RDBMS.
iii. Relational algebra is Explain any two?
A High Level language B Procedural Language iv. What are views? Explain briefly with an example.
C Non-Procedural Language D Data manipulation Language
v. Explain transitive dependency with an example.
iv. Cardinality in Relational Algebra means:
A Number of tables. B Number of Attributes. vi. Write syntax of “Group By with having clause” command with an
example. Consider a table student (roll no, sub) display roll
C Number of tuples. D Number of keys.
number wise, subject count of opted subjects by students.
v. The statement in SQL which allows to change the definition of a
table is: vii. What are concurrency control protocols? List types of concurrency
A Select B Create control protocols.
C Update D Alter viii. Elaborate Database backups. Briefly explain physical and logical
vi. Which one of these cant be used when querying a view backups.
A Select B Order by
C From D Where
NO_BCA22C404_15072024_31 Page 1 NO_BCA22C404_15072024_31 Page 2
Government Degree College, Baramulla (Autonomous) Government Degree College, Baramulla (Autonomous)
Section – C: Descriptive Type Questions (Medium Type) Q9. What is Database Normalisation? Briefly explain types of
Answer all the questions: (4 x 7=28) normalisation. Discuss advantages and disadvantages of
normalisation.
Q3. Explain basic differences between File System and Database
Systems approach. Q10. Define Transactions? What are its various states? Briefly explain
ACID Properties of transaction.
OR
Explain three level DBMS Architecture. Briefly explain Data
Independence and its types?
Q4. What is a relational Database Management System? Briefly
describe its basic concepts.
OR
What do you mean by Relational Integrity constraint? Briefly
explain categories of integrity constraints.
Q5. Explain Lossy and Lossless decomposition.
OR
Define Equi-Join and Outer-Join in SQL with an example of each.
Q6. What do you understand by concurrency control? Briefly explain
three problems of concurrency control.
OR
What is serializability of schedules? Explain conflict and view
serializability.
Section – D: Descriptive Type Questions (Long Type)
Answer any two of the following: (2 x 14=28)
Q7. Discuss ER Model of database design? Briefly describe its
building blocks. Draw necessary diagrams for classifications.
Q8. What do you mean by Relational Algebra? Briefly explain any
Two Set Operations (Union, intersection, Cartesian Product,
difference) and One Special Operations (Select, project, join) in
relational algebra with examples of each?
NO_BCA22C404_15072024_31 Page 3 NO_BCA22C404_15072024_31 Page 4
