Which of the following queries modifies fields not records?

Related MCQs

• Which of the following type s of queries are action queries?
• Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
• You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
• You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
• Which of the following is not one of the methods available in the new query dialog box to create queries?
• Which of the following queries prompts users for input data by displaying dialog boxes?
• Which of the following queries can create a table?
• Which of the following database objects extracts information from one or more tables or queries?
• In Access to switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)
• To create queries in Access