Question

Which of these is not a type of query?
(1)Select
(2)Update
(3)Delete
(4)Insert
:) @_@ ^_^

Answer 1

(a) Which of these is not a type of query?

(i) Select

(ii) Update

(iii) Delete

(iv) Insert

Answer : (iii) Delete

In Microsoft Office Access, previously known as Microsoft Access, Queries enables you to view data from a table based on a specified criterion.

Answer 2

Answer: (1) SELECT

Concept : Queries

Given : (1) select

            (2) update

            (3) delete

            (4) insert

To Find : Which of these is not a type of query?

Explanation:

Queries are the basic means for extracting an information from a table. Queries are used to view, analyze and update data in various ways. Queries can access single or multiple table. There are five types of queries in Microsoft Access - Select query, Action query, Parameter query, SQL query, Crosstab queries.

In SQL, there are four types of queries :

• DDL (Data Definition Language) - CREATE, DROP, ALTER, TRUNCATE
• DML (Data Manipulation Language) - INSERT, UPDATE, DELETE
• TCL (Transaction Control Language) - COMMIT, ROLLBACK, SAVEPOINT
• DCL (Data Control Language) - GRANT, REVOKE

Select is not a type of query.

Option (1) is the required answer.

#SPJ2