DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
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: -SELECT statements An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.
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.