data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 21

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

a) Collaborative Data Objects

b) ActiveX Data Objects

c) Dynamic Data Interfaces

d) None of the above

Question : 22

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

Question : 23

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 : 24

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 : 25

Auto reports can contain each of the following elements except

a) A detail section

b) A page footer

c) A group header

d) All of the above