ITE Exam 3 questions with complete
solutions graded A+
A computerized database can store millions of telephone numbers.
true or false - correct answer ✔✔true
A database is an organized collection of information.
true or false - correct answer ✔✔true
Sawyer is looking at a table of students in his class, but it seems like the list is way
too short. What is the most likely problem?
The table is missing a primary key.
The table is sorted.
The table is filtered.
The table has been deleted. - correct answer ✔✔The table is filtered.
Which of the following is LEAST likely to be a field in a Customers table?
Address
LastName
EmploymentDate
PhoneNumber - correct answer ✔✔EmploymentDate
Queries in access can be used
,as a source of records for forms and reports
to view, change and analyze data in different ways
Both 'a' and 'b'
Only 'a' - correct answer ✔✔Both 'a' and 'b'
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?
Z to A
Smallest to largest
A to Z
Largest to smallest - correct answer ✔✔Smallest to largest
Which data type would be best suited to a field that lists customer email
addresses?
Number
Date/Time
Hyperlink
AutoNumber - correct answer ✔✔Hyperlink
A field's data type determines what kind of information can be stored there.
true or false - correct answer ✔✔true
What are the different views to display a table?
Pivot Table & Pivot Chart View
, All of the above
Datasheet View
Design View - correct answer ✔✔All of the above
What does SQL stand for?
Stated question language
Structured query language
System query lingo
Status query language - correct answer ✔✔Structured query language
Malisa is designing a database for a doctor's office where receptionists, office
managers, and other office staff will need to manage patient data. Which
database object should Malisa create to make it easy for these non-technical users
to add patient records?
Queries
Forms
Reports
Tables - correct answer ✔✔Forms
Xavier is designing a Students table that will continue to track students even after
they have completed their programs. Which of the following fields would work
best with the Yes/No data type?
Major
Graduated
GPA
solutions graded A+
A computerized database can store millions of telephone numbers.
true or false - correct answer ✔✔true
A database is an organized collection of information.
true or false - correct answer ✔✔true
Sawyer is looking at a table of students in his class, but it seems like the list is way
too short. What is the most likely problem?
The table is missing a primary key.
The table is sorted.
The table is filtered.
The table has been deleted. - correct answer ✔✔The table is filtered.
Which of the following is LEAST likely to be a field in a Customers table?
Address
LastName
EmploymentDate
PhoneNumber - correct answer ✔✔EmploymentDate
Queries in access can be used
,as a source of records for forms and reports
to view, change and analyze data in different ways
Both 'a' and 'b'
Only 'a' - correct answer ✔✔Both 'a' and 'b'
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?
Z to A
Smallest to largest
A to Z
Largest to smallest - correct answer ✔✔Smallest to largest
Which data type would be best suited to a field that lists customer email
addresses?
Number
Date/Time
Hyperlink
AutoNumber - correct answer ✔✔Hyperlink
A field's data type determines what kind of information can be stored there.
true or false - correct answer ✔✔true
What are the different views to display a table?
Pivot Table & Pivot Chart View
, All of the above
Datasheet View
Design View - correct answer ✔✔All of the above
What does SQL stand for?
Stated question language
Structured query language
System query lingo
Status query language - correct answer ✔✔Structured query language
Malisa is designing a database for a doctor's office where receptionists, office
managers, and other office staff will need to manage patient data. Which
database object should Malisa create to make it easy for these non-technical users
to add patient records?
Queries
Forms
Reports
Tables - correct answer ✔✔Forms
Xavier is designing a Students table that will continue to track students even after
they have completed their programs. Which of the following fields would work
best with the Yes/No data type?
Major
Graduated
GPA
