Select the best answer from the list of choices. 14. Which join type selects all
ID: 3697006 • Letter: S
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
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 field’s 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
Explanation / Answer
14)b
15)d
16)c
17)a
18)d
19)c
20)b
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.