IT Vocab 9 Flashcards

1
Q

The process of asking specific questions to help interpret big data

A

Big Data Analytics

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

A container in a relational database that is comprised of fields (columns) and records (rows)

A

Table

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

A person who is responsible for designing, maintaining, backing up, and securing an organization’s databases

A

Database Administrator

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

A person who focuses on data analysis, especially as it related to data mining and big data analytics. These positions require even more advanced programming and analytical skills

A

Data scientist

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

Data that doesn’t follow a clear pattern

A

Unstructured data

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

Data that can be divided into discrete categories

A

Structured Data

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

An easy-to-read listing of the results of a query

A

Report

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

A method of accessing a database using forms that allow users to interact with the database

A

User Interface Access

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

A person who designs and implements databases, usually by writing SQL code and conducting performance tests to ensure database optimization

A

Database developer

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

Data that has some discrete categories but also other information that doesn’t follow a clear pattern

A

Semi-Structured data

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

a single attribute of each record in a table

A

Field

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

Nonrelational databases that arise from big data

A

NoSQL

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

A broad and open-ended analysis of extracted big data

A

Data Mining

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

Database commands that change the structure, or schema, of the database

A

Data Definition language (DDL)

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

A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database

A

Query Builder

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

A graphical interface that allows users to query a database by filling in information on the form

A

Form

17
Q

A method of asking questions about the data stored in a database

A

Query

18
Q

A method of accessing a database using custom computer programs

A

Programmatic Access

19
Q

A structured set of data held in a computer, usually in a way that is accessible in multiple ways

A

Database

20
Q

A database that is structured to recognize the relationship between items of information

A

Relational Database

21
Q

Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access

A

Database Management System (DBMS)

22
Q

A field in a second table that matches the primary key in another table

A

Foreign Key

23
Q

A field in a table that uniquely identifies a row

A

Primary key

24
Q

a single instance of an object stored in a database table

A

Record

25
Q

A computer language used by most relational databases for creating queries

A

Structured Query Language (SQL)

26
Q

Database commands that modify the records within the database and not the schema itself

A

Data manipulation language (DML)