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

Question : 1

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

In Form view, which command displays records alphabetically?

a) Find

b) Advanced Filter/Sort

c) Sort

d) All of the above

Question : 3

The largest unit of a database is

a) A record

b) A field

c) A subfield

d) None of above

Question : 4

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

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

What is the first step in creating a form or report with the form wizard or report wizard?

a) Selecting the fields that you want to appear in the form or report

b) Selecting the underlying table or query on which you want to base the form or report

c) Reading several screens of mostly useless information and clicking next

d) Selecting how the form or report should be formatted