WorksheetsRdbms
Total questions: 15
Worksheet time: 8mins
A database can have only one table.(T/F)
True
False
A database is an organised collection of
Data
Attributes
record
none of the above
Which of the following software is appropriate to store data about school students
Calc
ms-access
writer
Impress
Which of the following is not a database program
mysql
oracle
writer
oobase
Which file store data in a single table
flat file
Relational
single
one file
GUI act as front end and database server act as
Container
back end
end
none of the avove
Duplication of data is called
Inconsistency
consistency
redundancy
foreign key
Which of the following is not the advantage of database
Sharing of data
reduce data redundancy
increase data inconsistency
data security
___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.
Main server
web server1
Database server
non database server
A---------in a table represent a relationship among a set of values
coloumn
row
Key
Entry
The term--------is used to refer to a row
Attribute
Tuple
field
instance
The tuples of the relation can be of-------order
Any
same
constant
Sorted
Consider attributes ID,CITY,NAME.which one of this can be considered as a super key
name
ID
CITY
CITY,ID
Using which language can a user request information from a database
query
Relational
structural
compiler
Which one of the following is a procedural language
domain relational calculus
Tuple relational calculus
Relational algebra
query language
