Class-
10th
Subject
: Information Technology (402)
Book
: Domestic Data Entry Operator
UNIT-3
RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC)
Revision
Test -1
Answer
Fill in the blanks
1) A database is an organized collection of data. You can visualize
it as a container of information.
2) Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL,
FoxPro, SQLite , Microsoft Access, OpenOffice.org Base, and MySQL are examples
of database programs.
3) Full form of DBMS is Database Management System
.
4) A database
management system is a software
package with computer programs that controls the creation, maintenance, and use
of a database
5) Data is stored in a single table. Usually
suitable for less amount of data is called flat file .
6) Data is stored in multiple tables and the
tables are linked using a common field. Relational is suitable for medium to
large amount of data is called relational file .
7) Database servers are dedicated computers that hold the
actual databases and run only the DBMS and related software.
8) Typically databases available on the
database servers are accessed through command line or graphic user interface
tools referred to as Frontends; database
servers are referred to as Back-ends.
Such type of data access is referred to as a client-server model.
9) The database management systems contain
multiple files that are to be stored in many different locations in a system or
even across multiple systems or multiple copies of same file is called data redundancy .
10) Data integrity means
that the data is accurate and consistent in the database
No comments:
Post a Comment