Data Flashcards
What is the term for a system that converts large amounts of data into a usable format to help users make business decisions?
Database Management system
Most databases are what kind of database that is multi-dimensional, allowing information to be accessed from various views through linking between entries
Relational database
What traditional system for data is one-dimensional by presenting information from a single point of view and does not interact with other files?
Flat file systems
What integrates stored information from collections of data and maintains it?
Database system
What is the act of analyzing and converting data into information that can be used in decision-making?
Database research
What are the two major layers of a database management system?
An application layer
Database management layer
Which database management layer does not directly manipulate the data, but is used as a tool to obtain the results?
Application layer
The database management layer operates like a what in that it supports the application software?
Operating system
A database table known as a what is composed of records and fields that hold data
Datasheet
Data is store in records representing what in the data table?
Rows
A what is a single piece of data in a data sheet about the subject of record
Field
A what is a column in a data sheet
Field
Fields in a flat file are separated by what?
Delimiters like space or columns
Flat file, relational, hierarchical and object-oriented are some of the most common what?
Database models
In what database model is data organized in a tree-like structure much like an organization all chart
Hierarchical
What is a unique identifier in a relational database called?
Primary key
What code includes queries to identify what data should be retrieved or how the data should be manipulated?
Structured query language (SQL)
Which SQL operation takes rows from one table and creates a new table?
Select
The asterisk in a SQL query means what?
Everything
What keyword is used to identify the table name in a SQL query?
FROM
What SQL keyword precedes the condition the query is requesting?
WHERE
What SQL keyword combines distinct fields form multiple tables that have the same set of attributes and data types?
UNION
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?
CROSS JOIN
What SQL operation combines two tables, but only appended when a matching criterion is met?
JOIN
What type of database stores complex data and relationships between data directly without using inter-table relationships?
Object oriented databases
Object oriented databases is comprised with what two components?
Data
Instructions
What is the term for the instructions found in an object oriented database?
Methods
Key value databases are also known as what?
Stores
In a store, each item in the database is stored as a what together with its value
Attribute name or key
Blank stores are used to store information about networks of data, such as social connections
Graph
Blank stores are optimized for querying on large data sets and store columns of data together instead of in rows
Wide column
Blank databases pair each key with a complete data structure that contains many different key-value pairs
Document format
Blank databases can accommodate a wide variety of databases and is useful with working with large sets of distributed data
NoSQL databases
Blank databases are optimized to work in a cloud environment and include the ability to increase resources to accommodate for demands to the system
Cloud databases
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
Data lake
Data lakes can include both what?
Structured and unstructured data
What consists of data residing on different machines?
Distributed databases
What is the ability to accommodate increased demands while using existing resources?
Scaling
Blank is a DBA responsibility that ensures only authorized users have access and protects against unauthorized access
Database security
Blank is a DBA responsibility that optimizes performance of database systems
Database tuning
Blank is a DBA responsibility that makes replicas of databases available from various locations without disruption
High availability
Blank is a DBA responsibility that ensures core business continues operations effectively even with the disruption of some auxiliary services
Business continuity
Blank is a DBA responsibility that plans for and and executes adequate backup and recover procedures
Backup and recovery
Blank is a DBA responsibility that includes writing complex queries and generating reports for users
Reporting
Blank is writing code to interact with the database resources as a responsibility of the DBA
Designing and developing database applications