data base management system (DBMS) set 4 Detailed Explanation And More Example

Question : 1

A good query system

a) Can accept English language commands

b) Allows non-programmers to access information stored in a database

c) Can be accessed only by data prssing professionals

d) Both (A) and (B)

Question : 2

A repository for data, usually covering specific topic is

a) Database

b) Data requisition

c) Data bank

d) Data collection

Question : 3

What data type should you choose for a zip code field in a table?

a) Text

b) Number

c) Memo

d) All of above

Question : 4

In access, the best types of queries to use for data analysis are:

a) Select queries

b) Parameter queries

c) Action queries

d) All of the above

Question : 5

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

a) Datasheet view

b) Design view

c) Print preview

d) Layout preview

Question : 6

How do you filter by selection?

a) Right click the field value and select filter by selection from the shortcut menu

b) Find and double click the value on which you want to base the filter

c) Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

d) None of the above