Braindumps of ICDL-Access
Submitting some questions, specially for you. These
will help u a lot.
QUESTION NO: 1
Which two of these statements about referential integrity
A. If a record in a parent table has a related child
record referential integrity prevents you from deleting
the parent record
B. In Access, referential integrity is enforced by typing
in a rule.
C. You can set rules about referential integrity in
a one table database.
D. Referential integrity ensures that records in linked
tables are automatically updated when changes are made.
E. A child record cannot be entered unless it has a
parent in the database if referential integrity is used
QUESTION NO: 2
Which one of the following is not a database?
A. A telephone directory
B. A sales catalogue.
C. A newsletter.
D. A price list
QUESTION NO: 3
Which two of these statements about relational databases
A. A non-relational database can be searched more efficiently
than arelatonal database.
B. A relational database is easier to maintain than
a non relational one
C. In relational databases the need for data duplication
D. Smaller linked tables are harder to manage than one
E. A relational database is one that contains linked
QUESTION NO: 4
Which two of the following statements about indexes
A. An index is used to list all the fields in a database.
B. You can index any field no matter what its data type
C. You should index a field that is frequently sorted.
D. If an index is used it slows down database searches.
E. Indexing is especially useful when working with large
QUESTION NO: 5
Which data type is most appropriate for a postal code
field such as M54WT?