Practice Test: Question Set - 05
1. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
- (A) Datasheet
- (B) Tabular
- (C) Justified
- (D) Columnar
2. In a database table, the category of information is called _________
- (A) Tuple
- (B) Field
- (C) Record
- (D) All of above
3. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
- (A) Home Tab
- (B) Create Tab
- (C) External
Data Tab
- (D) Database Tab
4. The size of Yes No field is always
- (A) 1 bit
- (B) 1 byte
- (C) 1 character
- (D) 1 GB
5. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
- (A) Input mask
- (B) Validation
Rule
- (C) Indexed
- (D) IME Mode
6. Which field type will you select when creating a new table if you require to enter long text in that field?
- (A) Text
- (B) Memo
- (C) Currency
- (D) Hyperlink
7. This option allows you to build a new table by entering data directly into the datasheet.
- (A) Datasheet
view
- (B) Design view
- (C) Link table
- (D) None of the
above
8. Which is not a view to display a table in Access?
- (A) Datasheet
View
- (B) Design View
- (C) Pivot Table
& Pivot Chart View
- (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. Referential integrity means
- (A) Do not enter
a value in the foreign key field of a child table if that value does not exist
in the primary key of the parent table
- (B) Do not enter
a value in the primary key field of child table if that value does not exist in
the primary key of the parent table
- (C) Do not enter
a value in the foreign key field of a parent table if that value does not exist
in the primary key of the child table
- (D) All of above
11. It is a database object to view, change, and analyze data in different ways
- (A) Query
- (B) Form
- (C) Report
- (D) None of the
above
12. You can automatically include all of the field in a table in a query by_________ a strike that appear list box in query design view
- (A) Clicking
- (B) Right
clicking
- (C) Double
clicking
- (D) None of the
above
13. Which field type can store photos?
- (A) Hyperlink
- (B) OLE
- (C) Both of
these can be used
- (D) Access
tables can’t store photos
14. 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
15. Which of the following statement is true?
- (A) Foreign key
fields don’t allow duplicate values
- (B) In primary
key field you can enter duplicate value
- (C) In
an indexed field you may or may not enter duplicate value depending upon
setting
- (D) All
statements are true
Next Tests:
Blogger Comment
Facebook Comment