Have an account?
Skip to Content
Build your own quiz
Suggestions for you
30 questions
Show Answers
See Preview
- 1. Multiple Choice
What Query view is shown in this image?Datasheet ViewDesign View - 2. Multiple ChoiceWhat Query view is shown in this image?Datasheet ViewDesign View
- 3. Multiple ChoiceWhat is letter "A" showing?Where to configure the Join properties
Where to show the results of the query
Where to configure which fields and criteria are used for the QueryWhere to create the query in design view
- 4. Multiple ChoiceWhat is letter "B" showing?Where to click to Run the QueryWhere to Configure the Fields returned and criteria to be used
Where to click to configure the relationship between tables
Where to click to Save this Query - 5. Multiple ChoiceWhat is letter "C" showing?Where to click to Run the QueryWhere to Click to Save the QueryWhere to configure the Fields returned and the criteria to be usedWhere to configure the Join properties
- 6. Multiple ChoiceA query can get its data froma. one or more tables.b. existing queries.c. a combination of a and b.
d. tables, queries and reports
- 7. Multiple ChoiceWhich Boolean operator will narrow your resultsANDORNOTBUT
- 8. Multiple ChoiceWhich Boolean operator will expand your resultsANDORNOTBUT
- 9. Multiple ChoiceA football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?Position = "Striker" OR Goals = 20Position = "Striker" AND Goals = 20Position = "Striker" or Goals >=20Position = "Striker" AND Goals >= 20
- 10. Multiple Choice8. Sorting from A-Z is also called a descending sort.TrueFalse
- 11. Multiple ChoiceA teacher keeps pupil test results in a database. Each pupil has sat multiple tests. The teacher wants to run a query that shows each student and the average score they have achieved across the year. What would be the correct query to use:Parameter Query
Aggregate/GroupBy
WildcardSelection - 12. Multiple ChoiceWhat function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?QueryFormReportTable
- 13. Multiple Choice
What is this operator? >
Equal toNot equalLess than
Greater than
- 14. Multiple Choice
_____ contains the condition on the basis of which the records will be filtered in the Query output.
Criteria
Table
Field
Advanced Filter
- 15. Multiple Choice
What is the criteria for the query shown in the image
Teacher
Degree
No
Yes
- 16. Multiple Choice
The image shows two database tables. Which of these queries below show fields that came from both tables? (You can have multiple answers)
- 17. Multiple Choice
For the query shown in the image, what criteria was used to produce the result?
no degree
yes degree
name
females
- 18. Multiple ChoiceQueries that you use to retrieve data from a table or to make calculationsselect queriesaction queriesupdate queriesdelete queries
- 19. Multiple Choice
It is a logical operator that allows you to specify whether a value is in a range or not.
ORLikeINBetween AND - 20. Multiple ChoiceThis lets you see how your query is put together.query designquery wizardquery reportcreate query
- 21. Multiple Choice
What field in the course table is used to sort the records
CID
Name
Credits
Faculty
- 22. Multiple Choice
State the primary key in the COURSE table
Name
CID
Credits
Faculty
- 23. Multiple Choice
The two tables have been joined by a common field. State the name of the Dean of the faculty that is offering the course with CID = ECN 100
Tiwari
Scott
Hussain
Economics
- 24. Multiple Choice
In the COURSE table it is required to insert a calculated field named FEE to compute the fee for EACH course. If the cost per credit is $250, write the formula for the calculated field.
Fee=250*Credit
[Credit]*250 = Fee
Fee: $250 * Credit
Fee:250*[Credit]
- 25. Multiple Choice
In which of the following formats data is stored in the database management system?
Table
Image
Text
Graph
- 26. Multiple Choice
The term _____ is used to refer a row
Record
Primary key
Foreign key
Field
- 27. Multiple Choice
The attribute refers to a _____ of a table
Record
Foreign key
Primary key
Field
- 28. Multiple Choice
Which one of these cannot be taken as a primary key?
ID
Registration No
Department ID
Street
- 29. Multiple Choice
What is the correct definition of primary key?
One way to restrict input in a table field
The field which we will use to search with
A field that contains unique data in each record
The first field in a table
- 30. Multiple Choice
Which of the following holds a single piece of data?
Form
Table
Record
Field
- Answer choicesTagsAnswer choicesTags