MongoDB/NOSQL EXAM WITH COMPLETE
SOLUTIONS 100% CORRECT
JSON - ANSWER JavaScript Object Notation
Horizontal scalability - ANSWER unstructured and semi-structured data: log
files, blogs, tweets, multi-media
vertical scalability - ANSWER structured data: business transactions
(financial transactions, medical records systems,
university and academic records systems):
Structured and organized data; SQL
dynamic
table one instancee of MongoDB can host multiple independeent db can hold its own db
- ANSWER Collection
Column / Field - ANSWER Key
Value - ANSWER Value
Row/Record - ANSWER Document / Object
object - ANSWER an entity that may be utilized in
programming; can be a value,
variable, function, or data structure
, Object ID - ANSWER Any MongoDB object or
document is supposed to have an Object ID
which is unique
_id - ANSWER every document has a unique _id
document - ANSWER single unit of data {"key":"value"}
keys rules - ANSWER cannot be null - null indicates the end of a key
. and $ - ANSWER reserved
no duplicate for a single document can not - ANSWER contain duplicates
to insert into your database - ANSWER <database name>
db.users.help() - ANSWER to get documentation
import files - ANSWER mongoimport --db your_db_name --collection
--your_collection_name --host class-mongodv.cims.nyu.edu --username your_username
--password your_password --type json --file your_json_file_name
db
collection
host
username
password
type
IF CSV --headerline "(CSV file must contain the field names as the first line of the file.)"
file
SOLUTIONS 100% CORRECT
JSON - ANSWER JavaScript Object Notation
Horizontal scalability - ANSWER unstructured and semi-structured data: log
files, blogs, tweets, multi-media
vertical scalability - ANSWER structured data: business transactions
(financial transactions, medical records systems,
university and academic records systems):
Structured and organized data; SQL
dynamic
table one instancee of MongoDB can host multiple independeent db can hold its own db
- ANSWER Collection
Column / Field - ANSWER Key
Value - ANSWER Value
Row/Record - ANSWER Document / Object
object - ANSWER an entity that may be utilized in
programming; can be a value,
variable, function, or data structure
, Object ID - ANSWER Any MongoDB object or
document is supposed to have an Object ID
which is unique
_id - ANSWER every document has a unique _id
document - ANSWER single unit of data {"key":"value"}
keys rules - ANSWER cannot be null - null indicates the end of a key
. and $ - ANSWER reserved
no duplicate for a single document can not - ANSWER contain duplicates
to insert into your database - ANSWER <database name>
db.users.help() - ANSWER to get documentation
import files - ANSWER mongoimport --db your_db_name --collection
--your_collection_name --host class-mongodv.cims.nyu.edu --username your_username
--password your_password --type json --file your_json_file_name
db
collection
host
username
password
type
IF CSV --headerline "(CSV file must contain the field names as the first line of the file.)"
file