COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Form
|
|
|
Report
|
|
|
Queries
|
|
|
Field
|
Detailed explanation-1: -A query is data resulting from questions you ask of one or more tables. For example, let’s say you want to find out how many male students are in Mr.
Detailed explanation-2: -A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources. You can use tables and other select queries as data sources for a select query.
Detailed explanation-3: -To view all the records from two tables with identical structure, you use a union query.
Detailed explanation-4: -Answer: a. Query: This is data resulting from questions you ask of one or more tables. Example: Include a list of the female students in Mr.
Detailed explanation-5: -They are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries.