data must be captured
Data Base Management System
USEFULL FOR FYBSC (IT) & TYBSC (CS) STUDENTS
1. What is database?
A database is a collection of information that is organized. So that it can easily be accessed, managed, and updated.
2. What is DBMS?
DBMS stands for Database Management System. It is a collection of programs that enables user to create and maintain a database.
3. What is a Database system?
The database and DBMS software together is called as Database system.
4. What are the advantages of DBMS?
I. Redundancy is controlled.
II. Providing multiple user interfaces.
III. Providing backup and recovery
IV. Unauthorized access is restricted.
V. Enforcing integrity constraints.
5. What is normalization?
It is a process of analyzing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties –
(1).Minimizing redundancy, (2). Minimizing insertion, deletion and update anomalies.
6. What is Data Model?
A collection of conceptual tools for describing data, data relationships data semantics and constraints.
7. What is E-R model?
This data model is based on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a set of attributes.
8. What is Object Oriented model?
This model is based on collection of objects. An object contains values stored in instance variables within the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.
9. What is an Entity?
An entity is a thing or object of importance about which data must be captured.
10. What is DDL (Data Definition Language)?
A data base schema is specifies by a set of definitions expressed by a special language called DDL.
Posted By-: Vissicomp Technology Pvt. Ltd.
Website -: http://www.vissicomp.com
This entry was posted in DBMS and tagged collection of conceptual tools, collection of information, collection of objects, contains bodies, data, Data Base Management System, data base schema, data model, data must be captured, data relationships data semantics and constraints, DBMS, DBMS interview questions, DDL, deletion and update anomalies, Enforcing integrity constraints, Entities, entity is a thing, Functional Dependencies (FDs) and primary key, grouped together into classes, instance variables within the object, methods, Minimizing insertion, Minimizing redundancy, object, object of importance, Providing backup and recovery, Providing multiple user interfaces, real world that consists of basic objects, Redundancy is controlled, same types of values, Unauthorized access is restricted, USEFULL FOR FYBSC (IT) & TYBSC (CS) STUDENTS.