Practice Test: Question Set - 04
1. _________ are documents that when filled in create records.
- (A) Forms
- (B) Reports
- (C) Tables
- (D) Queries
2. To print information from a table, the _________ tool is the best choice.
- (A) Form
- (B) Report
- (C) Query
- (D) Macro
3. Which of the following creates a drop down list of values to choose from?
- (A) Ole object
- (B) Hyperlink
- (C) Memo
- (D) Lookup
wizard
4. Following is not a database model
- (A) Network
database model
- (B) Relational
database model
- (C) Object
oriented database model
- (D) None
5. Which of the following is not a database object?
- (A) Tables
- (B) Queries
- (C) Relationships
- (D) Reports
6. What is the difference between ‘open’ and ‘open exclusively’
- (A) Open
statement opens access database files and open exclusively opens database files
of other program like oracle
- (B) Open
exclusive locks whole database so that no one can access it whereas open locks
only the record that is being accessed
- (C) Both open and
open exclusively are same
- (D) Open
exclusive command does not exist in MS Access
7. Which field type can store photos?
- (A) Hyperlink
- (B) Ole
- (C) Both of
these can be used
- (D) Access
tables can’t store photos
8. To create queries in access
- (A) You can drag
and drop fields on query builders
- (B) You can type
the sql command in sql view
- (C) You can use
query wizard or design view
- (D) All of above
9. What do you mean by one-to-many relationship between student and class table?
- (A) One student
can have many classes
- (B) One class
may have many students
- (C) Many classes
may have many students
- (D) Many
students may have many classes
10. To achieve and effect when you are entering criteria in a query design window
- (A) Write
criteria values vertically one in a row
- (B) Write
criteria values horizontally
- (C) Write
criteria values in same field separated with and
- (D) None of
these
11. You can set a controls border type to make the border invisible.
- (A) Transparent
- (B) Invisible
- (C) Do not
display
- (D) No border
12. It is most common type of query. It retrieves records from one or more tables and then displays the
- (A) Parameter
- (B) Select
- (C) Crosstab
- (D) All of above
13. The operation of checking input data against specified criteria is known as?
- (A) Data
verification
- (B) Data
validation
- (C) Cross check
- (D) Data control
14. The ascending order of data hierarchy is?
- (A) Bit – byte –
field – record – file – database
- (B) Bit – byte –
record – field – file – database
- (C) Byte – bit –
field – record – file – database
- (D) Bit – byte –
field – record – database – file
15. In the form wizard dialog box, the fields from the selected table are displayed in this list box.
- (A) All fields
- (B) All records
- (C) Available
records
- (D) Available
fields
Next Tests: