Font size
WorksheetsRDBMS
Total questions: 20
Worksheet time: 4mins
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
When primary key is made up of two or more columns then it is called __ primary key
a. Mixed
b. Reference
c. Composite
d. Compost
Duplicate values can be entered in primary key.(T/F)
a. True
b. False
A key which is referring to the primary key of another table is called _______
a. Alternate Key
b. Primary Key
c. First Primary Key
d. Foreign Key
A field which is ______ for each and every record is called Primary key.
a. Common
b. Same
c. Unique
d. None of the above
a. Common
b. Same
c. Unique
d. None of the above
Identify the Foreign Key from table “Sales”
Table Client:
ClientID (primary Key)
clientname
clientphone
Table : Sales
SalesID (Primary Key)
ClientID
Profit
a. SalesID
b. Profit
c. Clientphone
d. ClientID
There can be multiple primary key in a table.(T/F)
a. True
b. False
a. True
b. False
___________ represent a single record in a table.
a. Tuples
b. Attributes
c. Relation
d. All of the above
Every row in a table has the same structure.(T/F)
True
False
__________ are used to identify which type of data we are going to store in the database.
a. Datatype
b. Record
c. Table
d. Attributes
RDBMS stands for
Relational Database Manegement system
Rational Database Manegement system
Relative Database Manegement system
Related Database Management System
