WorksheetsDatabase
Total questions: 18
Worksheet time: 9mins
Which software is used to store and manage database?
OpenOffice Writer
OpenOffice Calc
OpenOffice Database
None of the above
In a database, Multiple _________ can be created.
Tables
Documents
Primary Key
All of these
___________________ Key uniquely identifies each record in table.
Fields
Record
Row
Primary
____________ option allows you to design the table.
Table Data View
Table Design
Properties
Create
In a Database, each row is called a _____________
Field
Data
Record
Table
In a Database, each column is called a _____________
Field
Data
Record
Table
This table has ___________ records.
2
4
5
6
This table has ___________ fields.
2
4
5
6
___________, ___________ & ___________ are fields.
S. No, Product Code & Description
1021, Beverages & Soft drinks, coffees, teas
Dairy Products, Beverages & Seafood.
All of these are fields.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
Name
ID
City
All of these
Which one of the following attributes cannot be taken as a primary key?
ID
RegistrationNo
DepartmentID
Street
Which of the following are common database program?
MS Access
Excel
InDesign
OpenOffice Database
Which of the following is an example of a DBMS
MS Word
Microsoft Office
Java
Oracle
Database if the collection of information or group of facts in a structured way.
Maybe
No
Yes
Not Always
______________ datatype you'd select for entering "Address".
Number
Date
Text
Time
You have to enter Sam's DOB, What datatype would you use for this field.
Time
Date
Text
Number
Information corresponding to each field is called (a) .
______________ symbol indicates that a field is the Primary Key of the table.
All of these
