Name of the College : Noorul Islam College of Engineering
University : Anna University
Degree : M.Sc
Department : Software Engineering
Subject Code/Name : XCS 235 – Database Management System
Year : 2nd
Semester : 3rd
Document Type : Question Bank
Website : niceindia.com
Download Model/Sample Question Paper : https://www.pdfquestion.in/uploads/niceindia.com/3121-XCS_235_DataBaseManagementSystem_-_S3_M._Sc_SE.pdf
NICE Database Management System Question Paper
1. Define database management systems :
A database management system is a collection of programs that enables users to create and maintain a database.
2. State the various processes of database :
a) Defining
b) Constructing
c) Manipulating
Related : Noorul Islam College of Engineering XCS353 Computer Networks M.Sc Question Bank : www.pdfquestion.in/3143.html
3. What are the characteristics of database :
a) self describing nature of the database
b) insulation between programs and data and data abstraction.
c) Support for multiple views of data
d) Sharing of data and multi-user transaction processing
4. Define-metadata :
The information stored in the catalog is called meta-data and it describes the structure of the primary database.
5. Define data abstraction :
The characteristics that allows program data independence and program operation independence are called data abstraction.
6. What are the advantages of DBMS? :
a) Controlling redundancy
b) Restricting unauthorized access
c) Providing persistent storage for program objects and data structures
d) Permitting inference and actions using rules.
7. What is data model? :
A data model is a collection of concepts that can be used to describe the structure of the database, which are data types, relationships and constraints that should hold on the data.
8. What are the categories of data model? :
a) High level or conceptual data model
b) Low level or physical data model
c) Representational or implementational data model.
9. Define entity, attributes and relationships :
Entity represent a real world object Attribute represent property that describes an entity. Relationship represents an interaction among the entities.
10. Define access path :
An access path is a structure that makes the search for particular database records efficient.
11. Define database schema :
The description of a database is called the database schema
12. Define database state or snapshot? :
The data in the database at a particular moment in time is called database state or snapshot.
13. Distinguish intension and extension :
The schema is called intension and a database state is called extension of the schema.
14. What are the types of attributes in the ER model? :
a) Simple versus composite
b) Single valued versus multi-valued
c) Stored versus derived
15. What are composite and simple attributes? :
Composite attributes can be divided into smaller subparts. Simple or atomic attributes are not divisible.
16. What are stored and derived attribute? :
The age attribute is called derived attribute and is said to be derivable from the birth data attribute which is called stored attribute.
17. How are complex attributes represented? :
Grouping components of a composite attribute between paranthesis and separating the components with commas and by displaying multivalued attributes between the braces {}. Such attributes are called complex attributes.
18. What is an entity type? :
An entity type defines a collection of entities that have the same attributes.
19. What is an entity set? :
The collection of all entities of a particular entity type in the database at any point in time is called an entity set.
20. What is a key attribute? :
An entity type usually has an attribute whose values are distinct for each individual entity in the collection. Such an attribute is called a key attribute.