Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

module 3 > Module 5 > Flashcards

Module 5 Flashcards

1
Q

Which type of analytical data can help you make investment decisions?

Sensor

Market

Machine

Transactional

A

Market

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the general term for software that creates and manages databases?

MySQL

Tables

DBMS

Microsoft Access

A

DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following database objects provides a summary of data?

Queries

Tables

Forms

Reports

A

Reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which data model focuses on high-level concepts?

Conceptual

Logical

Physical

Operational

A

Conceptual

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following DBMS programs is open source?

MySQL

Oracle Database

Microsoft Access

SQL Server

A

MySQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which data type uses historical data to make decisions in the present?

Logical

Conceptual

Operational

Analytical

A

Analytical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which database object is essentially questions that we can ask the database?

Reports

Tables

Forms

Queries

A

Queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which of the following makes it easier for users to enter data into their tables?

Forms

Tables

Queries

Reports

A

Forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.

scalability

query builder

constraint

schema

A

constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the computer language that makes relational databases work?

C++

Java

Python

SQL

A

SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Query builder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

In a relational database table, columns are better known as ________________.

Records

Fields

Categories

Instances

A

Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which process exports a database into a format that can be read by another program like a spreadsheet?

CSV

CRUD

Database dump

Database backup

A

Database dump

17
Q

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

A

Report

18
Q

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

A

Programmatic access

19
Q

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

A

Query

20
Q

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

A

Create, Read, Update, Delete

21
Q

Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database?

DBA

SQL

ACID

CRUD

A

ACID

22
Q

What is asking specific questions to interpret Big Data called?

Data mining

Data extraction

Data ethics

Data analytics

A

Data analytics

23
Q

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

A

Big Data

24
Q

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

A

Big Data

25
Q

Which type of data have elements in common but do not fit into rigid rows and columns in a table?

Structured

Non-structured

Semi-structured

Non-relational

A

Semi-structured

26
Q

The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept?

Data mining

Data analytics

Data extraction

Data ethics

A

Data ethics

27
Q

Which of the following needs to be done before Big Data can be analyzed and interpreted?

Data extraction

Securing data

Data analytics

Data mining

A

Data extraction

28
Q

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice?

Database Management System

Relational database

Binary flat file

Text-based flat file

A

Text-based flat file

29
Q

What are non-relational databases that deal with Big Data often referred to as?

RDBMS

NoSQL

SQL

CRUD

A

NoSQL

30
Q

What is the technology that aggregates structured data from one or more sources called?

Non-relational

Data warehousing

Relational

Big Data

A

Data warehousing

module 3 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions