Bsc Computer Science Dbms Question Paper

Bsc Computer Science Dbms Question Paper BSc Computer Science DBMS Question Paper This question paper is designed to assess the students understanding of Database Management Systems DBMS concepts and their ability to apply them in practical scenarios It is divided into three sections Section A Multiple Choice Questions 20 Marks This section contains 20 multiplechoice questions each carrying 1 mark The questions will cover fundamental concepts and definitions related to DBMS Students are required to choose the most appropriate answer from the given options Section B Short Answer Questions 40 Marks This section contains 8 short answer questions each carrying 5 marks The questions will assess the students understanding of core concepts and their ability to explain them in their own words Answers should be concise and accurate demonstrating a clear comprehension of the topic Section C Long Answer Questions 40 Marks This section contains 4 long answer questions each carrying 10 marks These questions will require students to demonstrate indepth knowledge and analytical skills Answers should be comprehensive wellstructured and supported by relevant examples and diagrams where applicable Total Marks 100 Time Allowed 3 Hours Note All questions are compulsory Use separate answer sheets for each section Please write your name and roll number on all answer sheets Mobile phones and other electronic devices are strictly prohibited Sample Questions 2 Section A Multiple Choice Questions 1 Which of the following is NOT a characteristic of a relational database Data is stored in tables Data is organized in a hierarchical structure Data integrity is maintained through constraints Data redundancy is minimized 2 What is the purpose of a primary key in a database To uniquely identify each record in a table To establish relationships between tables To enforce data integrity To provide a fast search mechanism 3 Which database model is based on the concept of entities and relationships Relational model Hierarchical model Network model Objectoriented model 4 What is a transaction in a database A sequence of database operations treated as a single unit A set of related data stored in a table A query that retrieves data from a database A program that interacts with a database Section B Short Answer Questions 1 Explain the difference between a primary key and a foreign key 2 Describe the ACID properties of transactions 3 Briefly explain the concept of normalization in database design 4 What are the different types of database languages 5 Discuss the advantages and disadvantages of using a centralized database system 6 What is a database management system DBMS 7 What are the different types of database systems 8 Describe the different levels of database abstraction Section C Long Answer Questions 1 Discuss the various data models used in database management systems comparing their strengths and weaknesses 3 2 Explain the different types of database access methods Describe the factors to consider when choosing an appropriate access method 3 Describe the different types of database security threats and explain how these threats can be mitigated 4 Discuss the various database recovery techniques used to handle data loss and system failures Note This is just a sample question paper The actual question paper may vary based on the specific syllabus and learning objectives of the course This question paper structure allows for a comprehensive assessment of the students understanding of DBMS concepts and their application in realworld scenarios By covering fundamental knowledge practical application and theoretical aspects it ensures a well rounded evaluation of the students proficiency in database management