Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Fall 2018 > Mobile App Quiz 4 > Flashcards

Mobile App Quiz 4 Flashcards

1
Q

two main approaches to database

A
  1. RDBMS or SQL

2. noSQL

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

what does RDBMS stand for

A

relational database management system

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

give 3 examples of RDBMS/SQL

A

Oracle, MySQL, Microsoft SQL Server

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

SQL originated in the

A

1970s

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

SQL stores data according to

A

a schema

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

a schema allows data to be

A

displayed as tables with rows and columns

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

SQL stands for

A

Structured Query Language

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

SQL is

A

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

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

general functionality of SQL

A

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

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

what is a query

A

a statement saying what you want to do

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

tables in a relational database have keys used to

A

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

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

pros of SQL

A

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

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

ACID stands for

A

Atomicity, Consistency, Isolation, Durability

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

what does atomicity refer to

A

no partial updates, all or nothing

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

cons of SQL

A

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

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

noSQL stands for

A

not only SQL

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

noSQL is

A

nonrelational

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

key-value stores

A

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

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

examples of key-value stores

A

REDDIS, Amazon Dinamo DB

20
Q

problem with key-value stores

A

collisions

21
Q

wide column stores examples

A

Cassandra, Scylla, HBase

22
Q

wide column stores are

A

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

23
Q

wide column stores scales well enough to

A

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

24
Q

wide column stores are based on

A

CQL, an SQL variant, for data definition and manipulation

25
Q

examples of document stores

A

MongoDB, couch-based

26
Q

documents stores

A

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

27
Q

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

A

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

28
Q

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

A

do not

29
Q

document stores are well-suited to manage

A

semi-structured data across distributed systems

30
Q

graph DBs example

A

NEO4J

31
Q

graph DBs are good for

A

data visualization, graph analytics

32
Q

graph DBs are

A

a network of system nodes or objects

33
Q

search engine DB examples

A

Splunk, Solr

34
Q

search engine DBs are

A

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

35
Q

pros of noSQL

A

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

36
Q

cons of noSQL

A

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

37
Q

Firebase is specifically geared for

A

apps

38
Q

Firebase is an example of

A

noSQL

39
Q

Firebase provides

A

authentication, cloud storage

40
Q

ways to store data

A

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

41
Q

PWA stores data using

A

local and session browser storage (up to 5 MB)

42
Q

local and session browser storage

A

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

43
Q

Ionic uses ? for storage

A

SQLite

44
Q

SQLite is

A

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

45
Q

SQLite does not

A

need to run on the server and does not require configuration

46
Q

one drawback of SQLite

A

may use too much storage on a phone

47
Q

pros of SQLite

A

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

Fall 2018 (24 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions