ITE EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADED A+ LATEST EXAM
1. Mindy needs to run a SQL query that will pull the FROM Students
names and birthdates of all her students. What should
the FROM phrase say in her query?
2. Dana is creating a table that will show books for sale on 4. ProductID
a bookstore's website. Which field in the table would
best serve as its primary key?
1. Author
2. PageCount
3. Title
4. ProductID
3. Darcie has hired a programmer to make some custom Open Source
changes to a DBMS she plans to move her business
database to. What kind of DBMS is she using?
4. Melody is building a database for a restaurant. Which 2. Customers, Ingredients
pair of tables is least likely to need a direct relationship
with each other?
1. Customers, Orders
2. Customers, Ingredients
3. Products, Orders
4. Products, Ingredients
5. What characteristic of Big Data indicates how closely veracity
that data matches reality?
6. What programming language supports relational SQL
databases?
7. Which data type would be best suited to a field that 4. Hyperlink
lists customer email addresses?
1/8
, ITE EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADED A+ LATEST EXAM
1. AutoNumber
2. Date/Time
3. Number
4. Hyperlink
8. Morgan needs to hire someone to help implement a Data Analyst
business intelligence system for her company. What
type of professional would be the best fit for this job?
9. Which data repository type is most likely to include data warehouse
database tables and primary keys in its internal data
structure?
10. Casey is looking for a free, open-source RDBMS for 2. PostgreSQL
his company. Which of the following best meets these
requirements?
1. Microsoft SQL Server
2. PostgreSQL
3. MongoDB
4. Oracle Database
11. Contact information for all the people taking a class at table
a school are stored in a called Students.
12. Which of the following would most likely be the key 4. Country
paired with a value of "Canada" in a nonrelational cus-
tomer database?
1. Name
2. Product
3. Affiliation
4. Country
2/8
ALREADY GRADED A+ LATEST EXAM
1. Mindy needs to run a SQL query that will pull the FROM Students
names and birthdates of all her students. What should
the FROM phrase say in her query?
2. Dana is creating a table that will show books for sale on 4. ProductID
a bookstore's website. Which field in the table would
best serve as its primary key?
1. Author
2. PageCount
3. Title
4. ProductID
3. Darcie has hired a programmer to make some custom Open Source
changes to a DBMS she plans to move her business
database to. What kind of DBMS is she using?
4. Melody is building a database for a restaurant. Which 2. Customers, Ingredients
pair of tables is least likely to need a direct relationship
with each other?
1. Customers, Orders
2. Customers, Ingredients
3. Products, Orders
4. Products, Ingredients
5. What characteristic of Big Data indicates how closely veracity
that data matches reality?
6. What programming language supports relational SQL
databases?
7. Which data type would be best suited to a field that 4. Hyperlink
lists customer email addresses?
1/8
, ITE EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADED A+ LATEST EXAM
1. AutoNumber
2. Date/Time
3. Number
4. Hyperlink
8. Morgan needs to hire someone to help implement a Data Analyst
business intelligence system for her company. What
type of professional would be the best fit for this job?
9. Which data repository type is most likely to include data warehouse
database tables and primary keys in its internal data
structure?
10. Casey is looking for a free, open-source RDBMS for 2. PostgreSQL
his company. Which of the following best meets these
requirements?
1. Microsoft SQL Server
2. PostgreSQL
3. MongoDB
4. Oracle Database
11. Contact information for all the people taking a class at table
a school are stored in a called Students.
12. Which of the following would most likely be the key 4. Country
paired with a value of "Canada" in a nonrelational cus-
tomer database?
1. Name
2. Product
3. Affiliation
4. Country
2/8
