CS 6515 ADVANCED UPDATED ACTUAL EXAM QUESTIONS CORRECT ANSWERS GRADED A
PLUS
Question:
(mod 9) Which data type would be best suited to a field that lists customer email addresses? A.
Hyperlink B. Date/Time C. Number D. AutoNumber.
Answer:
A. Hyperlink
Question:
(mod 9) What are the different views to display a table? A. All of the above B. Datasheet View C.
Pivot Table & Pivot Chart View D. Design View.
Answer:
A. All of the above
Question:
(mod 9) All the pet names in a veterinarian's database are stored in a _______ called PetName. A.
table B. worksheet C. field D. record.
Answer:
C. field
Question:
(mod 9) A relationship is created between how many tables? A. Two B. Three C. Any number D.
One.
Answer:
A. Two
,Question:
(mod 9) A database is an organized collection of information (T/F).
Answer:
True
Question:
(mod 9) What is a query? A. A question you ask a field B. A question you ask a table C. A question
you ask a record D. A question you ask a database.
Answer:
D. A question you ask a database
Question:
(mod 9) Contact information for all the people taking a class at a school are stored in a ________
called Students. A. worksheet B. record C. table D. field.
Answer:
C. table
Question:
(mod 9) Dana is creating a table that will show books for sale on a bookstore's website. Which field
in the table would best serve as its primary key? A. ProductID B. Title C. PageCount D. Author.
Answer:
A. ProductID
Question:
(mod 9) In a database, each _________________ contains a collection of related data. A. Table B.
Field C. Record D. None of the above.
Answer:
, A. Table
Question:
(mod 9) Which of the following is LEAST likely to be a field in a Customers table? A. LastName B.
EmploymentDate C. PhoneNumber D. Address.
Answer:
B. EmploymentDate
Question:
(mod 9) Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort
order on the birthdate field will give him this result? A. Smallest to largest B. Z to A C. Largest to
smallest D. A to Z.
Answer:
C. Largest to smallest
Question:
(mod 9) In a record, each separate piece of data, such as a last name, a first name, or an address, is
called a _____________. A. Table B. Field C. Record D. File.
Answer:
B. Field
Question:
(mod 9) A field's data type determines what kind of information can be stored there (T/F).
Answer:
True
Question:
(mod 9) A computerized database can store millions of telephone numbers (T/F).
PLUS
Question:
(mod 9) Which data type would be best suited to a field that lists customer email addresses? A.
Hyperlink B. Date/Time C. Number D. AutoNumber.
Answer:
A. Hyperlink
Question:
(mod 9) What are the different views to display a table? A. All of the above B. Datasheet View C.
Pivot Table & Pivot Chart View D. Design View.
Answer:
A. All of the above
Question:
(mod 9) All the pet names in a veterinarian's database are stored in a _______ called PetName. A.
table B. worksheet C. field D. record.
Answer:
C. field
Question:
(mod 9) A relationship is created between how many tables? A. Two B. Three C. Any number D.
One.
Answer:
A. Two
,Question:
(mod 9) A database is an organized collection of information (T/F).
Answer:
True
Question:
(mod 9) What is a query? A. A question you ask a field B. A question you ask a table C. A question
you ask a record D. A question you ask a database.
Answer:
D. A question you ask a database
Question:
(mod 9) Contact information for all the people taking a class at a school are stored in a ________
called Students. A. worksheet B. record C. table D. field.
Answer:
C. table
Question:
(mod 9) Dana is creating a table that will show books for sale on a bookstore's website. Which field
in the table would best serve as its primary key? A. ProductID B. Title C. PageCount D. Author.
Answer:
A. ProductID
Question:
(mod 9) In a database, each _________________ contains a collection of related data. A. Table B.
Field C. Record D. None of the above.
Answer:
, A. Table
Question:
(mod 9) Which of the following is LEAST likely to be a field in a Customers table? A. LastName B.
EmploymentDate C. PhoneNumber D. Address.
Answer:
B. EmploymentDate
Question:
(mod 9) Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort
order on the birthdate field will give him this result? A. Smallest to largest B. Z to A C. Largest to
smallest D. A to Z.
Answer:
C. Largest to smallest
Question:
(mod 9) In a record, each separate piece of data, such as a last name, a first name, or an address, is
called a _____________. A. Table B. Field C. Record D. File.
Answer:
B. Field
Question:
(mod 9) A field's data type determines what kind of information can be stored there (T/F).
Answer:
True
Question:
(mod 9) A computerized database can store millions of telephone numbers (T/F).
