Mobile App Quiz 4

Question 1

two main approaches to database

Answer 1

1. RDBMS or SQL

2. noSQL

Question 2

what does RDBMS stand for

Answer 2

relational database management system

Question 3

give 3 examples of RDBMS/SQL

Answer 3

Oracle, MySQL, Microsoft SQL Server

Question 4

SQL originated in the

Answer 4

1970s

Question 5

SQL stores data according to

Answer 5

a schema

Question 6

a schema allows data to be

Answer 6

displayed as tables with rows and columns

Question 7

SQL stands for

Answer 7

Structured Query Language

Question 8

SQL is

Answer 8

a collection of tables each with a schema that represent fixed attributes and data types that the items in the table will have

Question 9

general functionality of SQL

Answer 9

CRUD (create, read, update, delete) which is all done by writing a query

Question 10

what is a query

Answer 10

a statement saying what you want to do

Question 11

tables in a relational database have keys used to

Answer 11

identify specific columns or rows of a table to facilitate a particular table, row, or column of interest

Question 12

pros of SQL

Answer 12

well-documented, standards are well-defined and commonly accepted (know how to use one, can use all), work really well with structured data, ACID-compliant, limitless indexing

Question 13

ACID stands for

Answer 13

Atomicity, Consistency, Isolation, Durability

Question 14

what does atomicity refer to

Answer 14

no partial updates, all or nothing

Question 15

cons of SQL

Answer 15

doesn’t work well with unstructured data, to migrate from one database to another, both schemas/structures must match, data is normalized (remove repetitive fields and put in new table), does not scale horizontally very well

Question 16

noSQL stands for

Answer 16

not only SQL

Question 17

noSQL is

Answer 17

nonrelational

Question 18

key-value stores

Answer 18

simple database that only stores key-value pairs; has basic functionality for retrieving the value associated with a known key

Question 19

examples of key-value stores

Answer 19

REDDIS, Amazon Dinamo DB

Question 20

problem with key-value stores

Answer 20

collisions

Question 21

wide column stores examples

Answer 21

Cassandra, Scylla, HBase

Question 22

wide column stores are

Answer 22

schema agnostic; store data in column families or tables with a single row thought of as a record; multi-dimensional key-value store

Question 23

wide column stores scales well enough to

Answer 23

manage pedabytes of data across as many as 1000 servers (good for big data)

Question 24

wide column stores are based on

Answer 24

CQL, an SQL variant, for data definition and manipulation

Question 25

examples of document stores

Answer 25

MongoDB, couch-based

Question 26

documents stores

Answer 26

schema-free, save data in form of JSON documents, can contain many different value types

Question 27

document stores are similar to key-value or wide-column except

Answer 27

the document name is the key and the content is the value

Question 28

documents stores: individual records (do/do not) require uniform structure

Answer 28

do not

Question 29

document stores are well-suited to manage

Answer 29

semi-structured data across distributed systems

Question 30

graph DBs example

Answer 30

NEO4J

Question 31

graph DBs are good for

Answer 31

data visualization, graph analytics

Question 32

graph DBs are

Answer 32

a network of system nodes or objects

Question 33

search engine DB examples

Answer 33

Splunk, Solr

Question 34

search engine DBs are

Answer 34

schema-free JSON documents similar to document stores, but with greater emphasis on making data easily accessible via text-base searches with Strings of varying complexity

Question 35

pros of noSQL

Answer 35

schema free, more flexible, easier to administer; more horizontally scalable and fault tolerant; data can be easily distributed across different nodes; less strict JSON docs

Question 36

cons of noSQL

Answer 36

newer, less widely adopted, specific expertise often required, range of formats and constraints specific to each type

Question 37

Firebase is specifically geared for

Answer 37

apps

Question 38

Firebase is an example of

Answer 38

noSQL

Question 39

Firebase provides

Answer 39

authentication, cloud storage

Question 40

ways to store data

Answer 40

native (on phone), local and session browser storage, SQLite

Question 41

PWA stores data using

Answer 41

local and session browser storage (up to 5 MB)

Question 42

local and session browser storage

Answer 42

not highly regarded, only use if app still knows user is logged in between pages, Ionic doesn't usually utilize (session storage good though)

Question 43

Ionic uses ? for storage

Answer 43

SQLite

Question 44

SQLite is

Answer 44

an embedded SQL database that can run on a mobile device also used by native apps

Question 45

SQLite does not

Answer 45

need to run on the server and does not require configuration

Question 46

one drawback of SQLite

Answer 46

may use too much storage on a phone

Question 47

pros of SQLite

Answer 47

persistent data storage, no size limitation on data stored, provides SQL syntax