WorksheetsDatabase-Quiz-G11
Total questions: 15
Worksheet time: 8mins
What do we create in LibreOffice Base?
Spread Sheet
DataBase
Presentation
Word Document
Missing Word: " A Data Base is a collection of data stored in __________way.
a random
an organized
a haphazard
a numerical
A Data Base is split into:
cells
slides
tables
pages
In a Database table, Records appear as ______________
a row
a column
a form
a cell
A ______________ is part of a record and contains a single piece of data
row
cell
field
table
Forms don't help with :
creating new fields in a database table
Editing existing records in a database table
Entering data in a database table
Updating existing data in a database table
A query finds records in a database according to _________________ you give.
table
data
criteria
column
The following are example of what?
Field name
Query criteria
Data types
cells
What do we use to ensure that at least one aspect of a record is unique?
Forms
Field names
Data types
Primary key
You can import data to your database table
True
False
In LibreOffice, query criterion are Case Sensitive, it means that it makes difference between Upper and Lower case.
True
False
Select the right result:
How many results is the following query going to give?
Create a query to display ID, Fname, lastname and gender of Male gender OR having ID =6 and sort the result by ID Descending
How many records do we have in this table?
12
1
5
3
When you add a new field in a table, it will automatically show in the associated form.
True
False
It depends
