Font size
WorksheetsMore on database objects
Total questions: 15
Worksheet time: 10mins
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
What is a field in a related database table that refers to the primary key in the primary table?
Secondary key
Table key
Foreign key
Common key
How many characters are allowed in the Text field?
(a)
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
(a)
You have to enter Sam's DOB, What datatype would you use for this field.
(a)
To find pupils who scored more than 50%
(a)
Search to find pupils' who attained a mark of 45% and above and 65% and below
(a)
Given below relationships:
Adam learn Computer Science
Ai Ling learn Geography
Anatasia learn History
State related entities for statements above.
Subject
Subject & Student
Subject, Student & Learn
Student
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
What are the 4 main objects in a database?
Tables, Forms, Reports, Keys
Spell Check, Grammar, Ruler, Tools
Tables, Queries, Forms, Reports
Cells, Columns, Rows, Sheet
To Enter Data in a Database showing only ONE record at a time, what must you create a:
A Record
A Report
A Form
A Querry
Which of the following would you use to display the data from a query in a professional format?
Table
Form
Query
Report
What is a foreign key?
A FOREIGN KEY is a field in one table that matches the PRIMARY KEY in another table.
A foreign key is a field in a table that uniquely defines every record uniquely
