Scribd
Upload
16 views2 pages

IAT - 2 Question Bank

This document is an internal assessment test question bank for the Database Management Systems course at Jayaraj Annapackiam CSI College of Engineering. It outlines the course outcomes, assessment structure, and includes a variety of questions divided into three parts: Part A with short answer questions, Part B with detailed explanations, and Part C with comprehensive topics. The test is scheduled for May 14, 2025, and covers key concepts in database management, including SQL queries, indexing strategies, and database security.

Uploaded by

reginafrancis1983
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
16 views2 pages

IAT - 2 Question Bank

This document is an internal assessment test question bank for the Database Management Systems course at Jayaraj Annapackiam CSI College of Engineering. It outlines the course outcomes, assessment structure, and includes a variety of questions divided into three parts: Part A with short answer questions, Part B with detailed explanations, and Part C with comprehensive topics. The test is scheduled for May 14, 2025, and covers key concepts in database management, including SQL queries, indexing strategies, and database security.

Uploaded by

reginafrancis1983
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

FORM NO.

: F01
JAYARAJ ANNAPACKIAM CSI COLLEGE OF ENGINEERING
(Approved by AICTE, New Delhi, affiliated to Anna University,
Chennai & Accredited by NBA(CSE))
NAZARETH
DEPARTMENT OF INFORMATION TECHNOLOGY
(Common to Computer Science and Engineering & Information Technology)
INTERNAL ASSESSMENT TEST II
QUESTION BANK
Class: II CSE / II IT Date:14.05.25
Course Code & Name: CS3492 – Database Management Systems Session: FN
Course in-charge: Dr. J. Jensy Rajakumari Asso.Prof./IT Max.Marks:50
Mrs. A. Regina Elizabeth, AP/CSE Duration: 1.30 hrs
Time: 11:30 a. m. – 1:00 p. m.
Course Outcomes:
CO1: Construct SQL Queries using relational algebra
CO2: Design database using ER model and normalize the database
CO3: Construct queries to handle transaction processing and maintain consistency of the database
CO4: Compare and contrast various indexing strategies and apply the knowledge to tune the
performance of the database
CO5: Appraise how advanced databases differ from Relational Databases and find a suitable
database for the given requirement.
PART-A 5 x 2 = 10 Marks
Q.
Questions
No.
1 How will you handle deadlock during two transactions in database?
2 What is hash-based indexing?
3 List three components of query processor?
4 Define distributed databases?
5 What are the challenges faced when using an encryption system?
6 Define dead lock and list the conditions for deadlock
7 Define B+ trees
8 What is the need for RAID
9 State CAP theorem
10 List the different types of SQL injection attacks
PART - B 4 x 7 = 28 Marks
Q.
Questions
No.
1 Explain in detail about different types of locks?
2 Explain in detail about ARIES algorithm
3 Explain in detail about Multiple Granularity.
4 Explain in detail B+ trees and give one example.
5 Construct B+ tree for the following set of key values.
(2,3,5,7,11,17,19,23,29,31). Assume that the tree is initially empty and values are added in
ascending order. Construct B+ tree for the cases where the number of pointers that fit one node is
four. After creation of B+ tree perform following series of operations.
(i) Insert 9 (ii) Insert 10 (iii) Insert 8 (iv) Delete 23 (v) Delete 19

6 Explain how to organize records in files.


7 What is the use of index structure and explain the concept of ordered indices
8 Explain in detail about static hashing.
9 Explain in detail about dynamic hashing
10 Explain in detail about query processing? Sketch and concise the basic steps in query processing
11 What is query optimization? Outline the steps in query optimization
12 Explain in detail about database security and also describe the security issues.
13 Explain in detail about encryption and public key infrastructure.

14 Explain in detail about key value stores and role-based access control in advanced distributed
database management systems

PART - C 1 x 12 = 12 Marks
Q.
Questions
No.
15 Explain distributed database architecture in detail.

16 Explain detail about NoSQL databases and describe the comparison between RDBMS
and NoSQL. Also explain types of NoSQL databases.

You might also like