ITE 152 Final Exam 3 Questions with 100%
Verified Correct Answers
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.
The table is filtered.
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?
-Employer
-Graduated
-GPA
-Major
Graduated
One disadvantage of computerized databases is that they limit your ability to arrange
information.
-True
-False
False
,A database is a collection of related information, but a database management system is
a type of software program.
-True
-False
True
A database is an organized collection of information.
-True
-False
True
What are the columns in a Microsoft Access table called?
-Rows
-Fields
-Records
-Columns
Fields
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?
-Inventory
-Employees
-Customers
-Vendors
Vendors
, What does SQL stand for?
-Stated question language
-Structured query language
-System query lingo
-Status query language
Structured query language
Which of the following is LEAST likely to be a field in a Customers table?
-LastName
-Address
-EmploymentDate
-PhoneNumber
EmploymentDate
A relationship is created between how many tables?
-Two
-Any number
-Three
-One
Two
What is a query?
-A question you ask a table
-A question you ask a record
-A question you ask a database
-A question you ask a field
Verified Correct Answers
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.
The table is filtered.
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?
-Employer
-Graduated
-GPA
-Major
Graduated
One disadvantage of computerized databases is that they limit your ability to arrange
information.
-True
-False
False
,A database is a collection of related information, but a database management system is
a type of software program.
-True
-False
True
A database is an organized collection of information.
-True
-False
True
What are the columns in a Microsoft Access table called?
-Rows
-Fields
-Records
-Columns
Fields
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?
-Inventory
-Employees
-Customers
-Vendors
Vendors
, What does SQL stand for?
-Stated question language
-Structured query language
-System query lingo
-Status query language
Structured query language
Which of the following is LEAST likely to be a field in a Customers table?
-LastName
-Address
-EmploymentDate
-PhoneNumber
EmploymentDate
A relationship is created between how many tables?
-Two
-Any number
-Three
-One
Two
What is a query?
-A question you ask a table
-A question you ask a record
-A question you ask a database
-A question you ask a field
