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

Question : 21

Customers, Orders. What’s their best relationship?

a) Many-to-many

b) One-to-one

c) One-to-many

d) All of the above

Question : 22

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

a) Database management approach

b) DBMS uses

c) Database administrator

d) Query language

Question : 23

How do you update Pivot Table report data after changes are made to the source data?

a) Save your changes, close the workbook, and then reopen it.

b) Select the Pivot Table worksheet and press F9 on the keyboard

c) Click the report, and on the Pivot Table toolbar, click the refresh data button

d) All of the above

Question : 24

Which of the following are common ways to enforce data validation when entering data into an Access form?

a) Create an input mask to restrict the kind of value that can be entered in positions across the field.

b) Define a validation rule for that field

c) A and B

d) none of the above

Question : 25

In Form view, which command displays records alphabetically?

a) Find

b) Advanced Filter/Sort

c) Sort

d) All of the above