stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
UNIT 7 TEST REVIEW Flashcards | StudBud
Explore
/
UNIT 7 TEST REVIEW
UNIT 7 TEST REVIEW
30 terms
·
StudBud Administration
·
762 plays
Imported from external platform
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
Which process exports a database into a format that can be read by another program like a spreadsheet?
Database backup
CRUD
Database dump
CSV
2
Which database object is essentially questions that we can ask the database?
Tables
Reports
Forms
Queries
3
What is asking specific questions to interpret Big Data called?
Data Analytics
Data Ethics
Data Mining
Data Extraction
4
Which type of analytical data can help you make investment decisions?
Machine
Sensor
Market
Transactional
5
Flat file database
A database that stores data in a single table.
Process of checking data as it's being input eg length check
Database that stores data in multiple tables that are linked
A reference to a primary key in a relational database table.
6
What is the computer language that makes relational databases work?
C++
SQL
Python
Java
7
Which of the following makes it easier for users to enter data into their tables?
Forms
Reports
Queries
SQL View
8
What is the general term for software that creates and manages databases?
Tables
MySQL
DBMS
Microsoft Access
9
Formatted summary of information from a database
Report
Query
Table
Form
10
User-friendly interface for adding to or retrieving information from a database
Form
Query
Report
Table
11
What is the technology that aggregates structured data from one or more sources called?
Relational
Data warehousing
Non-Relational
Big Data
12
Which careers requires advanced programming and analytical skills related to data mining and big data analytics?
Data scientist
Database administrator
Database developer
Data analyst
13
Which of the following database objects provides a summary of data?
Reports
Forms
Tables
Queries
14
A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.
query builder
schema
scalability
constraint
15
Which of the following careers is responsible for backing up and securing an organization's databases?
Database developer
Database administrator
Data analyst
Data scientist
16
A value that's used to identify a record from a linked table is called a ________________.
Primary Key
Borrowed Key
Foreign Key
Car Key
17
Which type of data have elements in common but do not fit into rigid rows and columns in a table?
non-relational
Non-structured
structured
semi-structured
18
Which of the following are the four general tasks a user needs to perform for a database to function properly?
Create, Read, Update, Delete
Create, Reuse, Unleash, Delete
Create, Read, Unleash, Deny
Configure, Read, Update, Deny
19
Stores raw data in a relational database
query
form
table
report
20
Which data type uses historical data to make decisions in the present?
Operational
Analytical
Conceptual
Logical
21
Which data model focuses on high-level concepts?
Operational
Logical
Conceptual
Physical
22
Which of the following is found in one or more columns of data and contains a unique identifier for the row?
Relationship
Attribute
Primary key
Foreign key
23
The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept
Data Extraction
Data Ethics
Data Analytics
Data Mining
24
Which of the following should not be used as a primary key in a table?
Employee ID
SSN
First name
Username
25
Which of the following needs to be done before Big Data can be analyzed and interpreted?
Securing Data
Data Extraction
Data Mining
Data Analytics
26
What are non-relational databases the deal with Big Data often referred to as?
SQL
NoSQL
RDBMS
CRUD
27
Which of the following is a way for programmers and others to make sense of complex business flows?
Database management system
Data Modeling
Primary Keys
Microsoft Access
28
What is Big Data?
A lot of data that aren’t using effectively
Transactions that fit in an ordinary database
QuickBooks or SAP R/3
Massive volume of data of difficult treatment by traditional method
29
Which acronyms describes the traditional way to make sure data stays consistent across the entire database?
CRUD
ACID
DBA
SQL
30
Which SQL command is used to give a user permission to a specific database object?
UPDATE
REVOKE
VALUES
GRANT
