Data Flashcards

1
Q

What is the term for a system that converts large amounts of data into a usable format to help users make business decisions?

A

Database Management system

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

Most databases are what kind of database that is multi-dimensional, allowing information to be accessed from various views through linking between entries

A

Relational database

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

What traditional system for data is one-dimensional by presenting information from a single point of view and does not interact with other files?

A

Flat file systems

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

What integrates stored information from collections of data and maintains it?

A

Database system

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

What is the act of analyzing and converting data into information that can be used in decision-making?

A

Database research

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

What are the two major layers of a database management system?

A

An application layer
Database management layer

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

Which database management layer does not directly manipulate the data, but is used as a tool to obtain the results?

A

Application layer

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

The database management layer operates like a what in that it supports the application software?

A

Operating system

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

A database table known as a what is composed of records and fields that hold data

A

Datasheet

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

Data is store in records representing what in the data table?

A

Rows

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

A what is a single piece of data in a data sheet about the subject of record

A

Field

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

A what is a column in a data sheet

A

Field

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

Fields in a flat file are separated by what?

A

Delimiters like space or columns

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

Flat file, relational, hierarchical and object-oriented are some of the most common what?

A

Database models

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

In what database model is data organized in a tree-like structure much like an organization all chart

A

Hierarchical

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

What is a unique identifier in a relational database called?

A

Primary key

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

What code includes queries to identify what data should be retrieved or how the data should be manipulated?

A

Structured query language (SQL)

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

Which SQL operation takes rows from one table and creates a new table?

A

Select

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

The asterisk in a SQL query means what?

A

Everything

20
Q

What keyword is used to identify the table name in a SQL query?

A

FROM

21
Q

What SQL keyword precedes the condition the query is requesting?

A

WHERE

22
Q

What SQL keyword combines distinct fields form multiple tables that have the same set of attributes and data types?

A

UNION

23
Q

What SQL keyword creates a results that includes all on the attributes form the two tables concatenating the second table to each row of the first table?

A

CROSS JOIN

24
Q

What SQL operation combines two tables, but only appended when a matching criterion is met?

A

JOIN

25
Q

What type of database stores complex data and relationships between data directly without using inter-table relationships?

A

Object oriented databases

26
Q

Object oriented databases is comprised with what two components?

A

Data
Instructions

27
Q

What is the term for the instructions found in an object oriented database?

A

Methods

28
Q

Key value databases are also known as what?

A

Stores

29
Q

In a store, each item in the database is stored as a what together with its value

A

Attribute name or key

30
Q

Blank stores are used to store information about networks of data, such as social connections

A

Graph

31
Q

Blank stores are optimized for querying on large data sets and store columns of data together instead of in rows

A

Wide column

32
Q

Blank databases pair each key with a complete data structure that contains many different key-value pairs

A

Document format

33
Q

Blank databases can accommodate a wide variety of databases and is useful with working with large sets of distributed data

A

NoSQL databases

34
Q

Blank databases are optimized to work in a cloud environment and include the ability to increase resources to accommodate for demands to the system

A

Cloud databases

35
Q

What is a system of data stored in raw format that is usually a single store of all enterprise data as well as information derived from the data during reporting, transactions or other activities

A

Data lake

36
Q

Data lakes can include both what?

A

Structured and unstructured data

37
Q

What consists of data residing on different machines?

A

Distributed databases

38
Q

What is the ability to accommodate increased demands while using existing resources?

A

Scaling

39
Q

Blank is a DBA responsibility that ensures only authorized users have access and protects against unauthorized access

A

Database security

40
Q

Blank is a DBA responsibility that optimizes performance of database systems

A

Database tuning

41
Q

Blank is a DBA responsibility that makes replicas of databases available from various locations without disruption

A

High availability

42
Q

Blank is a DBA responsibility that ensures core business continues operations effectively even with the disruption of some auxiliary services

A

Business continuity

43
Q

Blank is a DBA responsibility that plans for and and executes adequate backup and recover procedures

A

Backup and recovery

44
Q

Blank is a DBA responsibility that includes writing complex queries and generating reports for users

A

Reporting

45
Q

Blank is writing code to interact with the database resources as a responsibility of the DBA

A

Designing and developing database applications