RDBMS

A database is an organized collection of _______________.

• a. data

• b. Attributes

• c. Record

• d. None of the above

Which of the following software is appropriate to store data about school students?

• MySQL

• Word

• Excel

• Acess

Which of the following is not a database programs?

• a. MySQL

• b. Oracle

• c. Writer

• d. OObase

__________ store data in Single table.

• a. Flat File

• b. Relational

• c. Single File

• d. One File

___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.

• a. Main Server

• b. Web Server

• c. Database Server

• d. Non Database Server

Duplication of data is called _________.

• a. Inconsistency

• b. Consistency

• c. Redundancy

• d. Foreign Key

Data Integrity means that data is accurate and consistent in the database.(T/F)

• a. True

• b. False

A database can have only one table.(T/F)

• a. True

• b. False

Which of the following will help to maintain unique record in the table?

• a. Foreign Key

• b. Primary Key

• c. Composite Key

• d. Alternate Key

Which of the following field of table “Book” can act as primary key?

• a. Book_number

• b. Subject

• c. price

• d. Author_name