App Logo

No.1 PSC Learning App

1M+ Downloads
Find out the odd one?

ASelect query

BParameter query

CAction query

DData query

Answer:

D. Data query

Read Explanation:

Query

  • A query is an instruction to retrieve information from a table based on specific criteria
  • We can also use a query to modify the information that we retrieve
  • In access , we can categorize queries as follows:

select query

  • A select query retrieves information that we want from one or more tables in a database
  • We can also use a select query to group records and to calculate sums , counts average and other types of mathematical values
  • The select query can also do string manipulation.

Parameter query

  • A parameter query retrieves information in an interactive manner
  • We can use a parameter query to extend the flexibility of other query types

Action query

  • An action query performs an action on data in a table
  • We can use an action query to insert new records , to update existing records , or to delete existing records

Crosstab query

  • We can use a crosstab query to analyze information that you retrieved
  • We can use a crosstab query to group data in rows or in columns
  • We can also use a crosstab query to calculate the sum or the average of a data group
  • SQL -specific queries , such as the union query , the pass through query , and the data definition query
  • However ,Access does not provide a graphical user interface that we can use to create an SQL-specific query.

Related Questions:

Which operating system is developed and used by Apple Inc?

Application Software that is used to browse the internet :

  1. Microsoft Outlook
  2. Acrobat Reader
  3. Mozilla Firefox
    ഏറ്റവും വേഗത കൂടിയ വെബ് ബ്രൗസർ ഏത് ?
    Which type of query extract the data and put them in to separate table?
    ഉബുണ്ടു 20.04 LTS _______ എന്നാണ് അറിയപ്പെടുന്നത്?