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
Next Tests: