MS-Access MCQ - Set 05 - ObjectiveBooks
MS-Access MCQ - Set 05

MS-Access MCQ - Set 05

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
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: