RDBMS

A collection of facts is

• Data

• Information

• Database

• None of the above

Example of Processed data is

• Red

• The color of my car is red

• Car

• Color

What is not true about DBMS?

• It is collection of data/information.

• Data is collected in an organised way

• Data can be easily accessed, managed and updated

• Data once entered cannot be changed.

A group of software that organises data by using packages to define, manipulate, retrieve and mangage data is called

• Database Management System

• Spreadsheet Software

• Multimedia Software

• Desktop Publishing Software

Choose all the DBMS software

• Oracle

• Mysql

• Excel

• Word

• Foxpro

________________ and ______________ are the two types of Database

• Flat file and Relational file

• Flat file and Word file

• Relational file and Word file

• Word file and Excel file

Choose all the statement true about flat file

• Can store data in a single Table

• Tables are inter-related

• Suitable to store small amount of data

• Can have duplicate values

• Can accidently delete an important data

Choose all the statement true about Relational Database Management System

• Can store data in multiple tables that are inter-related

• Developed using 13 golden rules of E F Codd

• Avoids Duplicate Data

• Cannot run complex queries

• Better security and easy upgradation of the existing software is available.

Dedicated computers that holds the data and the database software is called

• Server

• Client

• Front end

• None of the above

A unique value that individually identifies each row in a RDBMS table is called

• Foreign Key

• Primary key

• Candidate key

• Composite key