IT Vocab 9

Question 1

The process of asking specific questions to help interpret big data

Answer 1

Big Data Analytics

Question 2

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

Answer 2

Table

Question 3

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

Answer 3

Database Administrator

Question 4

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

Answer 4

Data scientist

Question 5

Data that doesn’t follow a clear pattern

Answer 5

Unstructured data

Question 6

Data that can be divided into discrete categories

Answer 6

Structured Data

Question 7

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

Answer 7

Report

Question 8

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

Answer 8

User Interface Access

Question 9

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

Answer 9

Database developer

Question 10

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

Answer 10

Semi-Structured data

Question 11

a single attribute of each record in a table

Answer 11

Field

Question 12

Nonrelational databases that arise from big data

Answer 12

NoSQL

Question 13

A broad and open-ended analysis of extracted big data

Answer 13

Data Mining

Question 14

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

Answer 14

Data Definition language (DDL)

Question 15

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

Answer 15

Query Builder

Question 16

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

Answer 16

Form

Question 17

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

Answer 17

Query

Question 18

A method of accessing a database using custom computer programs

Answer 18

Programmatic Access

Question 19

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

Answer 19

Database

Question 20

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

Answer 20

Relational Database

Question 21

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

Answer 21

Database Management System (DBMS)

Question 22

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

Answer 22

Foreign Key

Question 23

A field in a table that uniquely identifies a row

Answer 23

Primary key

Question 24

a single instance of an object stored in a database table

Answer 24

Record

Question 25

A computer language used by most relational databases for creating queries

Answer 25

Structured Query Language (SQL)

Question 26

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

Answer 26

Data manipulation language (DML)