MC When are column oriented databases more efficient? When aggregates need to be calculated over many or all rows in the dataset. correct When many columns of a single group need to be fetched at the same time. incorrect When a lot of JOINs need to be performed in queries. incorrect When inserts are performed where all of the row data is supplied at the same time. incorrect
MC What does the following Cypher query express?
OPTIONAL MATCH (user;User)-[:FRIENDS_WITH]-(friend;User)
WHERE user.name = "Bart Baesens"
RETURN user, count(friend) AS NumberOfFriends Get the node for Bart Baesens and a count of all his friends, even if no FRIENDS_WITH relation exists. incorrect Get the node for Bart Baesens and a count of all his friends, but only if at least one FRIENDS_WITH relation exists. correct This query will fail if Bart Baesens is FRIENDS_WITH himself. incorrect Get the node for Bart Baesens and all his friends. incorrect
MC Which of the following statements describes NoSQL databases best? NoSQL databases are not capable to deal with large datasets. incorrect NoSQL databases do not support joins. incorrect A NoSQL database offers no support for SQL. incorrect NoSQL databases are non-relational. correct
MC Using Cypher, how do you get a list of all movies Wilfried Lemahieu has liked, when he has given at least four stars? MATCH (b:User)--(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m incorrect SELECT (b:User)--m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND m.starts >= 4 incorrect MATCH (b:User)-[I:LIKES]-(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m correct MATCH (b:User)-[I:LIKES]-(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND m.stars >=4
RETURN m incorrect
MC Which of the following is not an example of a NoSQL database? Graph based databases. incorrect XML based databases. incorrect Document based databases. incorrect All three can be regarded as NoSQL databases. correct
MC When are column oriented databases more efficient? When many columns of a single group need to be fetched at the same time. incorrect When a lot of JOINs need to be performed in queries. incorrect When inserts are performed where all of the row data is supplied at the same time. incorrect When aggregates need to be calculated over many or all rows in the dataset. correct
MC Which of the following statements describes NoSQL databases best? NoSQL databases do not support joins. incorrect A NoSQL database offers no support for SQL. incorrect NoSQL databases are non-relational. correct NoSQL databases are not capable to deal with large datasets. incorrect
MC What does the following Cypher query express?
OPTIONAL MATCH (user;User)-[:FRIENDS_WITH]-(friend;User)
WHERE user.name = "Bart Baesens"
RETURN user, count(friend) AS NumberOfFriends This query will fail if Bart Baesens is FRIENDS_WITH himself. incorrect Get the node for Bart Baesens and all his friends. incorrect Get the node for Bart Baesens and a count of all his friends, even if no FRIENDS_WITH relation exists. incorrect Get the node for Bart Baesens and a count of all his friends, but only if at least one FRIENDS_WITH relation exists. correct
MC Which of the following statements describes NoSQL databases best? A NoSQL database offers no support for SQL. incorrect NoSQL databases are non-relational. correct NoSQL databases are not capable to deal with large datasets. incorrect NoSQL databases do not support joins. incorrect
MC Which of the following is not an example of a NoSQL database? Graph based databases. incorrect XML based databases. incorrect Document based databases. incorrect All three can be regarded as NoSQL databases. correct