ITE 115 - Introduction to Computer Applications and Concepts » Spring 2022 » Module 13 Quiz
Need help with your exam preparation?
Get Answers to this exam for $6 USD.
Get Answers to all exams in [ ITE 115 - Introduction to Computer Applications and Concepts ] course for $25 USD.
Existing Quiz Clients Login here
Question #1
Kiera is building a front-end user interface for the database her new website will use. Which of the following languages is NOT used to build a webpage?
A.
JavaScript
B.
CSS
C.
HTML
D.
SQL
Question #2
Which of the following fields would be most important to encrypt in a customer table?
A.
Customer’s sales representative
B.
Customer’s credit card number
C.
Customer’s status
D.
Customer’s city
Question #3
Which data repository type is most likely to include database tables and primary keys in its internal data structure?
A.
Data lake
B.
Data dashboard
C.
Data warehouse
D.
Data mart
Question #4
Scarlet needs to create a file to hold a list of expenses for an upcoming project, and she needs to do some basic calculations with the numbers in the budget. Which kind of file is the best fit for this purpose?
A.
Presentation
B.
Spreadsheet
C.
Document
D.
Database
Question #5
Which of the following would most likely be the key paired with a value of “Canada” in a nonrelational customer database?
A.
Product
B.
Affiliation
C.
Country
D.
Name
Question #6
Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements?
A.
MongoDB
B.
PostgreSQL
C.
Microsoft SQL Server
D.
Oracle Database
Question #7
What kind of database is needed to hold and organize diverse data types, such as X-ray images and doctors’ notes, in a medical database?
A.
Relational database
B.
Nonrelational database
C.
Big Data database
D.
Backup database
Question #8
One of Eden’s customers has closed his account and moved to a different state. She needs to change his status to Inactive. What SQL command will accomplish this task?
A.
SELECT
B.
UPDATE
C.
INSERT
D.
DELETE
Question #9
Contact information for all the people taking a class at a school are stored in a ________ called Students.
A.
worksheet
B.
table
C.
field
D.
record
Question #10
Raphael is working with a table in Access. He needs to see all the records for customers in Chattanooga so he can check the zip codes in that city. Which database tool will show only these records in the table?
A.
Filter
B.
Query
C.
Sort
D.
Report
Question #11
What characteristic of Big Data indicates how closely that data matches reality?
A.
veracity
B.
variety
C.
velocity
D.
volume
Question #12
Morgan needs to hire someone to help implement a business intelligence system for her company. What type of professional would be the best fit for this job?
A.
Data analyst
B.
Database administrator
C.
Retailer
D.
CEO
Question #13
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.
PageCount
C.
ProductID
D.
Title
Question #14
What programming language supports relational databases?
A.
CSS
B.
NoSQL
C.
SQL
D.
HTML
Question #15
Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other?
A.
Products, Orders
B.
Customers, Orders
C.
Customers, Ingredients
D.
Products, Ingredients
Question #16
Darcie has hired a programmer to make some custom changes to a DBMS she plans to move her business database to. What kind of DBMS is she using?
A.
Open source
B.
DBaaS
C.
Relational
D.
Proprietary
Question #17
Mindy needs to run a SQL query that will pull the names and birthdates of all her students. What should the FROM phrase say in her query?
A.
FROM Students
B.
FROM Birthdate
C.
FROM Schools
D.
FROM Name
Question #18
Which of the following is a key aspect of database security according to the CIA triad security model? Choose two.
A.
Availability , Identity
B.
Authorization, Integrity
C.
Authorization, Identity
D.
Availability, Integrity
Question #19
Which data type would be best suited to a field that lists customer email addresses?
A.
AutoNumber
B.
Date/Time
C.
Number
D.
Hyperlink
Question #20
Which of the following scenarios would most likely rely on Big Data?
A.
Calculating a student’s course average, Budgeting for a home renovation
B.
Calculating traffic delays during rush hour , Budgeting for a home renovation
C.
Calculating a student’s course average, Evaluating applications for disability benefits
D.
Evaluating applications for disability benefits, Calculating traffic delays during rush hour
Need help with your exam preparation?
Get Answers to this exam for $6 USD.
Get Answers to all exams in [ ITE 115 - Introduction to Computer Applications and Concepts ] course for $25 USD.
Existing Quiz Clients Login here