Data

Question 1

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

Answer 1

Database Management system

Question 2

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

Answer 2

Relational database

Question 3

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

Answer 3

Flat file systems

Question 4

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

Answer 4

Database system

Question 5

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

Answer 5

Database research

Question 6

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

Answer 6

An application layer
Database management layer

Question 7

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

Answer 7

Application layer

Question 8

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

Answer 8

Operating system

Question 9

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

Answer 9

Datasheet

Question 10

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

Answer 10

Rows

Question 11

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

Answer 11

Field

Question 12

A what is a column in a data sheet

Answer 12

Field

Question 13

Fields in a flat file are separated by what?

Answer 13

Delimiters like space or columns

Question 14

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

Answer 14

Database models

Question 15

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

Answer 15

Hierarchical

Question 16

What is a unique identifier in a relational database called?

Answer 16

Primary key

Question 17

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

Answer 17

Structured query language (SQL)

Question 18

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

Answer 18

Select

Question 19

The asterisk in a SQL query means what?

Answer 19

Everything

Question 20

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

Answer 20

FROM

Question 21

What SQL keyword precedes the condition the query is requesting?

Answer 21

WHERE

Question 22

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

Answer 22

UNION

Question 23

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?

Answer 23

CROSS JOIN

Question 24

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

Answer 24

JOIN

Question 25

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

Answer 25

Object oriented databases

Question 26

Object oriented databases is comprised with what two components?

Answer 26

Data Instructions

Question 27

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

Answer 27

Methods

Question 28

Key value databases are also known as what?

Answer 28

Stores

Question 29

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

Answer 29

Attribute name or key

Question 30

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

Answer 30

Graph

Question 31

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

Answer 31

Wide column

Question 32

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

Answer 32

Document format

Question 33

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

Answer 33

NoSQL databases

Question 34

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

Answer 34

Cloud databases

Question 35

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

Answer 35

Data lake

Question 36

Data lakes can include both what?

Answer 36

Structured and unstructured data

Question 37

What consists of data residing on different machines?

Answer 37

Distributed databases

Question 38

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

Answer 38

Scaling

Question 39

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

Answer 39

Database security

Question 40

Blank is a DBA responsibility that optimizes performance of database systems

Answer 40

Database tuning

Question 41

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

Answer 41

High availability

Question 42

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

Answer 42

Business continuity

Question 43

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

Answer 43

Backup and recovery

Question 44

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

Answer 44

Reporting

Question 45

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

Answer 45

Designing and developing database applications