Have an account?
Skip to Content
Build your own quiz
Suggestions for you
20 questions
Show Answers
See Preview
- 1. Multiple Choice
What kind of relationship is this?
one-way
one-to-many
many-to-one
two-way
- 2. Multiple Choice
Which one is the correct example of a Boolean data type?
left/right
true/false
yes/no
0/-1
- 3. Multiple Choice
What is a primary key?
A primary key sets the data types in a table
A primary key uniquely identifies each table in a database
A primary key uniquely identifies each record in a table
A primary key links two tables or more
- 4. Multiple Choice
Which one is the primary key?
Qual_Code
Full_Time
None of the above
Course_Code
- 5. Multiple Choice
Which button do we press to see the filtered results in the query?
Run
View
Update
Make Table
- 6. Multiple Choice
Which one is the correct example of a double data type?
ABC
2.532
589
$12.50
- 7. Multiple Choice
A table is in a …. format. But when importing, it is selected as a ...... format.
excel... text...
csv... text...
text... csv....
csv... excel...
- 8. Multiple Choice
What is a foreign key?
A foreign key is a set of attributes in a record that refers to a database.
A foreign key is a key to have a successful database system
A foreign key is another name for a primary key
A foreign key is a set of attributes in a table that refers to the primary key of another table.
- 9. Multiple Choice
Before we are creating a report, we must first create the…?
Table
Query
Relationship
All of the above
- 10. Multiple Choice
When we are doing a data entry into a table, we are actually creating a new …?
query
table
record
form
- 11. Multiple Choice
Every row in a table represents a ...
primary key
report
record
relationship
- 12. Multiple Choice
What is wrong with this report layout?
All is well. Nothing is wrong.
unsuitable font size
not in alphabetical order
data is not showing in full
- 13. Multiple Choice
This filtering criteria will return a result as…?
Cherry Lip Balm
Ice cherry drink
Black hawk cherry
pineapple cheery crush
- 14. Multiple Choice
We cannot reuse the same query for a new report.
True
False
- 15. Multiple Choice
What is a relational database?
stores and allows access to data
A single table that contains all fields used in a database
A collection of data items with pre-defined relationships between them.
All of the above
- 16. Multiple Choice
What are the operations we could do in a query?
Filter records and update the database
Perform calculation and edit records
Filter and edit record
Filter records and perform calculation
- 17. Multiple Choice
This menu allows the user to…
create a query
delete a query
edit a query
filter records
- 18. Multiple Choice
This menu allows the user to… (more than 1 answer)
edit a report
create labels
create a report
view a report
- 19. Multiple Choice
This menu allows the user to…
Import a query
export a query
import a table
export a table
- 20. Multiple Choice
This menu allows the user to… (more than 1 answer)
group records
delete records
edit records
sort records
- Answer choicesTagsAnswer choicesTags