Deck 3: Database Management System

Question 1

Modules are

A)selection of commands used to automate repetitive tasks
B)programs written in Visual C++
C)Object tabs
D)Group of records

Answer 1

selection of commands used to automate repetitive tasks

Question 2

APPEND command is used to

A)Add record to the end of active database file and starts full screen data entry
B)Add Record to the start of active database file
C)Add record to the start of active database file and starts full screen data entry
D)Add record to the end of database file

Answer 2

Add record to the end of active database file and starts full screen data entry

Question 3

Append from command is used to

A)Add records from information in an array
B)Adds records from a file
C)Add records from a variable
D)Add records from stock

Answer 3

Add records from information in an array

Question 4

Examples of centralized multi-user databases are

A)Barclays' Bank customer accounts
B)Supermarket stock control, organ donor database, client database
C)Airline reservations and other national global booking systems
D)None of above

Question 5

New record is added using

A)Append record from browse menu
B)Append record into from browse menu
C)Add record from edit menu
D)All of above

Question 6

When a customer makes an online hotel booking, the database is updated in

A)Batch mode
B)Pseudo real-time
C)One month
D)All of above

Question 7

A database that contains tables linked by common fields is called a

A)Centralized database
B)Flat file database
C)Relational database
D)None of above

Question 8

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

A)Database management approach
B)DBMS uses
C)Database administrator
D)Query language

Question 9

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

A)Database management approach
B)DBBMS uses
C)Database administrator
D)Query language

Question 10

A specialist in charge of the database of an organization select the best fit for answer

A)Database management approach
B)DBMS uses
C)Database administrator
D)Query language

Question 11

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 12

The ….. presents data in a way similar to an excel spreadsheet

A)Datasheet view
B)Design view
C)Print preview
D)Layout preview

Question 13

It Is used to build and modify database objects and also to create new queries

A)Datasheet view
B)Design view
C)Print preview
D)Layout preview

Question 14

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

A)Datasheet view
B)Design view
C)Print preview
D)Layout preview

Question 15

It examines a small portion or sample of your data in a report before printing it.

A)Datasheet view
B)Design view
C)Print preview
D)Layout preview

Question 16

A report form

A)Appears on the computer monitor during data entry
B)Is used during report generation to format data
C)Both (A) and (B)
D)All of above

Question 17

Which of the following columns can not be found in the macro design window?

A)Arguments column
B)Comment column
C)Conditions column
D)Actions column

Question 18

A good query system

A)Can accept English language commands
B)Allows non-programmers to access information stored in a database
C)Can be accessed only by data prssing professionals
D)Both (A) and (B)

Question 19

How do you freeze a field a column or field in Microsoft Access?

A)Click anywhere in the column and select Edit>Freeze Column form the menu
B)Place an ice cube in the column
C)Click anywhere in the column and click the freeze button on the toolbar
D)Right click the column and select freeze columns from the shortcut menu

Question 20

Within Table Datasheet view, how can you display associated records from another table?

A)Click the expand indicator (+) next to a record
B)Double click the record.
C)Apply the filter by form command
D)None of the above

Question 21

Which of the following is not a command to find specific word or phrases in a database?

A)Click the find button on the toolbar
B)Click the find button on the record navigation button area
C)Press Ctrl+F
D)Select Edit>Find from the menu.

Question 22

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 23

The data in a Pivot Table report is categorized using

A)Column headings
B)Items from the Pivot Table field list
C)Header rows
D)All of above

Question 24

Records are deleted using

A)DELETE command followed by pack
B)DELETE command without pack
C)DELETE command followed by zap
D)DELETE command without zap