81. A large collections of files are called
A. Fields
B. Records
C. Databases
D. File system
Answer
B. Records
82. Memo field in database file is used to
A. Store lengthy number
B. Store images
C. Store audio files
D. Store long textual information
Answer
D. Store long textual information
83. Applications that rely on databases are
A. Supermarket stock control, theater bookings and payroll
B. Accounts, online banking, PowerPoint presentations
C. Internet shopping, robotics, computer games
D. None of above
Answer
A. Supermarket stock control, theater bookings and payroll
84. Which of the following is not a Access database object ?
A. table
B. form
C. query
D. datasheet
Answer
D. datasheet
85. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
A. Take regular backups
B. Keep a hardcopy printout of all data
C. Keep fingers crossed at all times
D. None of above
Answer
A. Take regular backups
86. Facilities offered by databases are
A. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
B. Easy editing, spell check, perform calculations, library of mathematical functions, replication
C. The ability to rotate images, copy and paste, fill scale
D. None of above
Answer
A. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
87. Users who store data about real people for marketing purposes must register the data and its potential use with
A. The computer misuse controller
B. The data protection controller
C. HM customs and excise
D. None of above
Answer
B. The data protection controller
88. When you double click a query object, you open
A. The object in design view
B. The object in print preview
C. The result of the query
D. The underlying table on which the query is based
Answer
B. The object in print preview
89. Checks that are added to databases to detect unsuitable data on inpt are called
A. validation
B. verification
C. vegetation
D. none of above
Answer
A. validation
90. Auto Report allows you to
A. View a subset of your data
B. Create a simple report
C. Create a data entry form
D. Enter records
Answer
B. Create a simple report
91. Auto Form allows you to
A. View a subset of your data
B. Create a simple report
C. Create a data entry form
D. Enter records
Answer
B. Create a simple report
92. 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
Answer
A. Wildcard
93. When performing a look-up operation using a form
A. You enter the search value into the form
B. You look at each form sequentially until you see the one you want
C. You type the key in an entry line, and the correct form is displayed
D. All of the above
Answer
D. All of the above
94. Which custom date format displays the numeric day of the year when a date is entered?
A. YY
B. YYYY
C. Y
D. All of above
Answer
C. Y
95. When you save an Access project, what fileformat do you use?
A. adp
B. xm.
C. mdb
D. All of above
Answer
A. adp
96. Which of the following criterion would find records whose personality field does not equal “Nice”?
A. <>Nice
B. NOT Nice
C. <>”Nice”
D. IS NOT Nice
Answer
C. <>“Nice”
97. What is the maximum character field size you can set for a field that has a text data type?
A. 64
B. 255
C. 512
D. All of above
Answer
B. 255
98. Which of the following fields would not make a suitable primary key ?
A. A date field
B. An invoice number
C. An autoNumber field
D. A customer’s social security number
Answer
A. A date field
99. 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
Answer
D. All of the above
100. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?
A. DASD
B. FMS
C. EMMS
D. DBMS
Answer
D. DBMS
101. A repository for data, usually covering some specific topic is called
A. Data acquisition
B. Data bank
C. Real time
D. Database
Answer
B. Data bank
102. A notation for defining the form and structure of data is known as
A. Data description language
B. Binary language
C. Data channels
D. Data definition language
Answer
D. Data definition language
103. A data item, which is not broken down into smaller units, is
A. Data element
B. Elementary data item
C. Data entry
D. Database management
Answer
B. Elementary data item
104. Which of the following terms refers to the degree to which data in database system are accurate and correct?
A. Data security
B. Data validaity
C. Data independence
D. Data integrity
Answer
D. Data integrity
105. A repository for data, usually covering specific topic is
A. Database
B. Data requisition
C. Data bank
D. Data collection
Answer
C. Data bank
106. A set of programs that handle firm’s database responsibilities is called a
A. Database Management System (DBMS)
B. Database Processing System (DBPS)
C. Data Management System (DMS)
D. All of above
Answer
D. All of above
107. Which of the following is not a relational database?
A. dBase IV
B. 4th Dimension
C. FoxPro
D. Reflex
Answer
D. Reflex
108. Which is used to provide the sight information to the right person at the right time for proper decision making ?
A. DBMS
B. MIS
C. ISO
D. PSO
Answer
B. MIS
109. Dbase-III was developed by
A. Dec
B. IBM
C. Ashton-tate
D. All of the above
Answer
C. Ashton-tate
110. 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
Answer
C. Queries
111. What data type should you choose for a zip code field in a table?
A. Text
B. Number
C. Memo
D. All of above
Answer
A. Text
112. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A. The pin code
B. The last name
C. A compound key consisting of the first name and the last name
D. All of the above
Answer
C. A compound key consisting of the first name and the last name
113. What happens when you add the asterisk (() from any field list ot a query?
A. The table will not include any fields from the table
B. The query sorts the table’s record in the order you specify
C. The query will include every field from the table*
D. The query uses the records from the table without displaying them
Answer
C. The query will include every field from the table*
114. The modify operation is likely to be done after
A. delete
B. look up
C. insert
D. all of above
Answer
B. look up
115. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper
A. Display records between the dates 1/2/ 99 and 1/1/00
B. Display records between the dates 1/1/ 99 and 12/31/99
C. Display records whose dates equaled 1/1/99 or 12/31/99
D. All of the above
Answer
B. Display records between the dates 1/1/ 99 and 12/31/99
116. DDP stands for
A. Distributed Double Processing
B. Double Decimal Processing
C. Distributed Data Programming
D. Distributed Data Processing
Answer
D. Distributed Data Processing
117. To see sales amount figures totaled, into which drop area would you drag that field?
A. Drop column fields here
B. Drop row fields here
C. Drop data items here
D. None of the above
Answer
C. Drop data items here
118. Which access feature do you use to develop applications that host access data on the web?
A. Dynamic web data
B. Data access pates
C. Html data pages
D. None of the above
Answer
B. Data access pates
119. What is the common name for a column of data within an Access table?
A. Field
B. Record
C. Row
D. None of the above
Answer
A. Field
120. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called
A. Field
B. Bead
C. Database
D. Data collection
Answer
B. Bead
