Question 1

The complete picture of data stored in database is known as

Accepted Answer

A)  Record
B)  Scheme
C)  System flowchart
D)  DBMS B

Question 2

Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

Accepted Answer

A)  Relational
B)  Structural
C)  Network
D)  All of the above B

Question 3

Pivot Table report data must meet which of the following criteria?

Accepted Answer

A)  It must be in tabular form, have unique column labels, and each row must represent a unique piece of data
B)  Any dates should be formatted with the data format and blank rows or columns should be removed
C)  It must be in tabular form, have unique column lagels, and all rows must be sorted
D)  Both (
A)   and (
B)   D

Question 4

A command that lets you cange one or more fields in a record is

Accepted Answer

A)  Insert
B)  Modify
C)  Look up
D)  All of the above

Question 5

What is the purpose of the page field on a pivot table report?

Accepted Answer

A)  It creates a new page for each type of data
B)  It allows the data within the the Pivot Table report to be filtered
C)  It displays a title for the Pivot Table report
D)  None of the above

Question 6

How do you filter by selection?

Accepted Answer

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

Question 7

What does the Special Effect button on the formatting toolbar do?

Accepted Answer

A)  It lets you add animation to your forms and reports to make them more entertaining and amusing
B)  It lets you select a transitional effect for how a form opens and closes.
C)  It applies a 30d effect to a selected control
D)  None of these

Question 8

Customers, Orders. What's their best relationship?

Accepted Answer

A)  Many-to-many
B)  One-to-one
C)  One-to-many
D)  All of the above

Question 9

What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library's available objects and members?

Accepted Answer

A)  Object Viewer
B)  Object Browser
C)  Type Library Spy
D)  None of above

Question 10

Data items groped together for storage purposes are called a

Accepted Answer

A)  Record
B)  Title
C)  List
D)  string

Question 11

Which program do you use to edit code for data access pages?

Accepted Answer

A)  Microsoft script editor
B)  Microsoft code editor
C)  Microsoft data access pages editor
D)  None of above

Question 12

A top to bottom relationship among the items in a database is established by a

Accepted Answer

A)  Hierarchical schema
B)  Network Schema
C)  Relational schema
D)  All of the above

Question 13

Which of the following is NOT a type of Microsoft Access database object?

Accepted Answer

A)  Queries
B)  Workbooks
C)  Forms
D)  Tables

Question 14

Which of the following is not a data type ?

Accepted Answer

A)  Picture/graphic
B)  Data/time
C)  Texst
D)  Number

Question 15

A subset of characters within a data field is known as

Accepted Answer

A)  Record
B)  File
C)  Data string
D)  Byte

Question 16

Which control does access use to link data access page components to access data?

Accepted Answer

A)  Microsoft Dynamic Data Control
B)  Microsoft Data Connection Control
C)  Microsoft Office Data Source Control
D)  None of the above

Question 17

What is the corresponding text for the <#1/1/ 95# validation rule setting?

Accepted Answer

A)  Neter a value less or more than 1,195
B)  Value must be less than 95 characters
C)  Enter a date before 1995
D)  All of above

Question 18

A file containing relatively permanent data is

Accepted Answer

A)  Random file
B)  Transaction file
C)  Master file
D)  Sequential file

Question 19

The executive responsible for the data processing function in an organization is

Accepted Answer

A)  PM
B)  DBMS
C)  DP
D)  DPM

Question 20

In a relational schema, each tuple is divided into fields called

Accepted Answer

A)  Relations
B)  Domains
C)  Queries
D)  All of the above

Exam 6: Database Management System DBMS