1. The following term applies to a collection ofrelated records in a database
A. File
B. Layout
C. File
D. Field
Answer
A. File
2. This set of related data items is known as a
A. File
B. Record
C. Table
D. None of the above
Answer
B. Record
3. The framework for storing records in database is a
A. Form
B. Report
C. Query
D. Table
Answer
C. Query
4. The following command is used to search the record that satisfies the specified criteria
A. FOUND
B. SEARCH
C. GET
D. LOCATE
Answer
A. FOUND
5. The data in a record is of the following types
A. four text fields and three numeric fields
B. two integer fields and five text fields
C. three text fields and four numeric fields
D. none of the above
Answer
B. two integer fields and five text fields
6. A treelike structure of records in a database.Select the best fit for answer
A. Hierarchical database structure
B. Relational database structure
C. Multidimensional database structure
D. Sequential database access
Answer
A. Hierarchical database structure
7. The following language used by most of the DBMSs for helping their users to access data
A. High level language
B. Query language
C. SQL
D. 4GL
Answer
A. High level language
8. What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.
A. Information Processing
B. Spreadsheet
C. Operating system
D. Database
Answer
D. Database
9. Which command is used to replace ?
A. REPLACE
B. REPLACE ALL
C. Add record from edit menu
D. All of above
Answer
C. Add record from edit menu
10. The following part of a database that holds only one type of information
A. Report
B. Query
C. Record
D. Field
Answer
D. Field
11. All of the following terms are related to computerized databases except which one?
A. Search
B. Sort
C. Field names
D. Record grab
Answer
A. Search
12. Need to see all the information from two tables on one form. Insert
A. A page break
B. A subform
C. A linked command button
D. None of the above
Answer
B. A subform
13. What is the primary difference between a pivot table report and a cross tab query?
A. A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
B. You can’t pivot a cross tab query
C. A cross tab query lets you group similar items. A pitot table report does not
D. None of above
Answer
B. You can’t pivot a cross tab query
14. The largest unit of a database is
A. A record
B. A field
C. A subfield
D. None of above
Answer
B. A field
15. What’s the best Access object for an invoice you’ll mail to customers?
A. A report
B. A form
C. A table
D. All of the above
Answer
A. A report
16. What is a Grouped Report?
A. A type of report that can be generated by the Report Wizard
B. A report that displays data that has been sorted in ascending or descending order
C. A report that displays data grouped by fields you specify
D. None
Answer
C. A report that displays data grouped by fields you specify
17. Which field allow to select items from drop down list?
A. An OLE field
B. A Memo Field
C. A lookup Field
D. A hyperlink field
Answer
C. A lookup Field
18. What did the first Table Analyzer do?
A. Analyze the data in a set of flat files and automatically create a relational database system from that information
B. Provide a graphic way to design relational databases
C. Automate process of connecting tables to SQL Server
D. None
Answer
A. Analyze the data in a set of flat files and automatically create a relational database system from that information
19. Pivot Table reports are good for
A. Analyzing large amounts of data
B. Turning tables upside down
C. Breaking spreadsheet data into multiple worksheet
D. None of above
Answer
A. Analyzing large amounts of data
20. 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
Answer
C. A and B
21. The purpose of the Add-in Manager is to
A. Create macros and automate data processing
B. Add or remove data in an existing database
C. Add or remove templates, macros, and wizards
D. All of above
Answer
C. Add or remove templates, macros, and wizards
22. Sub-schema can be used to
A. Create very different, personalized views of the same data
B. Present information in different formats
C. Hide sensitive information by omitting fields from the subschema’s description
D. All of the above
Answer
D. All of the above
23. If you are entering data in a form, a quick way to cpy a value from the previous record is to press
A. Ctrl+’
B. F6
C. Ctrl+D
D. None of the above
Answer
A. Ctrl+’
24. DBMS is
A. Collection of data
B. Set of programs to access those data
C. Set of programs to update those data
D. All of the above
Answer
D. All of the above
25. COPY STRUCTURE command is used to
A. Copy contents of an active database to a new file
B. Copy all records of an active database to disk
C. Copy contents of an active database to disk
D. Copy structure of an active database to a new file
Answer
D. Copy structure of an active database to a new file
26. COUNT command is used to
A. Count the number of data fields in an active database file
B. Count the number of data files which are active
C. Count the records which are updated
D. Count the number of records in an active database file
Answer
D. Count the number of records in an active database file
27. What is the term to ask the computer to pt information in order numerically or alphabetically ?
A. Crop
B. Report
C. Sort
D. Organize
Answer
C. Sort
28. The raw facts are called
A. Data
B. Programs
C. Commands
D. Responses
Answer
A. Data
29. The term refers to a collection of related information
A. Database
B. List
C. Outline
D. Record
Answer
C. Outline
30. A form that is used to collect data in a structured manner for entry to a database is called a
A. Database deign form
B. Systems flowchart
C. Data capture form
D. None of above
Answer
C. Data capture form
31. The following command is used for inserting records
A. INSERT
B. ADD
C. Both of the above
D. None of the above
Answer
A. INSERT
32. The Query is a statement requesting for
A. Insertion of information
B. Deletion of information
C. Update of information
D. Retrieval of information
Answer
D. Retrieval of information
33. The activity of a file
A. Is a low percentages of number of records added or deleted from a file
B. If high, reduces processing efficiency for sequential and non sequential files
C. Is a measure of the percentage of existing records updated during a run
D. Refers to how closely the files fit into the allocated
Answer
A. Is a low percentages of number of records added or deleted from a file
34. The following statement is not valid about indexing
A. it stores the index fields
B. it stores the corresponding record number
C. it maintains the alphabetically order
D. it duplicate the database file
Answer
D. it duplicate the database file
35. The following devices can be used to input data into a database
A. Keyboard, fax roller ball
B. Mouse, keyboard, monitor
C. Mouse, keyboard, touch screen
D. None of the above
Answer
C. Mouse, keyboard, touch screen
36. The following command is used for sorting
A. list
B. browse
C. index
D. sort
Answer
C. index
37. List command is used to get
A. List of database contents
B. List of database contents
C. List of variables used in database file
D. None of the above
Answer
A. List of database contents
38. A field that uniquely identifies a record is called a
A. Main field
B. Header
C. Key field
D. None of above
Answer
C. Key field
39. Corrupted index file is corrected using
A. Modifyindex
B. Recreateindex
C. Reindex
D. None of the above
Answer
C. Reindex
40. The navigation buttons enable you to
A. move from record to record in a table or form
B. move from page to page in report
C. (A) and (B) both
D. None of the above
Answer
C. (A) and (B) both
