Practice Test: Question Set - 12
1. A relationship is created between how many tables?
- (A) One
- (B) Two
- (C) Three
- (D) Any number
2. The Input Mask wizard does NOT include the ability to do which of the following?
- (A) Force all
uppercase
- (B) Define
placeholder
- (C) Store
symbols with data
- (D) Use preset
masks
3. Which of the following data types automatically generates a consecutive number?
- (A) Autonumber
- (B) Memo
- (C) Number
- (D) Text
4. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
- (A) Match Case
- (B) Match: Whole
Field
- (C) Match: Start
of Field
- (D) Match: Any
Part of Field
5. What happens when a user selects a record in a form and presses [Delete]?
- (A) The record
is deleted in the form and from its source table
- (B) The record
is deleted in the form, but not from its source table
- (C) The record
is neither deleted in the form, nor from its source table
- (D) The record
is not deleted in the form, but is deleted from its source table
6. The most popular commercial DBMS.
- (A) Microsoft
SQL Server
- (B) Microsoft
Access
- (C) MySQL
- (D) Oracle
7. What are the different views to display a table?
- (A) Datasheet
view
- (B) Design view
- (C) Pivote table
& pivot chart view
- (D) All of above
8. Dcl provides commands to perform actions like
- (A) Change the
structure of tables
- (B) Insert,
update or delete records and data values
- (C) Authorizing
access and other control over database
- (D) None of
above
9. Which of the following database object produces the final result to present?
- (A) Forms
- (B) Reports
- (C) Queries
- (D) Tables
10. Queries in access can be used as
- (A) View, change
and analyze data in different ways
- (B) A source of
records for forms and reports
- (C) Only 'a'
- (D) Both ‘a’ and
‘b’
11. Cascade delete option
- (A) Is used to
delete all the records of all tables in a database
- (B) Will repeat
the recent delete operation to all the records of current table
- (C) Is available
in edit relationship dialog box which makes sure that all the related records
will be deleted automatically when the record parent table is deleted
- (D) None of
above
12. Both conditions display on the same row in the design grid when ________operator is in use
- (A) Or
- (B) In
- (C) And
- (D) Like
13. The expression builder is an access tool that controls an expression________ for entering an expression
- (A) Table
- (B) Box
- (C) Cell
- (D) Palette
14. The ‘filter by selection’ allows you to filter those records
- (A) That match
the selected field
- (B) That match
the criteria specified
- (C) That meet
any of several criteria specified
- (D) All of above
15. Which of the following database object can be used if you need to mail the invoice to customers?
- (A) A form
- (B) A query
- (C) A report
- (D) A table
Next Tests: