DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
select queries
|
|
|
action queries
|
|
|
update queries
|
|
|
delete queries
|
Detailed explanation-1: -Queries that you use to retrieve data from a table or to make calculations are called select queries. Queries that add, change, or delete data are called action queries. You can also use a query to supply data for a form or report.
Detailed explanation-2: -You can use an append query to retrieve data from one or more tables and add that data to another table.
Detailed explanation-3: -You can use an asterisk character, *, to retrieve all the columns. In queries where all the data is found in one table, the FROM clause is where we specify the name of the table from which to retrieve rows.
Detailed explanation-4: -Solution. Queries are used to retrieve information from database.
Detailed explanation-5: -They are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries.