Twitter Facebook Delicious Digg Stumbleupon Favorites More

Tuesday, 3 January 2017

IPU BCA/BBA Semester 2: DBMS Terminology (An Introduction)

DBMS Terminology 

IPU BCA/BBA Semester 2: DBMS Terminology (An Introduction)

An Introduction - Q & A


Q1: What is a database?

Answer: A database is an integrated collection of large data. Usually the data is so large that it
need to be stored on secondary storage devices such as disks or tapes. It models real world enterprise.

e.g. List of Bollywood movies since its inception including synopsis and the team details.


Q2: Define DBMS

Answer: DBMS stands for data base management systems. It is is a software package designed to store and manage databases (large datasets).


Q3: What are the advantages of using a DBMS?



Answer: Following are the advantages of using a DBMS:

Data independence: DBMS applications are independent of the details of data representation and storage. Conceptual and logical design separates how the data is stored physically.

Efficient access and Use: DBMS stores data taking efficient use of storage. It also provides faster access to required information using indexing.

Data administration: It provides a collection of utilities to manage data and users and other data maintenance tasks.

Data Integrity: A good DBMS provide integrity constraints to ensure that data semantics is not violated.

⑤  Data Security: DBMS provides privileges, access rights and other authorization facilities to make data secure.

Reduce Development Time and Cost: DBMS provides concurrency control, transaction rollbacks, data recovery, high level query access and reporting mechanisms, thus reducing development time considerably.


Q4: Define tuple.

Answer: A tuple or n-tuple is a given set of s1, s2, s3... sn of elements. In a relational database, earh row or record of a data table is called tuple. A relational data table consists of many rows (or tuples)


Q5: Define three level of data abstraction.

Answer: The three levels of data abstraction is depicted below. It consists of Many views, single conceptual (logical) schema and physical schema.

IPU BCA/BBA Semester 2: DBMS Terminology (An Introduction)


Views: describe how users see the data i.e. tabular form or graphical form.
Conceptual Schema: It defines the logical structure of the database.
Physical Schema: It describes the files and indexes used to store data in a database.


Q6: What is Data Independence? What are its types?

Answer: Data Independence is one of the important aspect of a good DBMS software. It refers to insulation of a DBMS application from how data is structured and stored.

It is of two types:
Logical data independence
Physical data independence

Logical data independence: It means insulation from changes in conceptual or logical structure of data.
Physical data independence: It means protection from changes in physical structure of data.


Q7: List the roles of DBA.

Answer: Roles of a Database administrator (DBA) are:

Designs logical /physical schema
Handles security and authorization
Data availability, crash recovery
Database tuning as needs evolve


Q8: Define the following terms:

  • Data
  • Field
  • Record
  • File


Answer:
Data: Collection of raw facts, e.g. list of telephone numbers, a birth date, a customer name etc. Data has little meaning unless it has been organized in some logical manner.

Field: A character or group of characters (alphabetic or numeric) that has a specific meaning. A field is used to define and store data.
e.g. A customer Name may have two fields 'First Name' and 'Last Name'

Record: It is a logically connected set of one or more fields that describes a person, place, or thing. For example,
the fields associated with a customer may consist of:
customer's name, address, phone number, date of birth, credit limit, and unpaid balance.

File: It is a collection of related records. For example, a file might contain data about the students currently enrolled at GGSIPU University.



Share:

0 comments:

Post a Comment

BCE-Hacks Notes

BCE-Hacks Notes
Chemical Engineering Notes

Maths Resources

Maths Resources
Maths Resources

Buy Books

Buy Books
Buy Books

Geography Quiz

Geography Quiz
Geography Quiz

NodeJS Tutorial

NodeJS Tutorial
Developer-Bytes

History MCQs

History MCQs
History Quiz For Competitive exams

Categories

Popular Posts

GooglePlus

Recent Posts

Unordered List

Express Print Zone

Eduvictors Quizzes

Online Quizzes, Study notes for CBSE Class 6 - 12

Text Widget

Compete4Exams

Study notes for Competitive Exams

Developer Bytes

Developer Bytes
Developer Bytes
Powered by Blogger.

Blogger Tutorials

Blogger Templates

Sample Text

Copyright © IP University Musings BCA, MCA, BBA, MBA, BTech Question Papers and Study Notes | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com