WorksheetsSort Search and Linking two Tables
Total questions: 26
Worksheet time: 15mins
What is the purpose for SORT and SEARCH operations?
To arrange data records in different ways
To reduce number of records displayed
To put records in alphabetical order
To look for one record within table
SEARCH operation will usually
Display records for which matching criteria is not true
Reduce number of records displayed
Drop records for which matching criteria is true
Look for one specific field
SORT operation will never reduce number of records displayed within database.
True
False
Search criteria to display records where DOB is: <= 01/01/2000 AND >= 31/12/2000 will display records with dates between:
1st of January and 31st of December 2000
2nd of January and 30th of December 2000
None
All dates before 1st of January 2000
What is the purpose of setting second SORT criteria for the same data table?
To have all data records sorted in two ways
To confuse everybody
To spend more time working on database
To sort records with identical values only after performing first sort
What two tables need to have to be linked?
At least one same record
Same table names
Common column
Many to many relationship
What is the name of common column which is used to link two tables together?
Primary Key
House Key
Foreign Key
Relationship Key
Foreign Key is:
Primary Key column for one of the two linked tables and one of the column name inside another which acts as a connector between them.
Key to understand data table written in different language
Not well understood concept in Database Development
Column which holds unique values for every record in database
One to many relationship between table is when:
Many records of table 1 can match one or more records in table 2
Yes
Single record in first table can be repeated within one or many records inside second table
Table picks which other table is the best to be related to
To set up relationship between tables in Microsoft Access you need to go to:
Create New Query Design
Insert tab
Database Tools tab
inside Design View
Flat database file is:
Database limited to hold only less than 100 data records
Database which stores data in one table only
Database which is not complicated
File which holds personal data only
Database with linked tables is called also:
Non-relational database
Flat database file
One to many relation database
Relational database
Foreign Key can be any common column between two tables:
True
False
One of the major issue of flat database file is:
It holds to many records in one table
Data can be duplicated which can cause errors
Searching for records takes time
Sorting is difficult because many records are identical
According to GDPR personal data needs to be processed lawfully, fairly and may have not accessible hidden content if the data subject is concerned with safety of its data.
True
False
According to GDPR personal data cannot be used for any other purpose which is not declared.
True
False
According to GDPR personal data doesn't need to be updated with any changes.
True
False
Is this the right order for Stages of Database Development Lifecycle?
Analysis/Design/
Implementation/Testing/
Documentation/
Evaluation/Maintenance
Yes
No
Analysis stage collects the information in range of:
user requirements
good behaviour management
data types
functional requirements
What are the three types of documentation required to be produced during design stage of Database Development?
Table linking and Relationships
Data Dictionary
Entity Relationship Diagram (ERD)
Design of a Query
In design stage ENTITY is identified as a ... in Database File.
(type in missing word)
(a)
In design stage of DD the fields within table are called .....
(type in missing word)
attributes
attribute
an attributes
an attrinbuties
Many side of relationship between two tables is indicated on ERD by the symbol of:
crow's foot
number 1
What is the purpose of writting the query design?
Saving time
To cause confusion
To plan what needs to be done within database
Practise typing skills
Which answer describes the best what is Referential Integrity?
Critical Accident
Total reset of database records
it sets up the reference to check integrity
No data can be entered into foreign key field that doesn't exist in the primary key field in other table.
Databases can be evaluated in two ways:
fit for purpose
grammar mistakes
accuracy of output
going through the database paperwork
