Computer Science MCQ on Microsoft Access - Set 19 - ObjectiveBooks

Computer Science MCQ on Microsoft Access - Set 19

Practice Test: Question Set - 19

1. If you need to edit a relationship
    (A) Right click the relationship line and choose edit relationship
    (B) Double click the relationship line
    (C) Both of above
    (D) None of above

2. Unlike text data type, this can store up to maximum of 65,535 characters.
    (A) Memo
    (B) Data/time
    (C) Number
    (D) All of above

3. What it is called to present information in a particular order based on numeric or alphabetical value?
    (A) Sorting
    (B) Searching
    (C) Arranging
    (D) Cropping

4. This form displays multiple records, one per row, in the form window
    (A) Datasheet
    (B) Tabular
    (C) Columnar
    (D) Justified

5. In the second sub-form wizard dialog box you specify the table to use as the data source and the
    (A) Records from the selected form
    (B) Form from the selected table
    (C) Fields from the selected table
    (D) Content from the selected form

6. In relational database schema each tuple is divided into fields known as?
    (A) Relations
    (B) Queries
    (C) Records
    (D) Domains

7. What is the corresponding text for the <#1/1/95# validation rule setting?
    (A) Enter a value less or more than 1,195
    (B) Value must be less than 95 characters
    (C) Enter a date before 1995
    (D) All of above

8. A subset of characters within a data field is known as
    (A) Record
    (B) File
    (C) Data string
    (D) Byte

9. How can you add a table to the relationship window?
    (A) Select tools > add table from the menu
    (B) Select the table from the table list on the toolbar
    (C) Click the show table button on the toolbar
    (D) Select edit > add table from the menu

10. In order to use dbms, it is important to understand
    (A) The physical schema
    (B) All sub schemas that the system supports
    (C) One sub schema
    (D) Both ‘a’ and ‘b’

11. What is the propose to a sub datasheet?
    (A) To provide a hierarchical view of related tables or queries in a single window
    (B) To display grouped data in a report
    (C) To display summarized data
    (D) All of the above

12. Query design window has two parts. The upper part shows
    (A) Name of fields, field type and size
    (B) Tables with fields and relationships between tables
    (C) Criteria
    (D) Sorting check boxes

13. A database language concerned with the definition of the whole database structure and schema is ________
    (A) DCL
    (B) DML
    (C) DDL
    (D) All of above

14. In table design view what are the first column of buttons used for
    (A) Indicate Primary Key
    (B) Indicate Current Row
    (C) Both of above
    (D) None of above

15. The________ button on the tool box display data from a related table
    (A) Sub form sub report
    (B) Relationships
    (C) Select objects
    (D) More controls

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: