ITE 152 Questions and Answers | Exam 3 Prep
Your Facebook profile is private so there is no need to worry about your boss ever seeing your
posts such as your Spring Break pictures.
True or False ** Answ** False
A query lets you speed up the browsing process by finding information that matches specifically
to your criteria.
True or False ** Answ** True
A relationship is created between how many tables?
A- Any number
B- Three
C- One
D- Two ** Answ** D- Two
One disadvantage of computerized databases is that they limit your ability to arrange
information.
True or False ** Answ** False
What does SQL stand for?
A- Status query language
B- Structured query language
C- Stated question language
D- System query lingo ** Answ** B- Structured query language
,What are the columns in a Microsoft Access table called?
A- Fields
B- Columns
C- Rows
D- Records ** Answ** A- Fields
Which data type would be best suited to a field that lists a product's clearance price?
A- Number
B- Date/Time
C- Currency
D- AutoNumber ** Answ** C- Currency
Which of the following is NOT a part of a database?
A- Tables
B- Fields
C- Worksheets
D- Records ** Answ** C- Worksheets
Which of the following is a way to sort data?
A- Chronologically
B- Alphabetically
C- All of the above
D- Numerically ** Answ** C- All of the above
What is a query?
,A- A question you ask a field
B- A question you ask a record
C- A question you ask a database
D- A question you ask a table ** Answ** C- A question you ask a database
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- File
C- Field
D- Record ** Answ** C- Field
A field's data type determines what kind of information can be stored there.
True or False ** Answ** True
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?
A- Graduated
B- Major
C- GPA
D- Employer ** Answ** A- Graduated
All the pet names in a veterinarian's database are stored in a _______ called PetName.
A- worksheet
B- record
C- field
, D- table ** Answ** C- field
Databases typically store their data in one big table.
True or False ** Answ** False
A database is a collection of related information, but a database management system is a type of
software program.
True or False ** Answ** True
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- A to Z
B- Smallest to largest
C- Largest to smallest
D- Z to A ** Answ** B- Smallest to largest
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- Author
B- ProductID
C- PageCount
D- Title ** Answ** B- ProductID
A computerized database can store millions of telephone numbers.
True or False ** Answ** True
Your Facebook profile is private so there is no need to worry about your boss ever seeing your
posts such as your Spring Break pictures.
True or False ** Answ** False
A query lets you speed up the browsing process by finding information that matches specifically
to your criteria.
True or False ** Answ** True
A relationship is created between how many tables?
A- Any number
B- Three
C- One
D- Two ** Answ** D- Two
One disadvantage of computerized databases is that they limit your ability to arrange
information.
True or False ** Answ** False
What does SQL stand for?
A- Status query language
B- Structured query language
C- Stated question language
D- System query lingo ** Answ** B- Structured query language
,What are the columns in a Microsoft Access table called?
A- Fields
B- Columns
C- Rows
D- Records ** Answ** A- Fields
Which data type would be best suited to a field that lists a product's clearance price?
A- Number
B- Date/Time
C- Currency
D- AutoNumber ** Answ** C- Currency
Which of the following is NOT a part of a database?
A- Tables
B- Fields
C- Worksheets
D- Records ** Answ** C- Worksheets
Which of the following is a way to sort data?
A- Chronologically
B- Alphabetically
C- All of the above
D- Numerically ** Answ** C- All of the above
What is a query?
,A- A question you ask a field
B- A question you ask a record
C- A question you ask a database
D- A question you ask a table ** Answ** C- A question you ask a database
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- File
C- Field
D- Record ** Answ** C- Field
A field's data type determines what kind of information can be stored there.
True or False ** Answ** True
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?
A- Graduated
B- Major
C- GPA
D- Employer ** Answ** A- Graduated
All the pet names in a veterinarian's database are stored in a _______ called PetName.
A- worksheet
B- record
C- field
, D- table ** Answ** C- field
Databases typically store their data in one big table.
True or False ** Answ** False
A database is a collection of related information, but a database management system is a type of
software program.
True or False ** Answ** True
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- A to Z
B- Smallest to largest
C- Largest to smallest
D- Z to A ** Answ** B- Smallest to largest
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- Author
B- ProductID
C- PageCount
D- Title ** Answ** B- ProductID
A computerized database can store millions of telephone numbers.
True or False ** Answ** True
