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

Question : 1

Checks that are added to databases to detect unsuitable data on input are called

a) validation

b) verification

c) vegetation

d) none of above

Question : 2

What is the primary difference between a pivot table report and a cross tab query?

a) A pivot table report can contain sums, counts, and averages while a cross tab query cannot.

b) You can’t pivot a cross tab query

c) A cross tab query lets you group similar items. A pitot table report does not

d) None of above

Question : 3

The following statement is not valid about indexing

a) it stores the index fields

b) it stores the corresponding record number

c) it maintains the alphabetically order

d) it duplicate the database file

Question : 4

Pivot Table reports are good for

a) Analyzing large amounts of data

b) Turning tables upside down

c) Breaking spreadsheet data into multiple worksheet

d) None of above

Question : 5

Which of the following database objects asks a question of information in a database and then displays the result?

a) Tables

b) Reports

c) Queries

d) Forms

Question : 6

The asterisk (*) is sometimes used in database queries. This character is then called a

a) Wildcard

b) Dummy

c) Ditto

d) All of the above