Question
Select the best answer from the list of choices. 14. Which join type selects all records from the one (parent) table? a. Inner c. Central
Select the best answer from the list of choices.
14. Which join type selects all records from the one (parent) table?
a. Inner
c. Central
b. Left
d. Right
15. Which of the following is a valid parameter criterion entry in the query design grid?
a. >=[Type minimum value here: ]
c. >=(Type minimum value here: )
b. >=Type minimum value here:
d. >={Type minimum value here: }
16. You cannot use the Top Values feature to:
a. Select the bottom 10 percent of records.
c. Display a subset of records.
b. Show the top 30 records.
d. Update a fields value by 5 percent.
17. Which of the following is not an action query?
a. Union query
c. Make Table query
b. Delete query
d. Append query
18. Which of the following precautions should you take before running a Delete query?
a. Check the resulting datasheet to make sure the query selects the right records.
b. Understand the relationships between the records you are about to delete in the database.
c. Have a current backup of the database.
d. All of the above
19. When querying tables in a one-to-many relationship with referential integrity enforced, which records appear (by default) on the resulting datasheet?
a. Only those with matching values in both tables.
b. All records from both tables will appear at all times.
c. All records from the one table, and only those with matching values from the many side.
d. All records from the many table, and only those with nonmatching values from the one side.
20. Which of the following is not a type of Select query?
a. Crosstab
c. Summary
b. Update
d. Parameter
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started