Saturday, 2 October 2021

U-3 RDBMS / Class-10th IT 402 / Test-1

 

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

L-1 Indian Heroes in IT/ 8th computer

  Class 8 th Subject : Computer Science L-1 Indian Heroes in IT Make a list of Indian Heroes in IT with their achievement S....