ITE 152 EXAM3 WITH 100% CORRECT QUESTIONS AND ANSWERS
In a database, each _________________ contains a collection of related
data. - ANSWER-Table
... [Show More] (?)
A database is an organized collection of information. - ANSWER-A
database is an organized collection of integrated files
True
Ibraheem works for a music store. Which of the following tables will give
him the company contact information he needs to place a custom order
for a guitar? - ANSWER-Vendors
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? - ANSWER-Graduated
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? - ANSWER-The table
is filtered.
One disadvantage of computerized databases is that they limit your ability
to arrange information. - ANSWER-False
Queries in access can be used - ANSWER-Both 'a' and 'b' (as a source of
records for forms and reports, to view, change and analyze data in
different ways)
A relationship is created between how many tables? - ANSWER-Two
What does a filter do? - ANSWER-Hide records from view
A computerized database can store millions of telephone numbers. -
ANSWER-True
Which of the following is NOT a part of a database? - ANSWER-Worksheets
Which data type would be best suited to a field that lists customer email
addresses? - ANSWER-Hyperlink
Which field could serve as the primary key for a list of students in your
school? - ANSWER-Student ID number
A field's data type determines what kind of information can be stored
there. - ANSWER-True
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? -
ANSWER-ProductID
All the pet names in a veterinarian's database are stored in a _______
called PetName. - ANSWER-Field
Which of the following is a way to sort data? - ANSWER-All of the above
(Alphabetically, Numerically, Chronologically)
What does SQL stand for? - ANSWER-Structured Query Language
What is a query? - ANSWER-A question you ask a database
What are the columns in a Microsoft Access table called? - ANSWER-Fields
In a record, each separate piece of data, such as a last name, a first
name, or an address, is called a _____________. - ANSWER-Field
Which data type would be best suited to a field that lists a product's
clearance price? - ANSWER-Currency
A query lets you speed up the browsing process by finding information
that matches specifically to your criteria. - ANSWER-True
What are the different views to display a table? - ANSWER-All of the above
(Pivot Table & Pivot Chart View, Datasheet View, Design View)
Databases typically store their data in one big table. - ANSWER-False
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? - ANSWER-Smallest to largest
A database is a collection of related information, but a database
management system is a type of software program. - ANSWER-True
Contact information for all the people taking a class at a school are
stored in a ________ called Students. - ANSWER-Table
Which of the following is LEAST likely to be a field in a Customers table? -
ANSWER-EmploymentDate
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 nontechnical users to add patient records? - ANSWER-Forms
How does discarding computers in a landfill affect the environment? -
ANSWER-Lead and mercury in computer parts are seeping into the ground
and water supply.
What is it called when an attacker convinces you to enter personal
information at an imposter website after receiving an email from a
person masquerading as an employee from your bank? - ANSWERPhishing
You can configure your wireless router to protect your devices in all of
the following ways EXCEPT ____. - ANSWER-naming your router something
you'll remember, like your street address
You can monitor and protect your financial data in all of the following
ways EXCEPT _____. - ANSWER-Storing financial information in an unsent
email message.
How will you decide which browser security settings to allow and which
ones to block? - ANSWER-I will need to review each browser security
setting and use my best judgement.
Social-networking sites have a history of providing tight security and
giving users a clear understanding of how security features work. -
ANSWER-False
_____ ensures that the person requesting access to a computer is not an
imposter. - ANSWER-Authentication
After Penny broke up with her boyfriend, he texted some teammates from
the track team about some private and intimate moments he and Penny
had shared while they were dating. He even lied about their breakup,
creating rumors about her behavior. Penny started getting inappropriate
looks and advances from the team whenever she was at practice and felt
completely humiliated. Penny is a victim of ________. - ANSWERCyberbullying
How can you protect a computer from electrical spikes and surges? -
ANSWER-Use a surge protector.
Which term refers to the science that specifies the design and
arrangement of items you use so you interact with the items efficiently
and safely? - ANSWER-Ergonomics
Which of the following forms of identity theft involves posing as a
legitimate researcher to ask for personal information? - ANSWERPretexting [Show Less]