atch each term with the statement that best describes it. 8. Null 9. Parameter 1
ID: 3697001 • Letter: A
Question
atch each term with the statement that best describes it.
8. Null
9. Parameter
10. Top Values query
11. Inner join
12. Action query
13. Properties
a. Characteristics that define the appearance and behavior of items within the database
b. Displays only a number or percentage of records from a sorted query
c. Displays a dialog box prompting you for criteria
d. Means that the query displays only records where joined fields from both tables are equal
e. Makes changes to data
f. A field value that does not exist
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
Answer :
8. Null:A zero value in several branches of mathematics.
9. Parameter:A parameter in its common meaning, is a characteristic, feature, or measurable factor that can help in defining a particular system.
10. Top Values query:You use a top value query when you need to find records that contain the top or bottom values in a table field.
11. Inner join:The INNER JOIN creates a new result table by combining column values of two tables (table1 and table2) based upon the join-predicate. The query compares each row of table1 with each row of table2 to find all pairs of rows which satisfy the join-predicate. When the join-predicate is satisfied, column values for each matched pair of rows of A and B are combined into a result row.
12. Action query:An action query is a query that makes changes to or moves many records in just one operation. There are four types of action queries: delete, update, append, and make-table.
13. Properties
a. Characteristics that define the appearance and behavior of items within the database
14. Which join type selects all records from the “one” (parent) table?
b. Left
15. Which of the following is a valid parameter criterion entry in the query design grid?
a. >=[Type minimum value here: ]
16. You cannot use the Top Values feature to:
b. Show the top 30 records.
17. Which of the following is not an action query?
a. Union query
18. Which of the following precautions should you take before running a Delete query?
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.
20. Which of the following is not a type of Select query?
d. Parameter
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.