Module 5 Flashcards
Which type of analytical data can help you make investment decisions?
Sensor
Market
Machine
Transactional
Market
What is the general term for software that creates and manages databases?
MySQL
Tables
DBMS
Microsoft Access
DBMS
Which of the following database objects provides a summary of data?
Queries
Tables
Forms
Reports
Reports
Each type uses different techniques and serves a different purpose. That said, almost all ___________________ share the following characteristics and features.
Storage
Processing
Databases
Human-computer interaction
Databases
Which data model focuses on high-level concepts?
Conceptual
Logical
Physical
Operational
Conceptual
Which of the following is found in one or more columns of data and contains a unique identifier for the row?
Relationship
Foreign key
Attribute
Primary key
Primary key
Which of the following DBMS programs is open source?
MySQL
Oracle Database
Microsoft Access
SQL Server
MySQL
Which data type uses historical data to make decisions in the present?
Logical
Conceptual
Operational
Analytical
Analytical
Which database object is essentially questions that we can ask the database?
Reports
Tables
Forms
Queries
Queries
Which of the following makes it easier for users to enter data into their tables?
Forms
Tables
Queries
Reports
Forms
A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.
scalability
query builder
constraint
schema
constraint
What is the computer language that makes relational databases work?
C++
Java
Python
SQL
SQL
Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be her BEST option to generate the report?
User interface access
Programmatic access
Direct access
Query builder
Query builder
Match each database object on the left to its description on the right.
Formatted summary of information from a database.
User-friendly interface for adding to or retrieving information from a database.
Stores raw data in a relational database.
Retrieves specific information from a database. Can also be used to update, edit, and delete information.
Report, form , table and Query
Formatted summary of information from a database.
correct answer:
Report
User-friendly interface for adding to or retrieving information from a database.
correct answer:
Form
Stores raw data in a relational database.
correct answer:
Table
Retrieves specific information from a database. Can also be used to update, edit, and delete information.
correct answer:
Query
In a relational database table, columns are better known as ________________.
Records
Fields
Categories
Instances
Fields
Which process exports a database into a format that can be read by another program like a spreadsheet?
CSV
CRUD
Database dump
Database backup
Database dump
Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?
Record
SQL command
Report
Form
Report
A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use?
User interface access
Direct access
Programmatic access
Query builder
Programmatic access
Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this?
Form
Query
Table
Report
Query
Which of the following are the four general tasks a user needs to perform for a database to function properly?
Configure, Read, Update, Deny
Create, Reuse, Unleash, Delete
Create, Read, Update, Delete
Create, Read, Unleash, Deny
Create, Read, Update, Delete
Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database?
DBA
SQL
ACID
CRUD
ACID
What is asking specific questions to interpret Big Data called?
Data mining
Data extraction
Data ethics
Data analytics
Data analytics
Vast amounts of data are collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. What is this known as?
Data mining
Data extraction
Big Data
Data analytics
Big Data
The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________.
Business Data
Omni Data
Metadata
Big Data
Big Data
